With complex XML schemas, it is at times necessary to use the XPath features in IMT to map attributes or elements to column definitions. The basic idea of how this works is pretty simple, but there are a few “gotchas”. Elements with namespace prefixes are one of those scenarios.
Continue reading “XPath and IMT: Namespace Prefixes”Parsing Labeled Data in IMT
This post is a follow-up to my previous post, Parsing Delimited Strings in IMT. That post went into detail on how to parse values from a delimited string based on the desired value’s position in the string. This post will explain how to parse values that are labeled using a real-world example brought to me earlier this week.
Continue reading “Parsing Labeled Data in IMT”Parsing Delimited Strings in IMT
Delimited text is very common in the enterprise space. In fact, EDI – the “lingua franca” at TrueCommerce – is just delimited text at its core. I get asked often how to parse values out of a delimited string using IMT. In this post, I’ll break down how to build these statements.
Continue reading “Parsing Delimited Strings in IMT”