Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13386 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
Write the unconnected lookup syntax?
What is resilience time?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the performance considerations when working with aggregator transformation?
Is stop and abort are same in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is domain and gateway node?
what is the difference between informatica6.1 and infomatica7.1
Parameter and variable differences
What is a mapplet/worklet in informatica?
What is an aggregator transformation?
which one is better performance wise joiner or look up
can u give example for factless fact table
list out all the transformations which use cache?
explain one complex mapping with logic? sales project?
