DSXchange

Hi all
I am sure someone asked it before but i couldn't find it on this form.
my question is simple: how to print "" (two double quotations) into sequential file?

for example:
the current output like: "a","b",,,"e"
i want change the output to: "a","b","","","e"

thanks in advance

Well... it doesn't really seem to be something that's needed as those bare commas should process just fine. However, assuming the value is NULL in your source (from your subject) have you tried using the NullToEmpty() function?

Server job, Craig.

Well aware of that and know that's the name of a Parallel function... but I recalled using a function much like that back in my Server days (hence the advice) but perhaps it was one we built? Ah well, just a pretty brain dead if-then-else.

Bottom line, wondering if a simple test for NULL and replacing it with an empty string would get the desired end result...

thanks guys
I found the solution to work around in this job, I put the the server job to the end, so the out put file don't need to be read by any other job.
I will leave it like that for now until next time...

Cheers
Howard