JSON Generation using JSON Generator
Hi All,
I need the below structure for creating a Tree structure in Javascript, When i execute the below structure using JSON generator (Edit JSON) am not getting any output neither error
[{
“t...
Forum Discussion
Hi,
The best example is below, it have three names separated by comma, so I thought of using some logic as
“regexp_substr(dossier_lead, ‘[[:alnum:] .()-]+, [[:alnum:] .()-]+’,1, level,‘i’)” it is working in oracle but it is hanging, so i thought of trying same logic in snaplogic.
Example: john, maria,lisa, awari,Arun, john(TCS)
Thank you for the additional information. I believe there was a typo in the initial post indicating that you could not use commas. If your JSON was something like “names” : “john, maria,lisa, awari,Arun, john(TCS)” you could use the expression $names.split(‘,’) which will result in a “names” array. If you want to remove the white space you could use $names.replaceAll(’ ‘,’‘).split(’,').
Screenshot of split only:
Screenshot of expression with replaceAll and split:
There are 364,507 rows in the xml file.
I see you already set the Splitter property -- that's good. In the Pipeline Execution Statistics, do you see lots of output documents as the file is parsed? If you validate the pipeline, is the output what you expect?
You'll have to change Snap Execution to Validate & Execute to test validation.
