Extract number after text

Krish2459_58 · ‎2023-09-20

Hi,

I need to extract number form the text like

Scenario1:

123ABC678

Req output: 678

Scenario2:

123ABC678

Req output: ABC678

Please share your suggestions.

Thanks..

brunobertels · ‎2023-09-20

Hi

if the format is always 3 last digit a integer and always 6 last digits as text and integer use right function

right('123ABC678', 3 ) will give 678

right('123ABC678', 6 ) will give ABC678

Krish2459_58 · ‎2023-09-20

Hi ,

The logic should be dynamic to handle the datalike below.

000ACC34: output(34)

22BNZ113 : output (BNZ113 )

000ACC34

22BNZ113

Aditya_Chitale · ‎2023-09-20

What is the criteria that determines whether you want to extract last 3 characters or last 6 characters ?

For eg:

In what scenario you want to extract only the last digit part from string ? Eg: 000ACC34: output(34)

Same goes for 22BNZ113 : output (BNZ113 ). Why you want to extract BNZ along with 113 ? and not only 113 like above example ?

Regards,

Aditya