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 .
- 2 Answers
- 4114 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / sagar patil
We can gone through with the unix.
Command ..sed 's/','/'-'/g' filename
| Is This Answer Correct ? | 0 Yes | 4 No |
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is an aggregator transformation?
Plz..let me know differences between Informatica 7.1 and 8.1?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
What is CHECK-IN CHECK-OUT. Please explane me?
How to start a workflow using pmcmd command?
What if the source is a flat-file?
What is the term PIPELINE in informatica ?
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
What is the format of informatica objects in a repository?
Can you generate sequence numbers without using the sequence generator transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Teradata 
