DSXchange

It's not a bug. You've asked it to enclose a string in double-quotes and it found some double-quotes inside the string so they were escaped. It has no idea you intend to treat this as (in essence) two distinct comma separated fields.

How large is your team, Paul?

highpoint wrote:I have implemented earlier Ctrl-Y char(25) as delimiting characters in my transformer earlier. But sequential file does not allow this.

Pandeesh, we're responding to this statement.

They look like pairs of "input" and "output" files, perhaps leftover from a named pipe? I would imagine they can be removed, but let's wait and see if anyone knows for sure...

Here's the thing - all they have is a single character, hence Ray's advice to read the help and learn how to input them when they are "non-printing".

:!: Guys, please stop quoting everything you are replying to. If you need to do it to make your point, that's fine, but don't just click on Reply with quote out of habit or because you think it's the only option. Use the Reply to topic link instead and save me the work of constantly having to clean ...

OK, then perhaps something extra is coming along for the ride. How exactly are you extracting the XML from the CLOB in the job? Doing anything other than just selecting it?

What kind of files are these? It's not unusual to find strange things in your project since many things end up there (since it's the "current working directory" when jobs run) when they aren't pathed correctly. Flat files specified as a relative path start there, or ones where the path par...

It may be "well formed and valid" but it sounds like it doesn't match the metadata (XPath Expressions) you are using to parse it. Does all of the XML in the CLOB conform to a single xsd?

Have you looked up the syntax of the Trim() function in the documentation?

Nope!

Back in the PX forum you go.

Perhaps with no length equates to max size?

<redacted>

Never mind, bad advice.

Contact your official support provider.

No worries, if database = schema then never mind.