Group By in transform designer does not ignore leading/trailing spaces

Question

I am not sure if this is intentional or not, but noticed when doing a group by operation the following fields were grouped as different items:

<Genre>Action</Genre> - no spaces

<Genre> Action </Genre> - with leading/trailing space. CR/LF are also treated differently.

-Jonathan

Answer 1

Hi Jonathan,

This is intentional.

It is not always clear if surrounding whitespace should be removed, and if we make a choice to always remove this whitespace, we will be disabling scenarios where it's actually needed. CR/LF is also considered whitespace, so you'll see the same behavior for those characters as well.

If you need to ignore whitespace from an XML node, you can use the StringLeftTrim and StringRightTrim functoids before consuming it.

Thanks,

Kranthi.