1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

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

More Data Stage Interview Questions

What is ds designer?

0 Answers  

difference between server shared container and parallel shared container

6 Answers   CTS,

how can u handle null values in transformer stage.

7 Answers  

convert yyyy mm dd to dd mm yyyy?

4 Answers  

types of errors in datastage?

2 Answers   Reliance,




Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

What is the difference between Link collector and Funnel Stages?

1 Answers  

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

How do you find the number of rows in a sequential file?

1 Answers  

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

What are transforms and what is the differenece between routines and transforms?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories