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

[binu_acs]

@Sujit870 one way of doing this

[alexnajm]

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

[davidskaife · Accepted solution]

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

[Sujit870]

Thank you all for replying