Hi,
Is there a way to use the parse XML Tool in-DB? I need to parse a large dataset and bringing it in memory is not an option.
Thanks,
Divya
Solved! Go to Solution.
Most modern databases support the use of REGEX, so you cold use that as part of your SQL statement to ensure the parsing happens in-database, as opposed to on your local machine after pulling the data across the network as would be the case with the XML Parse, JSON Parse and RegEx tools themselves.
Every databases implementation of RegEx might vary slightly, so be sure to find the relevant documentation for your specific source. As an example here's what you'd use if you were using PostgreSQL which is used in several databases including Greenplum.
https://www.postgresql.org/docs/9.3/static/functions-matching.html