Split column from number in a text string using Regex

[EJ_Alt]

Hi Alteryx family,

I need some help with a simple regex (or any) solution that splits a column in two based on the first occurence of a number in string.

Thanks, EJ

[Qiu · Accepted solution]

@EJ_Alt 
Something like this?

[AkimasaKajitani · Accepted solution]

Hi @EJ_Alt 

Please use this syntax.

(.*)\s(\d+\s[A-Za-z]{3}\s\d{4})

If the date is single digit, it will be work.

[atcodedog05 · Accepted solution]

Hi @EJ_Alt 

Here is my take on it.

Regex

(.*)\s(\d.{9,10})

Output:

Hope this helps 🙂 Feel to ask if you have any questions

[EJ_Alt]

Thanks @Qiu . This works well

[EJ_Alt]

Thanks @AkimasaKajitani . Perfect, my workflow sometimes has single digits.

[EJ_Alt]

Thanks @atcodedog05 . Also like your solution. Proves Regex is highly flexible.

[atcodedog05 · Accepted solution]

Hi @EJ_Alt 

You are allowed to mark multiple solution. So feel free to mark all the posts which is helpful as solution.

Happy to help🙂

[atcodedog05]

Happy to help 🙂 @EJ_Alt 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂