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
- 5202 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 domain and gateway node?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
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?
What are the designer tools for creating transformations?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is confirmed fact in dataware housing?
How do you migrate data from one environment to another?
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?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
have u done any performance tuning? how u ll do?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How do you use reject loader.
Difference between Target-based loading and constraint-based loading?
What are the measure objects?
