Import question

[Richard D. Williams]

You could treat this line of data as a separate import.

Export this line to a different file. Then import it back using the ^ as 
a field separator.
Now you can treat them individually and it doesn't matter how many they 
send.

Just a thought.

Richard D. Williams


On 3/10/2021 2:57 PM, scooter6--- via Filepro-list wrote:
> So I have an import routine that imports a csv of some parsed XML
> It's pretty detailed and I use a ton of variables
> My question is, let's suppose I have a field that has over a 100 fields
> within it, separated by a ^
>
> For example, if I'm importing a huge list of amounts, the field I need to
> breakdown can have 100 or more that are
>
> 100.00^21.20^50.00^62.50^33.12..........etc
>
> Is there an easier way than using strtok to parse large fields like this?
>
> I originally didn't think there would ever be more than 40, but some of my
> brilliant clients who don't always know what they're doing in our
> integrated partner's software, have sometimes managed to have 100 or more -
> so trying to see if there is a better/simpler way to do this
>
> Otherwise, I'm going to spit it off into its own file and create a lookup
> screen on the records - which I can do, but didn't really want to go that
> route if not necessary
>
> I currently parse the incoming XML with xsltproc and create a csv file and
> that all works well - I'm trying to come up with possibly a better way to
> get that into my fp databases
>
> thanks for any input
>
> Scott
> PDM
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20210310/7355e9f7/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>