import

[scooter6 at gmail.com]

I have a pipe delimited file that I'm looking to import
It does however contain 4-5 fields that have ^ in them which denotes there
are multiple items of data in a single field....
Is there a way to pull the specific field of an import and put it in an
array to pair with the filed after it...

For example, a field has       abc1234^xyz6789      (so this field contains
2 pieces of information
The very next field has     filename.pdf^filename2.pdf    (so this field
also contains 2 pieces of information)

My filePro file has fields called   set1, set1-file, set2, set2-file,
etc.....
I want to be able to assign  abc1234 to the field called set1 and
filename.pdf to set1-file; and assign xyz6789 to set2 and filename2.pdf to
set2-file

Is there a way to pull a field into an array and declare a character (in
this case, the ^ ) as a sepator for the array....or is there even a simpler
way to do this without doing a bunch of mid statements, etc?

thanks

Scott
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20180115/03f78196/attachment.html>