Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, use the function PURGECHAR() or KEEPCHAR()
See.
PurgeChar('B9867HH','ABCDEFGHIJKLMNOPQRSTUWYVXZ') RESULT IS 9867.
or
KeepChar('B9867HH','0123456789') RESULT IS 9867.
Best Regards.
Tonial.
Hi, use the function PURGECHAR() or KEEPCHAR()
See.
PurgeChar('B9867HH','ABCDEFGHIJKLMNOPQRSTUWYVXZ') RESULT IS 9867.
or
KeepChar('B9867HH','0123456789') RESULT IS 9867.
Best Regards.
Tonial.
hi try this
purgechar ( 'a1b2c3','123' ) returns 'abc'
or try this
purgechar ( 'a1b2c3','abc' ) returns 123
Thanks a lot
Hi
Use:
KeepChar(myCode, '0123456789')
HTH
Jonathan
Please check QVW
try this
keepchar ( 'B987HH','12345679' ) returns '123'