Use RegEx to parse a field in quotes with white spaces

Question

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 Answer

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