Need help with awk statement to break nth column in csv file into 3 separate columns


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help with awk statement to break nth column in csv file into 3 separate columns
# 1  
Old 07-19-2013
Linux Need help with awk statement to break nth column in csv file into 3 separate columns

Hello Members,

I have a csv file in the format below. Need help with awk statement to break nth column into 3 separate columns and export the changes to new file.

input file --> file.csv
cat file.csv|less

Code:
"product/fruit/mango","location/asia/india","type/alphonso"

need output in following format ,the nth column to modify here is 2nd column
cat file.csv|less
Code:
"product/fruit/mango","location","asia","india","type/alphonso"

Smilie
any help is greatly appreciated.
thanks in advance

awk-novice
Moderator's Comments:
Mod Comment Please use CODE tags.

Last edited by Don Cragun; 07-19-2013 at 05:25 AM.. Reason: CODE tags
# 2  
Old 07-19-2013
how about below..

Code:
 
awk -F"," '{gsub("/","\",\"",$2);OFS=","}1' filename

This User Gave Thanks to vidyadhar85 For This Post:
# 3  
Old 07-19-2013
Quote:
Originally Posted by awk-admirer
Hello Members,

I have a csv file in the format below. Need help with awk statement to break nth column into 3 separate columns and export the changes to new file.

input file --> file.csv
cat file.csv|less

Code:
"product/fruit/mango","location/asia/india","type/alphonso"

need output in following format ,the nth column to modify here is 2nd column
cat file.csv|less
Code:
"product/fruit/mango","location","asia","india","type/alphonso"

Smilie
any help is greatly appreciated.
thanks in advance

awk-novice
Moderator's Comments:
Mod Comment Please use CODE tags.
will keep in mind about code tags..

thanks

---------- Post updated at 02:33 PM ---------- Previous update was at 02:28 PM ----------

Quote:
Originally Posted by vidyadhar85
how about below..

Code:
 
awk -F"," '{gsub("/","\",\"",$2);OFS=","}1' filename

this thing is working...

thanks a ton....
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to separate data coming in one column of CSV file?

I am running an ISQL command on Sybase DB and getting output of a query in an CSV file. The issue is that all the data comes in to the same column, i want them to be separated in different columns. SQL_COMMAND=command.sql file=file.txt formatFile=formatFile.txt report=report.csv echo... (1 Reply)
Discussion started by: Sharma331
1 Replies

2. Shell Programming and Scripting

Convert row to columns start from nth column

Dear All, We have input like this: 161 57 1378 176 1392 262 1444 441 1548 538 1611 670 1684 241 57 1378 208 1393 269 1447 444 1549 538 1610 677 1700 321 ... (4 Replies)
Discussion started by: attila
4 Replies

3. Shell Programming and Scripting

Csv file separate using awk

Hi, I have file like below apple,orange,pineapple,pappya,guva,avocado want to store as apple orange pineapple pappya I tried below command to seprate first field command1: (3 Replies)
Discussion started by: stew
3 Replies

4. Linux

To get all the columns in a CSV file based on unique values of particular column

cat sample.csv ID,Name,no 1,AAA,1 2,BBB,1 3,AAA,1 4,BBB,1 cut -d',' -f2 sample.csv | sort | uniq this gives only the 2nd column values Name AAA BBB How to I get all the columns of CSV along with this? (1 Reply)
Discussion started by: sanvel
1 Replies

5. UNIX for Dummies Questions & Answers

How to generate one long column by merging two separate two columns in a single file?

Dear all, I have a simple question. I have a file like below (separated by tab): col1 col2 col3 col4 col5 col6 col7 21 66745 rs1234 21 rs5678 23334 0.89 21 66745 rs2334 21 rs9978 23334 0.89 21 66745 ... (4 Replies)
Discussion started by: forevertl
4 Replies

6. Shell Programming and Scripting

Fetching columns from .csv file except last column

Hi, i have below list of files so i just want the name of the files in one parameter and not the timestamp. i want only GIDW_Dy_Tm_Seg_Sls_legacy_PL_0_0_ in variable of all files. GIDW_Dy_Tm_Seg_Sls_legacy_PL_0_0_20131001101800.csv GIDW_Dly_Sls_legacy_RO_0_0_20131001172001.csv ... (9 Replies)
Discussion started by: renuk
9 Replies

7. Shell Programming and Scripting

Break Column nth in a CSV file into two

Hi Guys, Need help with logic to break Column nth in a CSV file into two for e.g Refer below the second column as the nth column "abcd","","type/beta-version" need output in a following format "abcd","/place/asia/india/mumbai","/product/sw/tomcat","type/beta-version" ... (5 Replies)
Discussion started by: awk-admirer
5 Replies

8. Shell Programming and Scripting

Using AWK to find top Nth values in Nth column

I have an awk script to find the maximum value of the 2nd column of a 2 column datafile, but I need to find the top 5 maximum values of the 2nd column. Here is the script that works for the maximum value. awk 'BEGIN { subjectmax=$1 ; max=0} $2 >= max {subjectmax=$1 ; max=$2} END {print... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

9. Shell Programming and Scripting

Extracting columns from a matrix and storing each column in a separate file

Hi All, I have a huge matrix file consisting some some millions rows and 6000 columns. The contents are just floating point numbers in the matrix. I want to extract each column (i.e. 6000 of them) and store each column in a separate file. For example, 1.dat will consist of elements from column... (4 Replies)
Discussion started by: shoaibjameel123
4 Replies

10. Shell Programming and Scripting

help sum columns by break in first column with awk or sed or something.

I have some data that is something like this? item: onhand counted location ITEM0001 1 0 a1 ITEM0001 0 1 a2 ITEM0002 5 0 b5 ITEM0002 0 6 c1 I want to sum up... (6 Replies)
Discussion started by: syadnom
6 Replies
Login or Register to Ask a Question