Please help with Regex pattern to retrieve reference

Hello, please i want to get the reference “BOT2020092701485595” from the string “REV~BOT2020092701485595”… I want to use a regex because i am not sure of what might be in front of the reference i.e it could be REVERSAL-BOT2020092701485595 the numbers that follow the word “BOT” is always going to be 16.

Hello @David_Oku,

You can try this regular expression

“BOT\d{16}” or this “BOT\d+”

Thanks & Regards,
Urvesh Mistry

3 Likes

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