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
- 5104 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 |
how DTM buffer size and buffer block size are related
major difference between normal loading and bulk loading?
Define joiner transformation?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
Can informatica load heterogeneous targets from heterogeneous sources?
what is mean by complex business rule ?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
When will you use SQL override in a lookup transformation?
what are the limitations of pushdown optimization technique ? Advance thanks
Can I create one wrkflw which will run different wrkflws on schedule time?
Teradata 
