Extracting numbers between text.

[#1]

Hello All,

Please help I have to extract number between text.

Example: my string contains B1234, B987HH etc I have to write a script to extract only number from the string.

String B9867HH to 9867

String B1234 to 1234

Thanks

[fernando_tonial · Accepted solution]

Hi, use the function PURGECHAR() or KEEPCHAR()

See.

PurgeChar('B9867HH','ABCDEFGHIJKLMNOPQRSTUWYVXZ') RESULT IS 9867.

or

KeepChar('B9867HH','0123456789') RESULT IS 9867.

Best Regards.

Tonial.

[#3]

hi try this

purgechar ( 'a1b2c3','123' ) returns 'abc'

or try this

purgechar ( 'a1b2c3','abc' ) returns 123

[#4]

Thanks a lot

[jonathandienst]

Hi

Use:

KeepChar(myCode, '0123456789')

HTH

Jonathan

[saumyashah90]

Please check QVW

[#7]

try this

keepchar ( 'B987HH','12345679' ) returns '123'