Parsing with RegEx

Hi,

I'm trying to use RegEx to separate the following B185661B Chips Ahoy Valley Tees. I would like it to be one column has the B185661B and the other column has the Chips Ahoy Valley Tees. Please let me know if this is possible. The excel file is attached.

Output

Parse

Preparation

Accepted answers

@dholder15 is there a reason this needs to be done with RegEx i.e. is there a certain pattern you're looking for? From your example it looks like you may just be splitting a product name from a code that's the first word? If so, you can just use a simple solution like so:

Splitting the field in 2 based on the first space (\s delimiter).

Here's another way for your use case - to expand your options beyond Regex😎

I hope you find it helpful - Cheers!

For_dholder15.yxzp

All comments

Please see below :

Attached the workflow, hope this helps!

Regards,

Reg_20230511.yxmd

@dholder15 is there a reason this needs to be done with RegEx i.e. is there a certain pattern you're looking for? From your example it looks like you may just be splitting a product name from a code that's the first word? If so, you can just use a simple solution like so:

Splitting the field in 2 based on the first space (\s delimiter).

Here's another way for your use case - to expand your options beyond Regex😎

I hope you find it helpful - Cheers!

For_dholder15.yxzp

Thank you so much! That helped out tremendously

You're most welcome @dholder15!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703