How to Identify and replace CLOUD (U+2601)

pklcnu · Post by **pklcnu** » Sun Feb 28, 2010 2:27 am

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

ray.wurlod · Post by **ray.wurlod** » Sun Feb 28, 2010 4:20 am

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

pklcnu · Post by **pklcnu** » Mon Mar 01, 2010 3:49 am

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. ...

ray.wurlod · Post by **ray.wurlod** » Mon Mar 01, 2010 4:13 am

Code: Select all

UniChar(2601)

shyam_etl · Post by **shyam_etl** » Mon Mar 01, 2010 10:52 am

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)