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
- 12338 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 to generate sequence numbers using expression transformation?
what are the unix commands to start the wrk flow ?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
What are differences between Informatica 7.1 and 6.1
What are Dimensions and various types of Dimensions?
How to improve the performance of a session using sorter transformation?
How to delete duplicate row using informatica?
Teradata 
