Hi I would just like to ask if how can I the first 5 digits in this value:
USD1280007021502
Expected output:
12800
I want to remove the USD also and retain the first 5 digits after USD.
@dunkindonut7777
We can either use a SubString function or Regex for tihs purpose.
if it is not always USD, but it is the first 5 digits after letters, you can do this regular expression:
\D+(\d{5})\d+
\D = any non digit
\d{n} = specific number of digits
() = the capturing group
regex101.com is a SUPER helpful site to test your regular expressions.
If this solution was helpful, please mark as a solution to help the other members on the community out!
Thanks :)