Re: How to get the dollar value from this text string?

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Write up an RFE if you think it is needed.

There are obviously a bunch of folks here who would vote for it - including me - although he thought of teaching it is daunting.



> On Aug 7, 2020, at 7:10 PM, Vlad Korge via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> I would definitely go with regex. It's shame that the "modern" RPG is
> missing the regex native function and so you have to use SQL for the
> purpose. 
> Still, much more flexible and common approach than dealing with SCANs etc. 
>
> Cheers,
> Vlad.
>
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
> Art Tostaine, Jr.
> Sent: Thursday, July 30, 2020 5:16 AM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: How to get the dollar value from this text string?
>
> Here are some samples. need to extract 1.23 here.  I was thinking of reading
> backwards looking for a space.  Any better ideas?  Thank you.
>
> NTE*OTH*#F7- PST/SALES TAX GAZE9H01/MNT/   /  6/- 1.23~
>
> NTE*OTH*#F7- PST/SALES TAX GSYE9R03/WHT/   / 4T/- 1.22~
>
> NTE*OTH*#OH- HANDLING CHARGES GAZE9H01/MNT/   /  6/- 3.36~
>
> NTE*OTH*#OH- HANDLING CHARGES GSYE9R03/WHT/   / 4T/- 2.29~
>
> --
> Art Tostaine
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link:
> https://amazon.midrange.com
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com