Hi everyone,
Thanks for taking a look at my scenario:
I am trying to extract a numeric account number that can be various digits in length from a Description column that has multiple consolidated values and the account number does not appear at the same position within the text. To make matters more complicated, each of the descriptions can contain various terminology to indicate the account number. In some cases, "account" will precede the number, other times "to" or "from" precedes the account number. It can vary widely across the text.
Is there a way to utilize the Regex tool in order to extract the numeric account string? I've attached a scrubbed list of examples with a tab that includes the values illustrating the desired results.
Thanks in advance for your help!
HG
Thank you Felipe!
Thank you Dina!
Thank you Flying 008!
Yes, @us475279 - kindly mark @Felipe_Ribeir0 @Dina @flying008 's solutions as accepted solutions so that we can close the thread and it helps others identify the solution faster.
Thanks!