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