Top Post Re: Import Dif Help

Kenneth Brody kenbrody at spamcop.net
Sun Jun 19 19:47:30 PDT 2011


On 6/19/2011 10:26 AM, haroldef wrote:
[...]
> When using Then IMPORT ASCII tst=c:\temp\test.txt R=^J f=, O=" C=", as
> suggested in the manual a lookup was performed on testmac using last name,
> first name and city from the csv file, but I could never get the lookup to
> find he proper name. The problem was probably the R=, F=, O= and C=, but I
> could not what these items should be.

If the file is a Windows text file, then "r=^J" will cause the last field on 
each import line to end with a Ctrl-M.  (The Windows end-of-line is 
Ctrl-M/Ctrl-J.)  You need "r=\n" to specify "newline" as the end-of-record 
character.

>
> I solved the problem of importing a csv file by using the simple:
>
> Then: IMPORT word tst=c:\appl\mac_email_address\text.txt

That is because "import word" defaults to "r=\n".

> I changed the csv file name from something.csv to text.txt, and it now
> corrects the email addresses in the file testmac.

No need to change the filename.  The file is in CSV format, so ".csv" is a 
natural extension.

-- 
Kenneth Brody


More information about the Filepro-list mailing list