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?
Solved! Go to Solution.
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?
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":([^"]+),.*
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
ah ok, that is good to know! thanks again!