How do you extract data from a text field? Regular expressions appear to be a mess in Ninox...
How do you extract data from a text field? Regular expressions appear to be a mess in Ninox... Specifically, I need to extract the text contained in the red box in the image below:
Thanks, Marvin
4 replies
-
I would use the
item()
function to get the value. You can either assign the information in the screenshot above to a variable first or use it directly in theitem()
function.let myArray := [{
timestamp: "2021-07-29T17:28:00.000Z",
datetime: "2021-07-29T17:28:00",
location: "Ellenwood, GA 30294",
details: "Arrived at FedEx location"
}];
item(myArray, 0).details
or
item([{
timestamp: "2021-07-29T17:28:00.000Z",
datetime: "2021-07-29T17:28:00",
location: "Ellenwood, GA 30294",
details: "Arrived at FedEx location"
}], 0).details
-
Sorry, I should have answered the question as asked. This is the code I would use...
item(parseJSON(YourTexFieldName), 0).details
-
Thanks for your help Sean! BTW, can we chat privately? Regards Marvin
-
Marvin, you're welcome. I can be reached at studiouschimp, it's a gmail account. Regards Sean
Content aside
- 3 yrs agoLast active
- 4Replies
- 397Views