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...
Answers were Sorted based on User's Feedback
Hi,
use this function for above question,
replacestr(0,col,'$','!','@','#','%','^','&','*', NULL)
or
replacechr(0,col,'$!@#%^&*', NULL)
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / ratalarayudu
hi,
By using replacechr function we can remove unwanted characters .
Regards,
Rayudu.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / rams
replacechr(0,reg_replace(input,'[^a-z A-Z]','/')'/',null)
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / manasa
please put down the replace command for the above question
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / hari
We can use reg_match function in informatica with required
regular expression to allow the charchters and number
format u need . In this way we can easily restrict any
special charchter.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anirban_ghosh
Since it's been said...we know nothing of the special characters present in between...therefore..the wise thing would be tp extract each character and compare it with the (int value) of the alphabets......if the (int) value of the extracted character is between....65-90 or 97-122......store it in a queue......at the end....flush out the queue....that's it!!!
Is This Answer Correct ? | 0 Yes | 1 No |
What is a passive transformation?
What is a snowflake schema?
How You Pull the records on daily basis into your ETL Server.
How are parameters defined in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Enterprise data warehouse your projects phase by phase explain?
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
what is the flat file partition and where have to specify it
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
What is the need of etl tools?
What is the use of code page?