high-ascii field delimiter when importing XML?

Kenneth Brody kenbrody at spamcop.net
Wed Jun 22 13:48:56 PDT 2011


On 6/22/2011 2:55 PM, Mike Schwartz wrote:
[...]
>       I tried to use a high-Ascii character (192), but this doesn't appear to
> work:

DDW.

And what's with the "doesn't _appear_ to work" that people seem to like?

> import ascii infil=(fname) r=\n f=192
>
>       The next line is:
>
> If         : not infil
> then   : msgbox "# of lines read is"<loopcount; return
>
>       The msgbox pops up the message "# of lines read is 0" even though there
> are dozens of lines in the XML data file.
>
>       Debug confirms that "not infile" is true the very first time I hit the
> import.   If I change the f= to ~ or /F, the XML data lines get returned to
> me as expected.
>
>      Should f=192 be valid on an import line in filePro 5.0.14?  It does pass
> the syntax check...

Yes, it's valid.

>      Since it is unlikely that form-feed characters will be in the XML data,
> for the time being I will use f=\f:
>
>     import ascii infil=(fname) r=\n f=\f

Well, my first question is "is there really a character 192 in the file to 
act as a delimiter?"

-- 
Kenneth Brody


More information about the Filepro-list mailing list