DSXchange

Dear Experts

The source data that I have contains the special character (symbol) ' CLOUD (U+2601) ☁ ' which needs to be replaced with ' xyz' .

How should I achieve this ? I am aware of convert function but not sure how to handle this.

FYI this cloud is shown as question mark if I view the data .

Any help will be much appreciated.

Thanks

Search for the parallel Ereplace() function on DSXchange. You will be replacing one character with three, so Convert() is inappropriate.

Hi Ray , Thanks for your time and reply.

My problem is not with either Convert or Ereplace functions, but copying the cloud symbol in to datastage transformer stage.

I want to write some thing like this.....

Convert('☁','xyz',ColName) but I was unable to copy this cloud symbol for conversion......please help me.

Thanks

ray.wurlod wrote:Search for the parallel Ereplace() function on DSXchange. You will be replacing one character with three, so Convert() is inappropriate. ...

Hi Ray

Thanks for the reply ,The UniChar function is not available in PX, how to handle this with out using Basic Transformer ?

ray.wurlod wrote:

Code: Select all

UniChar(2601)