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
- 5001 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 Default Source Option For Update Strategy Transformation?
What is decode in static cache?
what is diff b/t sorter t/r and agg have the option sorter property...
How to differentiate between the active and passive transformations?
How we can create indexes after completing the load process?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
have u done any performance tuning? how u ll do?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How to join three sources using joiner? Explain though mapping flow.
How many input parameters can exist in an unconnected lookup?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are active and passive transformations?
How do you use reject loader.
What are the issues you have faced in your project? How did you overcome those issues?
Tell me about MD5 functions in informatica
