I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
Answer Posted / vamshi
here is the solution for your question
tested
https://etltechsolutions.wordpress.com/2016/05/23/replace-comma-with-tab-everywhere-except-enclosed-in-a-pair-of-double-quotes/
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the sequence generator transformation in informatica?
Enlist the various types of transformations.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Differentiate between source qualifier and filter transformation?
can anyone explain me about retail domain project in informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How do you load only null records into target? Explain through mapping flow.
Write the unconnected lookup syntax and how to return more than one column.
How to Create a folder using pmrep command?
What is the function of aggregator transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What are the prerequisite tasks to achieve the session partition?
How many types of sessions are there in informatica.please explain them?
What is Index Caches size?
Which transformation should we use to normalise the COBOL and relational sources?