Non-Alpha numeric characters

[reachmexyz]

hello all

In my feed, i get Non-alpha Numeric characters like ?,<> and also Html encode characters like $#284, $#123, \x67 and so on. Now i need to replace some of the characters will null and some with hyphes. using PXReplace i can only replace one string But in this case i need to replace multiple strings. how can i do it. Please reply

[anbu]

If you want to do character by character replacement then use Convert()

[reachmexyz]

If you want to do character by character replacement then use Convert()

i want to do string by string. Cant i do this in Datastage.

[anbu]

You have to call PXReplace() multiple times

[arunkumarmm]

Yes, I was even searching for it and found that there is no equivalent function in PX for server 'ereplace'

But I believe ereplace will work in BASIC_Transformer.

[anbu]

Search the forum for C++ EReplace() function. This can be used in PX.

[ray.wurlod]

Adapt the parallel Ereplace() function to handle multiple strings. Or create a "wrapper" routine to feed one string at a time to that Ereplace() function.