I'm trying to figure out a way to parse a value out of a text string. The text strings are variable length, so the MID, Left, Right functions will not work.
Is there a way to have it find a character in the string and take the numeric values to the right out and place them in a new field?
For example:
! 1323 ABC#2146382227 OTHR#5084957 DISB NP PRPS$27!
In this example, I simply need to parse out the very last number "27" out of the string. In all cases, the "$" preceeds the value I want.
Any suggestions?
Is there a way to have it find a character in the string and take the numeric values to the right out and place them in a new field?
For example:
! 1323 ABC#2146382227 OTHR#5084957 DISB NP PRPS$27!
In this example, I simply need to parse out the very last number "27" out of the string. In all cases, the "$" preceeds the value I want.
Any suggestions?