high-ascii field delimiter when importing XML?
Mike Schwartz
mschw at athenet.net
Wed Jun 22 11:55:54 PDT 2011
Linux 2.6.37-13-default, filePro 5.0.14
I'm importing an XML data file and decided to use "import" because it
was easier to setup than "open" or other methods.
Initially I was using this line, which sets a tilde as the field
delimiter:
import ascii infil=(fname) r=\n f=~
It works OK, but there might be tilde's in the data, so I was looking
for the safest field delimiter to use; i.e. a delimiter that will read a
full line into infil(1) without the possibility of breaking the line into
separate fields.
I tried to use a high-Ascii character (192), but this doesn't appear to
work:
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...
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
Thanks,
Mike Schwartz
More information about the Filepro-list
mailing list