hi, By using replacechr function we can remove unwanted characters .

i have a flat file and the file s are like below
****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$
IN THIS FORMATE
Means un limited special charecter between and sides of the
string data..output should be(GANESH)
HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE
AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

Question Posted / ratalarayudu

6 Answers
11782 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / ratalarayudu

hi,

By using replacechr function we can remove unwanted characters .

Regards,
Rayudu.

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the etl program with few examples.

970

Why union transformation is an active transformation?

997

How do you load only null records into target?

1148

What is a shortcut and copy in Informatica and how two are different with each other?

1134

Explain load alternative records / rows into multiple targets - informatica

1104

What is the use of code page?

1014

Informatica settings are available in which file?

941

What is the sequence generator transformation in informatica?

1099

What is update strategy transform?

1025

What is the function of look up transformation?

1058

How to elaborate tracing level?

1121

hi real timers . iam waiting for ur reply regarding ETL TESTING

2211

Enlist the advantages of informatica.

1009

Define mapping and session?

973

tell me the rules and responsblites in our project(my project is development)

1878