DSXchange

Hello Forum,

Is there a general string cleansing function in parallel job like OCONV-MCP to remove all non-printable characters? The only way I can figure to do this is to explicitly list all the characters you wish to translate in a convert function call.

Any other suggestions?

Thanks,

Greg

No builtin PX equivalent to the "MCP" code of Iconv/Oconv.

BASIC Transformer stage? This will allow you to use Oconv() admittedly with a throughput penalty.

Greg,

Don't know if you found a decent solution to your issue, but you could use the following unix command -
This will strip all non-printable characters from a string and I would think it would be much more efficient than throttling down to a sequential flow using the BASIC transformer.

I created a wrapper which invoked this from a stream and it works as advertised.

Try not to develop in terms of mixing server and parallel processes (unless absolutely necessary), but to separate these processes.

That approach would probably also work in an External Filter stage.

Ray,

That approach would probably also work in an External Filter stage.

You are correct, but it's a bit tougher.

Yea, but isnt this dude sitting on windows?

Duzn't matta!

Parallel jobs on Windows actually run on MKS Toolkit (a UNIX emulator). So you have all the UNIX shell functionality you need. The tr command is definitely available.