Search Results

Hi Don,

I tried using :

sed -e 's/^"/^B/' -e 's/"$/^B/' -e 's/",/^B,/g' -e 's/,"/,^B/g' -e 's/"//g' -e 's/^B/"/g'
but i could see that all the double quotes are replaced by
^B
and also...

Hi RudiC,

It doesnt work for me as for the data should be some thing like below:

Input:

560003_07.28,292.47,"D","1073/1220","44536370","16520","16520/14103000","Vacuum - Upright (c) -...

Hi All,

I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes.

Sample Data :
...

Hi Scrutinizer,

The data which i have posted is actually a single row with 13 columns separated with pipe symbol(|)

I need the data with in double quotes to be considered as single column....

Hi All,

I have a problem loading the data from a csv file
As you see below in the Input ,For the Data starting with " there are 2 lines, which i want to make them into single without changing the...