I have a long text field on a saved search that ha...
# suitescriptn
Nicholas Williams
09/21/2021, 12:25 PMI have a long text field on a saved search that has JSON in it. How can I extract a specific keys value from that field on the search?
c
CD
09/21/2021, 12:31 PMI personally would alter whatever ingests it, and add that value as a new custom field. you're not going to have fun with saved searches. though you've posted in SuiteScript - are you processing a resultset in a script?
n
Nicholas Williams
09/21/2021, 12:32 PMbasically I am creating custom record entries that have one field that has JSON in it. Then on the saved search of these custom records, i want to pull out each value from JSON field. That way if a new key is added to the json, I don't have to create another field on the custom record @CD
c
CD
09/21/2021, 12:33 PMsounds like you're going to have fun with the
REGEXP_n
Nicholas Williams
09/21/2021, 12:34 PMYeah tried that but keep getting invalid expression error
Nicholas Williams
09/21/2021, 12:34 PMI tried this:
REGEXP_INSTR({custrecord_nco_fam_reporting_json}, 'test1 : '([^:]*)'')
Nicholas Williams
09/21/2021, 12:34 PMJSON field:
Nicholas Williams
09/21/2021, 12:34 PM{test1 : 'test one', test2 : 'test two'}
c
CD
09/21/2021, 12:35 PMYou need to escape the quotes
n
Nicholas Williams
09/21/2021, 12:36 PMhow
Nicholas Williams
09/21/2021, 12:36 PMnot awesome at regex haha
n
Nick
09/21/2021, 1:11 PM@CD just the expression or the part with the regex
e
ericbirdsall
09/21/2021, 4:04 PM@Nicholas Williams Check out regex101.com
I'm BADDDD at regex took, but that site makes it much easier to guess and check
t
Travis Zuri
09/21/2021, 5:58 PMWhat is your character length on the JSON? Saved searches only return the first so many characters so regexes can still fail to find everything.
n
Nicholas Williams
09/22/2021, 2:41 PMFigured it out @Travis Zuri and @ericbirdsall thanks for the resource
d
David B
09/24/2021, 2:59 AM@Travis Zuri I can confirm that fields in
Formula(text)