<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
A good way to handle this might be to chunk away at it;<br>
<br>
dim codes(500)<br>
<br>
string: 100.00^21.20^50.00^62.50^33.12<br>
z="100.00^21.20^50.00^62.50^33.12"<br>
<br>
<font face="Courier New, Courier, monospace">getcodes if : not(z co
"^")<br>
then: return<br>
if :<br>
then: p(5,.0)=instr(z,"^")<br>
if : p ge "1"<br>
then:
n=n+"1";code(n)=""{mid(z,"1",n-"1");mid(z,"1",n)="";z=""{z<br>
if : n eq "500"<br>
then: return<br>
if :<br>
then: goto getcodes</font><br>
<div class="moz-cite-prefix"><br>
Richard<br>
<br>
On 3/10/2021 4:14 PM, <a class="moz-txt-link-abbreviated" href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CADpQzqPfzG8ziCx3HSECtRD1cnzjY=-zne2J1o-M7DLojC1gtA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">Actually, my thought was skipping this field in the
main import, then running a 2nd import to a file called
'charges' lets say, then when the open the record in the main
file, one of the screens will have a browse lookup window to the
charges file - just wondered if there was a way I hadn't thought
of yet
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Wed, Mar 10, 2021 at 5:06
PM Richard D. Williams via Filepro-list <<a
href="mailto:filepro-list@lists.celestial.com"
moz-do-not-send="true">filepro-list@lists.celestial.com</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Sorry.
Please ignore my reply.<br>
<br>
I did not see the that you had already thought of the export
idea.<br>
<br>
Richard D. Williams<br>
<br>
<br>
On 3/10/2021 3:54 PM, Richard D. Williams via Filepro-list
wrote:<br>
> You could treat this line of data as a separate import.<br>
><br>
> Export this line to a different file. Then import it back
using the ^ <br>
> as a field separator.<br>
> Now you can treat them individually and it doesn't matter
how many <br>
> they send.<br>
><br>
> Just a thought.<br>
><br>
> Richard D. Williams<br>
><br>
><br>
> On 3/10/2021 2:57 PM, scooter6--- via Filepro-list wrote:<br>
>> So I have an import routine that imports a csv of
some parsed XML<br>
>> It's pretty detailed and I use a ton of variables<br>
>> My question is, let's suppose I have a field that has
over a 100 fields<br>
>> within it, separated by a ^<br>
>><br>
>> For example, if I'm importing a huge list of amounts,
the field I <br>
>> need to<br>
>> breakdown can have 100 or more that are<br>
>><br>
>> 100.00^21.20^50.00^62.50^33.12..........etc<br>
>><br>
>> Is there an easier way than using strtok to parse
large fields like <br>
>> this?<br>
>><br>
>> I originally didn't think there would ever be more
than 40, but some <br>
>> of my<br>
>> brilliant clients who don't always know what they're
doing in our<br>
>> integrated partner's software, have sometimes managed
to have 100 or <br>
>> more -<br>
>> so trying to see if there is a better/simpler way to
do this<br>
>><br>
>> Otherwise, I'm going to spit it off into its own file
and create a <br>
>> lookup<br>
>> screen on the records - which I can do, but didn't
really want to go <br>
>> that<br>
>> route if not necessary<br>
>><br>
>> I currently parse the incoming XML with xsltproc and
create a csv <br>
>> file and<br>
>> that all works well - I'm trying to come up with
possibly a better <br>
>> way to<br>
>> get that into my fp databases<br>
>><br>
>> thanks for any input<br>
>><br>
>> Scott<br>
>> PDM<br>
>> -------------- next part --------------<br>
>> An HTML attachment was scrubbed...<br>
>> URL: <br>
>> <<a
href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20210310/7355e9f7/attachment.html"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://mailman.celestial.com/pipermail/filepro-list/attachments/20210310/7355e9f7/attachment.html</a>><br>
>> _______________________________________________<br>
>> Filepro-list mailing list<br>
>> <a href="mailto:Filepro-list@lists.celestial.com"
target="_blank" moz-do-not-send="true">Filepro-list@lists.celestial.com</a><br>
>> Subscribe/Unsubscribe/Subscription Changes<br>
>> <a
href="http://mailman.celestial.com/mailman/listinfo/filepro-list"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
>><br>
><br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com"
target="_blank" moz-do-not-send="true">Filepro-list@lists.celestial.com</a><br>
> Subscribe/Unsubscribe/Subscription Changes<br>
> <a
href="http://mailman.celestial.com/mailman/listinfo/filepro-list"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
><br>
<br>
<br>
-- <br>
This email has been checked for viruses by AVG.<br>
<a href="https://www.avg.com" rel="noreferrer" target="_blank"
moz-do-not-send="true">https://www.avg.com</a><br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com"
target="_blank" moz-do-not-send="true">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a
href="http://mailman.celestial.com/mailman/listinfo/filepro-list"
rel="noreferrer" target="_blank" moz-do-not-send="true">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote>
</div>
</blockquote>
<br>
</body>
</html>