trying to do a simple parse

[matthew_swanson]

hello, i am trying to use the parse tool to get the number between '"date":' and ','

this is the string i'm working with: "....."date":1626275112,"open":2638.030029296875,...."

i dont see anything wrong with my regex expression.. but then again i'm not very good with regex

my output gets the starting position right, but it is grabbing everything after the term i'm looking for, it's not ending properly:

does anyone know what i'm doing wrong?

[atcodedog05]

Hi @matthew_swanson 

You can try something like this.

"date":(\d+),

only takes the numbers. This should work.

Hope this helps : ) 

[matthew_swanson]

yep that worked, but what about situations where there are decimals, (or sometimes) letters in that field?

[atcodedog05]

Hi @matthew_swanson 

Modify your expression like this.

"date":(.+),".*

Workflow:

Hope this helps : )

[matthew_swanson]

this is odd, i've opened your example and it works, but when i literally copy your parse tool into my workflow, it doesnt work..

[atcodedog05 · Accepted solution]

Hi @matthew_swanson 

Can you try this. Quotes doesn't appear in date value and appears only when next field starts based on that I am isolating the date value. 

"date":([^"]+),.*

[matthew_swanson]

that worked, that's exactly what i need, thank you!

that said, i dont really understand why this works

my regex cheat sheet says that ^ represents the start of the string... i dont understand how that applies here

[atcodedog05]

Hi @matthew_swanson 

^ is start of string.

[^] is should not be chars in bracket.

[matthew_swanson]

ah ok, that is good to know! thanks again!