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 .
- 2 Answers
- 5201 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 |
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
What is expression transformation?
What happens if the info. Server doesn't find the session parameter in the parameter file?
What is meant by incremental aggregation?
How we can create indexes after completing the load process?
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
Why we use stored procedure transformation?
what is flat file override?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
What is parameter file?
what is the purpose of surrogate key and diff between primary key&surrogate key
Teradata 
