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
- 9981 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 |
how u know when to use a static cache and dynamic cache in lookup transformation.
in realtime which situations u can use unconnected lookup transformation
what are the perameter and variable?
What are the basic needs to join two sources in a source qualifier?
define galaxy repository in informatica
without dynamic lookup how to insert new rows and update existing rows?
What is a dimensional model?
Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.
Enlist some properties of sessions.
What is polling?
What are the types of caches in lookup?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Teradata 
