How to split the comma separated file?

Login or Register to Ask a Question and Join Our Community

How to split the comma separated file?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to split the comma separated file?

02-11-2013

Registered User

8, 0

Join Date: Jun 2012

Last Activity: 5 March 2013, 6:06 AM EST

Location: bangalore

Posts: 8

Thanks Given: 5

Thanked 0 Times in 0 Posts

How to split the comma separated file?

Hi,
I have a filein unix like

ABC,CDE
BCD,KHL

and the output i need is like
column1 column2
ABC,CDE ABC
ABC,CDE CDE
BCD,KHL BCD
BCD,KHL KHL. Can some body help me out?

Hi,
The code is working fine. But in my file each row does not have always 1 comma. It may vary from 1 to many.

its like

BUD,BDL
ABC,XYZ
MNB,JHG,KTR
JKL,KYH,TYP,GHY[/CODE]

the o/p should like

ABC,XYZ ABC
ABC,XYZ XYZ
MNB,JHG,KTR MNB
MNB,JHG,KTR JHG
MNB,JHG,KTR KTR
JKL,KYH,TYP,GHY JKL
JKL,KYH,TYP,GHY KYH
JKL,KYH,TYP,GHY TYP
JKL,KYH,TYP,GHY GHY

Last edited by jagdishrout; 02-12-2013 at 04:20 AM..

jagdishrout

View Public Profile for jagdishrout

Find all posts by jagdishrout

02-11-2013

Registered User

446, 96

Join Date: Oct 2010

Last Activity: 7 June 2018, 4:01 PM EDT

Posts: 446

Thanks Given: 32

Thanked 96 Times in 88 Posts

Code:

#!/bin/ksh

while IFS=',' read part1 part2; do
  printf "%s,%s %s\n" $part1 $part2 $part1
  printf "%s,%s %s\n" $part1 $part2 $part2
done < filename

exit 0

gary_w

View Public Profile for gary_w

Find all posts by gary_w

02-11-2013

Moderator

3,689, 1,352

Join Date: Jan 2012

Last Activity: 22 August 2020, 11:29 PM EDT

Location: Galactic Empire

Posts: 3,689

Thanks Given: 268

Thanked 1,352 Times in 1,258 Posts

Code:

awk -F, 'BEGIN{ print "column1 column2" } {v=$2; $2=v" "$1; print; $2=v" "v; print}' OFS=, filename

Yoda

View Public Profile for Yoda

Visit Yoda's homepage!

Find all posts by Yoda

02-11-2013

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

Code:

awk -F, '{print $0,$1 RS $0,$2}' file

This User Gave Thanks to Scrutinizer For This Post:

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

02-12-2013

Registered User

8, 0

Join Date: Jun 2012

Last Activity: 5 March 2013, 6:06 AM EST

Location: bangalore

Posts: 8

Thanks Given: 5

Thanked 0 Times in 0 Posts

Hi,
The code is working fine. But in my file each row does not have always 1 comma. It may vary from 1 to many.

its like

Code:

BUD,BDL
ABC,XYZ
MNB,JHG,KTR
JKL,KYH,TYP,GHY

the o/p should like

Code:

ABC,XYZ ABC
ABC,XYZ XYZ
MNB,JHG,KTR MNB
MNB,JHG,KTR JHG
MNB,JHG,KTR KTR
JKL,KYH,TYP,GHY JKL
JKL,KYH,TYP,GHY KYH
JKL,KYH,TYP,GHY TYP
JKL,KYH,TYP,GHY GHY

jagdishrout

View Public Profile for jagdishrout

Find all posts by jagdishrout

02-12-2013

Moderator

12,296, 3,792

Join Date: Nov 2008

Last Activity: 1 January 2021, 1:47 AM EST

Location: Amsterdam

Posts: 12,296

Thanks Given: 679

Thanked 3,792 Times in 3,282 Posts

Try:

Code:

awk -F, '{for(i=1; i<=NF; i++) print $0,$i}' file

--
@jagdishrout: please do not make after-the-fact changes in the requirements in your original post, that makes the other reactions look silly.

Last edited by Scrutinizer; 02-12-2013 at 10:37 AM..

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

02-12-2013

Registered User

226, 10

Join Date: Jan 2010

Last Activity: 5 May 2020, 1:12 PM EDT

Posts: 226

Thanks Given: 5

Thanked 10 Times in 10 Posts

awk -F, '{ v=$1; print $0" "v}' filename

sample with

Code:

#cat filenames
ABC,XYZ
ABC,XYZ
MNB,JHG,KTR
MNB,JHG,KTR
MNB,JHG,KTR
JKL,KYH,TYP,GHY
JKL,KYH,TYP,GHY
JKL,KYH,TYP,GHY
JKL,KYH,TYP,GHY

Code:

#awk -F, '{ v=$1; print $0" "v}' filenames
ABC,XYZ ABC
ABC,XYZ ABC
MNB,JHG,KTR MNB
MNB,JHG,KTR MNB
MNB,JHG,KTR MNB
JKL,KYH,TYP,GHY JKL
JKL,KYH,TYP,GHY JKL
JKL,KYH,TYP,GHY JKL
JKL,KYH,TYP,GHY JKL

busyboy

View Public Profile for busyboy

Find all posts by busyboy

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

Hi Experts, Please support I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6. ...

2. Shell Programming and Scripting

Convert comma separated file to fix length

Hi, I am converting a comma separated file to fixed field lenght and I am using that: COLUMNS="25 24 67 26 39 63 20 34 35 14 397" ( cat $indir/input_file.dat | \ $AWK -v columns="$COLUMNS" ' BEGIN { FS=","; OFS=""; split(columns, arr, " "); } { for(i=1; i<=NF;...

3. UNIX for Dummies Questions & Answers

[solved] Comma separated values to space separated

Hi, I have a large number of files which are written as csv (comma-separated values). Does anyone know of simple sed/awk command do achieve this? Thanks! ---------- Post updated at 10:59 AM ---------- Previous update was at 10:54 AM ---------- Guess I asked this too soon. Found the...

4. Shell Programming and Scripting

Need Help - comma inside double quote in comma separated csv,

Hello there, I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process. Input in the csv file is , 1,234,"abc,12,gh","GH234TY",34 I need output like below,...

5. Shell Programming and Scripting

Comma separated file

Hi all, I have the following files types: FileA: 100, 23, 33, FileB: 22, 45, 78, and i want to make File C: 100,22 23,45 33,78 any nice suggestions for making it easy.

6. Shell Programming and Scripting

Inserting string in between field in comma separated file

Hello Mates, I have one txt file having commo seperated values. I have to insert string "FALSE" in 2nd field from the end. E.G SE18 6RN,,,,5439070,1786840,,1000002148671600,123434 Out put should be: SE18 6RN,,,,5439070,1786840,FALSE,1000002148671600,123434 Can some one help me to...

7. Shell Programming and Scripting

parsing comma separated file

Hi, I have a file with th elist of patches separated by comma, like below: patch1, patch 2, patch 3................ t\The number of patches is not known as it changes every time. I need assistance in writing a routine such as it will take patch1 as first variable and performs the...

8. Shell Programming and Scripting

How to format file into comma separated field

Guys, Need you help, i have a a file content that look like this. Nokia 3330 <spaces><spaces><more spaces>+76451883874 Nokia 3610 +87467361615 so on and so forth, - there are so many spaces in between. - e.g....

9. Shell Programming and Scripting

Converting comma separated to pipe delimited file

Hi, I came across a very good script to convert a comma seperated to pipe delimited file in this forum. the script serves most of the requirement but looks like it does not handle embedded double quotes and commas i.e if the input is like 1234, "value","first,second", "LDC5"monitor",...

10. UNIX for Dummies Questions & Answers

Remove whitespaces between comma separated fields from file

Hello all, I am a unix dummy. I am trying to remove spaces between fields. I have the file in the following format 12332432, 2345 , asdfsdf ,100216 , 9999999 12332431, 2341 , asdfsd2 ,100213 , 9999999 &...

Login or Register to Ask a Question