replacechr(0,reg_replace(input,'[^a-z A-Z]','/')'/

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 / rams

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

Answer Posted / rams

replacechr(0,reg_replace(input,'[^a-z A-Z]','/')'/',null)

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is InformaticaPowerCenter?

1136

How can you differentiate between powercenter and power map?

1088

Can we override a native sql query within informatica?

1034

What is aggregator transformation in informatica?

949

How to create Target definition for flat files?

1221

Informatica settings are available in which file?

990

How many transformations can be used in mapplets.

1935

Describe an informatica powercenter?

1127

How to load a Dimension ? and how to load a fact table?

1416

Briefly describe lookup transformation?

1046

What are the types of schemas we have in data warehouse.

961

Explain lookup transformation is active in informatica

1104

Slowly changing dimensions, types and where will you use them

1713

wf dont have integration severances how you can run?

1938

How to extract sap data using informatica?

1042