dtox

[Jean-Pierre A. Radley]

George propounded (on Wed, Aug 05, 2009 at 02:24:20PM -0500):
| Trying to import a .xls file into fp5.0. Ran it through the Unix dtox
| utility.  Loading it up in vi shows $ at the end of the record...employing
| "set List" in vi still shows the $...in hex it looks like an 0d. It's a .csv
| with "," between fields. I've been out of this for over a year and rusty
| here.

Hex 0d is a carriage return. Dtox chould have removed it. Try cr+-:

	#!/bin/sh
	#@(#)cr+-   JPRadley v 1.1
	#@(#)adds CRs if not present, strips them if present
	#@(#)if you just cat this file, you miss its essence, so instead
	#@(#)cat -v this file so as to see two actual ^M that it contains
	sed '
	s-^M--g
	t
	s+$+^M+
	t
	'

| Is it:
| Import ascii test=test.txt r=^ f=,

I should think

	import ascii text=text r=\r
| 
| And JP thanks for your tolerance. First post in years.

Tolerance about what?

But since you invoked my name: please do NOT start a new topic on this
or any other mailing list by posting a REPLY to a prior thread.  Please
don't do that; I see your message as part of the prior thread, which is
misleading.  There is absolutely no charge to start your own brand new
thread.

Thanks!

-- 
JP