Shell Programming and Scripting

Hi,

I want to merge the lines starting with a comma symbol with the previous line of the file.

Input :

cat file.txt

name1,name2
,name3,name4
emp1,emp2,emp3
,emp4
,emp5
user1,user2
,user3

Output

name1,name2,name3,name4
emp1,emp2,emp3,emp4,emp5
user1,user2,user3

IS there any command in unix to do this conversion for the entire file?

Mohan

Code:

awk 'END { print r }
r && !/^,/ { print r; r = "" }
{ r = r ? r $0 : $0 }
' file

Use nawk or /usr/xpg4/bin/awk on Solaris.

Thanks for the reply. This script works fine.

Is there any way to merge two lines based on specific occurance of a character

I am having a flat file which contains multiple records.
Each row in the file should contain specified number of delimiter.
For a particular row , if the delimiter count is not matched with the specified count, then then next row should be merged with the previous row. Again the same check has to be done.

The script should accept number of occurances of a particular delimiter as the parameter.

For Example if the number of occurances of comma in every line is 5 in a flat file

Sample Input

1,2,3,
4,5,6
a,b,c,d,e,f
10,20,30
,40,50,60
11,22
,33
,44,
55,
66

Output (Each row should contain 5 commas)

1,2,3,4,5,6
a,b,c,d,e,f
10,20,30,40,50,60
11,22,33,44,55,66

Mohan

Set the desired number of columns on the command line (cols= ...),
use nawk or /usr/xpg4/bin/awk on Solaris:
(I feel I'm reinventing the wheel ...)

Code:

awk -F, '{ 
  for (i=1; i<=NF; i++)
    if ($i) 
      printf $i (++c % cols ? FS : RS)
    }
END { 
  if (c % cols) 
    print 
	}' cols=5 input

Hi,

Try this for the above scenario

Code:

paste -sd# inp.txt | sed 's/#,/,/g' | tr '#' '\n'

Regards,
Chella

Hi,

Try this for the above scenario,

Code:

paste -sd# inp.txt | sed 's/#,/,/g;s/,#/,/g' | tr '#' '\n'

Regards,
Chella

Thanks for the reply.

This works fine if the word is not splitted in two lines.

But it a word is splitted in two lines it is not working.

Sample input

one,two,three,
four,five
six,se
ven,eight,nine,ten
eleven,twelve,thirteen,fourteen,fif
teen
1,2,3,4,5

output (Contains 4 commas in each line)

one,two,three,four,five
six,seven,eight,nine,ten
eleven,twelve,thirteen,fourteen,fifteen
1,2,3,4,5