I have a source as flat file and having data like
""TCS"MUMBAI" and i want output like TCS MUMBAI,the length
of the data in the rows is variable.how can you fix it?
- 5 Answers
- 11990 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ramesh
replacechar(columnname,instr(columnname,'"',1,2),' ')
the instr function finds the position of the char i.e. " in the second occurence and 'replacechar' replaces it with null.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain joiner transformation in informatica
Differences between connected and unconnected lookup?
What is the use of code page?
how many types of dimensions are available in informatica?
Enlist few areas or real-time situations where informatica is required.
How we can create indexes after completing the load process?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is complex mapping?
What are the differences between a connected lookup and unconnected lookup?
What is rank transformation in informatica
What is the meaning of decode in informatica?
What are the types of caches in lookup?
How do you load unique records into one target table and duplicate records into a different target table?
What is the need of an ETL tool?
