trying to do a simple parse

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?

Regex

Accepted answers

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":([^"]+),.*

You can try something like this.

"date":(\d+),

only takes the numbers. This should work.

Hope this helps : )

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

Modify your expression like this.

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

Workflow:

Hope this helps : )

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..

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":([^"]+),.*