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

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  


can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,


in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,


How to convert multiple rows to single row (multiple columns) in informatica

0 Answers   Informatica,


What is an expression transformation?

0 Answers  


write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,


star and snowflake schema?

6 Answers  


if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,


i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,


How to delete duplicate record in Informatica?

7 Answers  


SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,


Is there any way to read the ms excel datas directly into informatica?

0 Answers  


Categories