Parsing data in a variable with javascript and storeEval?


#1

Hey!

I am stumped trying to think of a way to do this.
I have a variable “topReport” which will be filled with a 24hour time slash date like this:
“1400/15”
“1805/13”
“0920/07”
I’m trying to extract just the date ex. “15”
I’ve come up with a RegEx pattern \D+.+ to filter down to “15” or to try and use str.split.
I’m not sure how to stick all of this into Kantu though.
Any help would be much appreciated!

Update! This was really not as hard as I made it out to be in my mind! lol
I used StoreEval | var array=storedVars[‘topReport’].split(’/’); array[1]; | date
Worked like a charm.


#2

I used StoreEval | var array=storedVars[‘topReport’].split(’/’); array[1]; | date

Thanks for updating the post with a solution. I just reply so that I can mark your post as solved :slight_smile: