dtox

[smittyusn1 at bellsouth.net]

AbsoClutely Perfect  George,  let the fp expert?  BS artists begin ..... 
laugh

Wayne Smith
Port Orange, Florida



----- Original Message ----- 
From: "Jean-Pierre A. Radley" <appl at jpr.com>
To: "FilePro Mailing List" <filepro-list at lists.celestial.com>
Sent: Thursday, August 06, 2009 2:46 PM
Subject: Re: dtox


> 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
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list