OCONV-MCP replacement for PX

[gsherry1]

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

[ArndW]

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

[ray.wurlod]

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

[mhester]

Greg,

Don't know if you found a decent solution to your issue, but you could use the following unix command -

Code: Select all

tr -cd '\11\12\40-\176' < $INPUT_FILE > $OUTPUT_FILE

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.

[ray.wurlod]

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

[mhester]

Ray,

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

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

[DSguru2B]

Yea, but isnt this dude sitting on windows?

[ray.wurlod]

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.