SOLVED
Regex Expression
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
dillonrispoli
5 - Atom
‎07-05-2023
06:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to extract the "Prod CAT/ID" characters along with the information listed for each state. Any ideas given the data is all in column A? I think Regex could be helpful here, however, I am not too familiar with the syntax.
Solved! Go to Solution.
3 REPLIES 3
geraldo
13 - Pulsar
‎07-05-2023
08:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
15 - Aurora
‎07-05-2023
08:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @dillonrispoli ,
Here is one way of doing this. I hope this helps.
Output
You can rename the column as you like.
PageNo | ProdCatID | Col1 | Col2 | Col3 | Col4 | Col5 | Col6 | Col7 | Col8 | Col9 | Col10 | Col11 | Col12 |
1 | 0056-200-ESC01 | 1 | AL ALABAMA | N(D) | N(D) | N(D) | N(D) | * | * | * | * | 07/26/2018 | 07/26/2018 |
1 | 0056-200-ESC01 | 2 | AK ALASKA | N(D) | N(D) | N(D) | N(D) | * | * | * | * | 07/26/2018 | 07/26/2018 |
1 | 0056-200-ESC01 | 3 | AZ ARIZONA | N(D) | N(D) | N(D) | N(D) | * | * | * | * | 07/26/2018 | 07/26/2018 |
1 | 0056-200-ESC01 | 5 | CA CALIFORNIA | N(D) | N(D) | N(D) | N(D) | * | * | * | * | 07/26/2018 | 07/26/2018 |
1 | 0056-200-ESC01 | 6 | CO COLORADO | N(D) | N(D) | N(D) | N(D) | * | * | * | * | 07/26/2018 | 07/26/2018 |
‎07-10-2023
11:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Very helpful, thank you!
