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

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Art,

From the manual, "If the first parameter is longer than the second 
parameter, the additional characters in the first parameter
are ignored."

However, even if that worked, what would happen with your 1st example?

NTE*OTH*#F7- PST/SALES TAX GAZE9H01/MNT/ / 6/- 1.23~ 7 9 01 6 1.23 
Assuming %dec ignores all spaces, which the manual says, you'd end up 
with 790161.23. Not sure if negative or positive sign matters in your 
situation. -- *Peter Dow* /Dow Software Services, Inc. 909 793-9050 
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx> pdow@xxxxxxxxxxxxxx 
<mailto:pdow@xxxxxxxxxxxxxx> /
On 7/29/2020 10:28 AM, Art Tostaine, Jr. wrote:

> I tried this but it's not replacing anything. I was thinking I 
> couldremove anything that isn't a number and then use %DEC. The field 
> name is NTE nte = %xlate('ABCDEFGHIJKLMNOPQRSTUVWXYZ':' ':nte); nte = 
> %xlate('!@#$%^&*()_-+=\|]}[{:;/?.>,<':'':nte); nte = %xlate(quote:'':nte);