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
- 5103 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How you know when to use a static cache and dynamic cache in lookup transformation?
How can we store previous session logs?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How does a sorter cache works?
How to improve the performance of a session using sorter transformation?
In warehouses how many schemas are there?
What is sorter transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the differences between source qualifier and joiner transformation?
Explain pushdown optimization and types in informatica
What is the function of aggregator transformation?
Explain the mapping variable usage example in informatica
Enlist the various types of transformations.
What is the surrogate key?
