Re: Getting data into a PF from an Excel spreadsheet

[Booth Martin <booth@xxxxxxxxxxxx>]

How do you do tab-delimited?  What is the hex to insert?  As in:



 D  Tab      c          '????'

 C         eval   record = City + Tab + State + Tab + zip



Scott Klement wrote:
> James Lampert wrote:
>   
> > But would that work for data that has commas and other punctuation (and 
> > in one column, what appear to be CRLFs) in it?
> >
> >     
>
> Consider using tab-delimited files instead of CSV.  There's no drawbacks 
> that I know of to using tab-delimited, and it solves all of the CSV 
> problems.
>
> Not sure why so many people recommend CSV, it has always had problems 
> with commas and quotes -- tab delimited never has had these problems.
>