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
- 5208 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 |
Different types of Power center errors?
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?
Explain reference cursor?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is meant by LDAP users?
need for registering a repository server
How many dimensions are there in informatica?
why we use source qualifier transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
How to use procedural logic inside infromatica?
Teradata 
