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...
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
What are the differences between a connected lookup and unconnected lookup?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the tuning techniques you applied during your last project
How do you promote a non-reusable transformation to reusable transformation?
What are the different components of powercenter?
What is pmcmd command?
What is informatica powercenter repository?
What is informatica worklet?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What are the new features of Power Center 5.0?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is data caches/ index caches?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
If informatica has its scheduler why using third party scheduler?