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 is the sequence generator transformation in informatica?
update strategy transformation in informatica
can anyone suggest best free Talend data integration training online
What is a sorter transformation?
COM components can be used in Informatica
Differentiate between sessions and batches?
Differentiate between source qualifier and filter transformation?
Differences between version 7.x and 8.x.
What is joiner transformation?
How an expression transformation differs from aggregator transformation?
What are the limitations of joiner transformation?
Explain lookup transformation is active in informatica
How to generate sequence numbers without using the sequence generator transformation?
What are data-driven sessions?
Explain scd type 3 through mapping.