Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 6 Answers
- 11778 Views
- IBM, I also Faced
- E-Mail Answers
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 the difference is between a database, a data warehouse and a data mart?
Is it possible to revert a global repository to local one and why?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
Kimball and Inmon methodologies?
Plz..let me know differences between Informatica 7.1 and 8.1?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
How are the sources and targets definitions imported in informatica designer?
Describe the impact of several join conditions and join order in a joiner transformation?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
In which scenario did u used Mapping variable?
Teradata 
