how to filter numbers from date

[rag329]

hi team, I have the data like this

7/02/2020656

12/1/1996567

My output would be like this

07/02/2020 656 (656 should be in new column)

12/01/1996 567 (567 should be in new column)

m/d/y

please help me

[Yoshiro_Fujimori]

Hi @rag329 ,

RegEx formula will be one way. I hope this helps.

Expressions

Date_mdy = REGEX_Replace([Data], "(\d+/\d+/\d{4})(\d+)", "$1")

Remaining = REGEX_Replace([Data], "(\d+/\d+/\d{4})(\d+)", "$2")

Output

[rag329]

@Yoshiro_Fujimori thank you so much

[flying008]

Hi, @rag329 

Another way full for you:

[binuacs]

@rag329 Another method using string formula 

[rag329]

thank you so much team for helping me.