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
- 13567 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
What are the databases that informatica can connect to windows?
What is the way to execute pl/sql script using informatica mapping?
What is a code page?
wf dont have integration severances how you can run?
While migrating the data from one environment to another environment how would you manage the connections?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Reusable transformation and shortcut differences
What is data transformation manager process?
Explain the features of connected and unconnected lookup.
What do you mean by filter transformation?
How do you migrate data from one environment to another?
How to extract sap data using informatica?
How do you update the records with or without using update strategy?
What is domain in terms of informatica?
what is SDLC way of code development?
