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?
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 is enterprise data warehousing?
How to extract sap data using informatica?
How many ways a relational source definition can be updated and what are they?
Can you use flat files in Mapplets.
What is the difference between router and filter?
How can we update a record in the target table without using update strategy?
What is a pre-defined event and user-defined event?
how we can load rejected record's at run time?(not through bad files)
Please let me know how to make Data masking in informatica..
tell me 5 session failure in real time how can you solve that in your project?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is a standalone command task?
Explain informatica architecture - version 8 / 9
waht type of interface is used for testing the data in informatica
While migrating the data from one environment to another environment how would you manage the connections?