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

[Robert Rogerson <rogersonra@xxxxxxxxx>]

Or how about search for  /- and then convert everything to the end of the
string to a number?

Rob

On Wed, Jul 29, 2020 at 1:28 PM Steve M via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Art,
>
> How consistent is the number format?  You could search from the right for a
> decimal (period) and then go two to the right and one to the left of that
> location.  A more direct "hit" that the space search IMHO.
>
> Steve Meisinger
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Art
> Tostaine, Jr.
> Sent: Wednesday, July 29, 2020 12:16
> 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