Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Is it possible to update the target table with PK?

1 Answers   TCS,


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  


Can we write to_date(three arguments) ? Will it work ? Advance thanks

1 Answers   Puma,


Why is sorter an active transformation?

0 Answers  


Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  


What is sequence generator transformation in informatica?

0 Answers  


in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify

3 Answers   Patni,


What are the types of data warehouses?

0 Answers   Informatica,


What is a configuration management?

1 Answers  


What is informatica?

0 Answers  


After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 Answers  


we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,


Categories