Import question

[Fairlight]

My xml2csv program creates CSVs which are two columns wide.  Field name
or action (like tag_open, tag_close, etc.).  You just walk through the
data relationships as you go.

My website has been 'under reconstruction' since I moved it a couple
years back, so if you want more information, you'll have to email me
privately.  I still sell it; the website is just in pieces as I shift to
WordPress, and it's a low, low priority for me.

m->


On Wed, Mar 10, 2021 at 03:57:43PM -0500, scooter6--- via Filepro-list thus spoke:
> 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
> 

-- 
Audio panton, cogito singularis.