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

More Data Stage Interview Questions

what is a force compile

2 Answers Cap Gemini, IBM,

What is the importance of the exception activity in datastage?

0 Answers

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers ME,

Difference between in process and inter process?

0 Answers

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers Accenture,

Hi Vijay here For Four CPU's how many nodes will required?

4 Answers TCS,

How a server job can be converted to a parallel job?

0 Answers

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers Cognizant, IBM, TCS, Virtusa,

where we use column generator stage in real time scenario?

5 Answers TCS,

why do we need a datawarehouse when we have databases to store data?

1 Answers L&T,

how can we do null handling in sequential files

2 Answers Reliance,

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers

For more Data Stage Interview Questions Click Here