Excel document cleaning through Alteryx

NA

Transforming

Accepted answers

This RegEx string worked for me! Use the RegEx tool with the Parse functionality. This is a great example of something to put into an LLM like ChatGPT for future reference - it does very well with RegEx statements.

^(\d+)([A-Z]{2})(MR[A-Z]+[A-Z]+[A-Z]+\+)(\d{2}[A-Z]{3}\d{2})([A-Z])(\d+)(.*?\d{2}\/\d{2}\/\d{4})(\d{2}[A-Z]{3}\d{2})(\d{4})(\d+\.\d{2})$

All comments

This RegEx string worked for me! Use the RegEx tool with the Parse functionality. This is a great example of something to put into an LLM like ChatGPT for future reference - it does very well with RegEx statements.

^(\d+)([A-Z]{2})(MR[A-Z]+[A-Z]+[A-Z]+\+)(\d{2}[A-Z]{3}\d{2})([A-Z])(\d+)(.*?\d{2}\/\d{2}\/\d{4})(\d{2}[A-Z]{3}\d{2})(\d{4})(\d+\.\d{2})$

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703