lindadudley
Technical User
I have an 80 byte record and somewhere there is a numeric value located within the text. How can I extract just the number from the text; the size of the number will vary as well as the location in the text.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
string = "....abcdefg 247 mary had a little lamb;"
pt = Verify(str,"0123456789","M") /* 13 */
pt2 = Verify(str,"0123456789","N") /* 16 */
number = Substr(str,pt,pt2-pt) /* from 13, length 3 */