import question

[Josh Reader]

Hi Scott,

I remember Nancy saying something at the conference about @AF if you have associated fields.  I haven't used that command yet but possibly if you associate all 40 fields you could use something like if A1 eq "" and then use @AF to tell you what that blank field number is to be able to write to it?  Hopefully she'll post if that would be possible with your scenario.  I have a note from the conference saying to look into @AF but I haven't had a chance to experiment yet.

Josh


-----Original Message-----
From: Filepro-list <filepro-list-bounces+josh.reader=mercuryelectronics.com at lists.celestial.com> On Behalf Of scooter6--- via Filepro-list
Sent: Thursday, October 31, 2019 4:36 PM
To: filePro Mailing List <filepro-list at lists.celestial.com>
Subject: import question

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>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list