Extract specific details within an excel cell

Sujit870

Hello,

I am trying to extract below details in a seperate columns which are within single cell in excel.

Please let me know if this can be done through regex or any other tool in Alteryx. Input attached

:20C::CORP//2561608020S2OWD
:20C::SEME//67910049-SWSDAA
:22F::CAEV//DVCA
:22F::CAMV//MAND
:97A::SAFE//XX11XX222

Thanks

Input.xlsx

Regex

Accepted answers

davidskaife

Hi @Sujit870

Solution that matches the output you have suggested.

Uses two Text to Column tools to first split into rows on newline, then splits into columns on : then removes the second / from the final output, and finally filters on the specific codes required

Screenshot 2025-06-26 130007.png

text-to-columns.yxmd

All comments

binu_acs

@Sujit870 one way of doing this

Regex_26022025.yxmd

alexnajm

removing response because I didn't notice the exception in the data - @binu_acs solution is better

davidskaife

Hi @Sujit870

Solution that matches the output you have suggested.

Uses two Text to Column tools to first split into rows on newline, then splits into columns on : then removes the second / from the final output, and finally filters on the specific codes required

Screenshot 2025-06-26 130007.png

text-to-columns.yxmd

Sujit870

Thank you all for replying

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703