Import question

[Richard D. Williams]

Sorry. Please ignore my reply.

I did not see the that you had already thought of the export idea.

Richard D. Williams


On 3/10/2021 3:54 PM, Richard D. Williams via Filepro-list wrote:
> 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
>>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>


-- 
This email has been checked for viruses by AVG.
https://www.avg.com