hidden character ?

[Nancy Palmquist]

Steven Waters wrote:
> SCO UNIX / FP5.0.14
> 
> I'm Back!
> Thanks again for all of the help on Monday & Tuesday.
> 
> After importing my data from csv to Filepro
> (not really csv, I changed the "," to "~")
> the very last field that imported has a 
> question mark at the end of the data like this;
> 
> Triumph Controls?
> 
> When I print out the field the "?" is gone.
> What is this character that I am seeing?
> Is my import wrong?
> 
> import ascii imp = /f/appl/fpmerge/tgicaps.csv r=\n f=~ 
> 
> Thanks Again?
> Steve? 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
> 
It is a hex(0D) or carriage return.  It appears as a ? in a lot of editors.

The r=\n will put a 0D0A (CRLF) as a record seperator on a Windows
system and a 0A (LF) on a *NIX system.  If you move the file across
platforms, the codes need to be modified for the new system.

When someone asks me for a csv file, I always format for CRLF (windows
version).  It always ends up there. (99.9%)

If someone else made it, then they made it on a Windows computer and you
are trying to read it on Unix, the CR is extraneous.

Tools to fix it:

SCO UNIX -
The command I use on SCO stuff -

dtox <dosfile >unixversion

MORE common command for all *NIX stuff:

tr -d '\012' <dosfile >unixfile

Then when you import it will not have the ? in the data.

Nancy



-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com