0

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:

Screen Shot 2021-07-29 at 7.42.35 PM

Thanks, Marvin

4 replies

null
    • Sean
    • 2 yrs ago
    • Reported - view

    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 the item() 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

    • Sean
    • 2 yrs ago
    • Reported - view

    Sorry, I should have answered the question as asked. This is the code I would use...

     

    item(parseJSON(YourTexFieldName), 0).details

    • mpdickens
    • 2 yrs ago
    • Reported - view

    Thanks for your help Sean! BTW, can we chat privately? Regards Marvin

    • Sean
    • 2 yrs ago
    • Reported - view

    Marvin, you're welcome. I can be reached at studiouschimp, it's a gmail account. Regards Sean

Content aside

  • 2 yrs agoLast active
  • 4Replies
  • 378Views