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

Isn't the value always bracketed by /- and ~? Wouldn't it be a simple
matter of finding those two values, stringing out what's between and
trimming it?


date: Wed, 29 Jul 2020 13:16:06 -0400

from: "Art Tostaine, Jr." <atostaine@xxxxxxxxx>
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