Shell Programming and Scripting

HI ,

I have a comma delimiter file, in which I want to remove 8th and 9th column.

I tried removing those columns using the below code

Code:

awk 'BEGIN { FS=","; OFS="," } {$8=$9="";gsub(",+",",",$0)}1' infile

But the problem is 8th and 9th columns are user entered fields, theyvhave carriage returns and multiple "," between the data, so my above code is not removing the whole columns it's removing the data from the first comma it encountered.


Below is the sample data from these columns.

Code:

8th and 9th column  -- I issue was related to ,table load.when uat was going on ,march mentioned the below,
1.abdc,
2.fdfdf, and done

As I said because of multiple comma I am not able to remove the columns properly,please suggest how can I remove these columns.

--Mora

Separators are used to separate columns.
If you have separator as the actual column content (8 and 9), then it's use is invalid.

Check out if you can find separator which is not in the column, something like pipe, then use it during initial retrival of data from source.

Otherwise, post a bigger expected input / output example so folks here can suggest.