Take all the numbers value till before alphabets starts in the given Alphanumeric string

Help Studio
,
1

Hi all,

I need a syntax on below case.

49630801Q should come as 49630801

49623500Q1 should come as 49623500

49621200AT1 should come as 49621200

regular expression and other approaches also fine.

regards,
Prabhu

2

Hi @prabhu_ponnusamy

Below is the regex for the same :-

image

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

3

@prabhu_ponnusamy
as a variation bound on the Letter:
grafik

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.