import question

[scooter6 at gmail.com]

I will have ongoing csv files that I need to import into a filePro database

The beginning of each line is static, in that it will say one of 4-5 things
- based on field 1, it goes to a different part of the import
There is one that will start with   'Charges|'   (it's a pipe delimited
file)
The 2nd field is used to look up the record

Each record in filePro can have up to 40 charges in it

Since the inbound csv file won't necessarily be sorted in order of field 2
(the key to lookup the record) - is there a simpler way to know which field
to put the new charge in vs having to say

if charge field 1 is not "" but charge field 2 is blank, then put this
charge in field 2 and so on?
The bottom line will be if all 40 charge fields are not empty, it will skip
the record (which I have that part - ) just wondering if there's an easier
way I'm not thinking of than to 'step' through each charge field until I
find the first empty one....

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