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
- 5030 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
What is the sql query overwrite in source qualifier in informatica
Can anyone tell me the new features in Informatica 9 Version?
Implementation methodology
What are the new features of informatica 9.x in developer level?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Explain load alternative records / rows into multiple targets - informatica
What are the various types of transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How do you handle two sessions in Informatica
What is intricate mapping?
What is sq transformation?
what is size of u r database?
what is Active lock explain
Describe the impact of several join conditions and join order in a joiner transformation?
State the differences between sql override and lookup override?
