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 .

Answers were Sorted based on User's Feedback



I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure t..

Answer / 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

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure t..

Answer / sagar patil

We can gone through with the unix.
Command ..sed 's/','/'-'/g' filename

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,


What is dimensional table? Explain the different dimensions.

0 Answers  


Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,


what r the transformations that r not involved in mapplet?

8 Answers   Wipro,


How to load duplicate records in to a target table which has a primary key?

2 Answers  


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,


differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 Answers   IBM,


How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,


can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,


What is a code page?

0 Answers  


what we require for D.modelling?

1 Answers  


Categories