Use RegEx to parse a field in quotes with white spaces

[tthomas]

HI, 

I am new to Alteryx. I am trying to parse fields in a column, but I am having trouble parsing it. Only one portion of the fields will parse. I am trying to parse fields with data in the following format; 

"NOV 08 2013"|1740354357 

I wrote the following expression but it only parses the numbers after the pipe. I'm trying to get it to parse the data before the pipe as well. Here is my expression;

(.\d{3}\s\w{2}\s\w{4}.)|(\w{10})

Please assist. 

[fmvizcaino · Accepted solution]

Hi @tthomas ,

Only a little change for your expression to work.

(.\w{3}\s\d{2}\s\d{4}.)\|(\d{10})

\d = digits, so I changed \d for \w and vice-versa.

| is a special character, so if you want the literal |, you need to insert a back slash first, \|

Best,

Fernando Vizcaino

[tthomas]

That worked perfectly! Thanks Fernando. I appreciate the help and quick response.