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