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
11857 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 dynamic cache?

997

Partition, what happens if the specified key range is shorter and longer

2467

What is dimensional table?

1027

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3836

what is the size of your data warehousing?

2066

How might one distinguish in the case of mapping is right or not without associating session?

1060

Explain sessions and how many types of sessions are there?

974

COM components can be used in Informatica

2342

What is Index Caches size?

1082

What is meant by lookup transformation? Explain the types of lookup transformation?

922

What is a standalone command task?

1165

can u any challenge your project?

1991

What is data movement mode in Informatica and difference between them?

1095

EXL informatica Questions

1340

generate date / time dimension in informatica

1091