Hi frnds, my scenario is like i'm having a record 1234"1323£343

Hi frnds, my scenario is like i'm having a record
1234"1323£3434%343434^23232!1212$23232
in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

Question Posted / praman_414@yahoo.co.in

2 Answers
15699 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$..

Answer / rajendhar reddy kuthuru

we can use convert function to remove special characters or replace a string

convert('$%^@"!',"",string)-stage var1

it will replace all special characters with a single space

compactwhitespace(stagevar1)

Is This Answer Correct ?

15 Yes

0 No

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$..

Answer / srinivas

Please use below function.
convert('!@#$%^&*','',string)

No need of the give space in between codes

Only one step to solve this.

Is This Answer Correct ?

11 Yes

0 No

Post New Answer