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 .
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 |
Is it possible to update the target table with PK?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Can we write to_date(three arguments) ? Will it work ? Advance thanks
Why is sorter an active transformation?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
What is sequence generator transformation in informatica?
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
What are the types of data warehouses?
What is a configuration management?
What is informatica?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks