Extracting XML string with separator embedded in text
Trying to extract "x, y", and only the "x" is being extracted because the "," is the separator
The ":" is set to extract everything after this
"Working Example": xyz,
"Not Working Example": "x, y",
Any ideas on how to extract the whole field on the example with the "," in the field
using
should do it
This worked, thank you!
I don't see XML here, but for your examples, I would use Regex
And the output will be
looks more like JSON than XML
Thanks for the suggestions, I wanted to also ask if anyone knows if I could use a line separator (Or a better suggestion) instead of the ","
I am extracting data from a JSON message into a HL7 and I am trying to identify a unique character I can use as a separator
For example I could use the "," as the separator but it might be used as free text within the line
e.g.
"Not Working Example": "x, y, z, a, b, c",
essentially it could be an infinite amount of characters separated with "," within the message
pure COS solution, split into steps to allow comments (you may condense it of course)
While you are working with JSON, I would recommend to not do it manually and use native JSON support, available since 2016.2 (2016.1 with notes).
So, you can do it just
or
and value will be available by
If you have a version with no native JSON support, look at this project
Social networks
InterSystems resources
Log in or sign up
Log in or create a new account to continue
Log in or sign up
Log in or create a new account to continue
Log in or sign up
Log in or create a new account to continue