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
- 5113 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 many ways are there to do 'remove duplicate records in informatica'?
Repository user profiles
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is meant by LDAP users?
What is xml source qualifier transformation in informatica?
Differentiate between joiner and lookup transformation?
how we can load rejected record's at run time?(not through bad files)
Explain lookup transformation is active in informatica
r u done any partitions in ur project?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
While migrating the data from one environment to another environment how would you manage the connections?
Global and Local shortcuts. Advantages.
Explain joiner transformation in informatica
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
