Regex Expression

[dillonrispoli]

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.

[geraldo]

@dillonrispoli 

An example de regex

[Yoshiro_Fujimori · Accepted solution]

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

[dillonrispoli]

Very helpful, thank you!