Convert Function - Mulitple Characters as a set for replace

[snt_ds]

Hi,

I am trying to replace all the characters 'XX,' to '' (Empty) using the Convert function..As I underatand it replaces each character seperately and hence my output is not as expected.

I want to change "XX,XX,XX,6,XX,7" to "6,7"

Any other way to replace this entire set in one go?

Thanks,
NV

[kandyshandy]

Are you using a server job or PX job? If server job, there are functions like EReplace.. If you are using a PX job, use BASIC transformer.

[snt_ds]

Yes I know..
But this is a PX job as reflected in the Job Type in the Post header

[kandyshandy]

Then use the BASIC transformer in your PX job and use EReplace function.

[snt_ds]

Thanks for your Great Advice but not an Efficient one!

We figured out a solution in PX..
using Trim(Convert('XX','',ARG),',','R')

Thanks,
NV

[chulett]

I believe you'll find that DSGuru2B posted a PX version of EReplace here some time back. If memory serves.

[ray.wurlod]

Convert works one character at a time.

That it worked for you was pure luck - all you got was each "X" converted to "A". Therefore "XX" would have been converted to "AA".

[kandyshandy]

As Ray told, convert works on one character at a time. If you are fine with using convert, then just to let you know... you can replace that convert with another trim too !!

one trimA to remove all X and another trimR to remove unwanted commas.

Or you could correct your statement to Trim(Convert('X','',ARG),',','R')