DSXchange

You need to look at the description of the function again. It takes all characters in the "from" list and replaces each with the corresponding (positional) character in the "to" list. In other words, to replace them all with a "1" you would need the same number of &quo...

We don't know in which position we have which special characters.so multiple nested Trim() function also we can't use.

Thanks Srini...

yeah i did also the same thing and my output is also coming like the above output. i am wondering why it is not replacing the alphabet with 1.

Thanks Srini for ur reply... No srini this is not delimeter &^.We don't have any delimeter in the input source. As i mentioned in the example that we will have input data like and we don't know the input data.we need to remove the special characters from leading and trailing.we are not removing ...

Thanks qt_ky for replying the post .

can we have other method to do the above scenario. Instead of multiple nested Trim() function.

Thanks craig for replying the post... can you elaborate more how to find the first and last "non-special" character in the string using the Index function. Any example will be helpful for this. i tried to use the index function. i am mentioning the below code. Index(Trim(columnname),'ABCDE...

Remove multiple special characters from leading and trailing of a string in datastage.

e.g.: Input Data like: !@##$$Rami^&Reddy*&^%$
Output Data Should: Rami^&Reddy

could you please suggest how to do of the above scenario.