Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Formatting lines in shell script

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Formatting lines in shell script
# 1  
Old 01-29-2007
CPU & Memory Formatting lines in shell script
I have a file with the below lines

1521
1522
1523
1524
1525
1526
...
174 lines all numbers like above. I want the above file to appear as below.

1521,1522,1523,1524.....
All the numbers should be separated by comma.

Pls tell me how to do this ....

Thanks in advance.
# 2  
Old 01-29-2007
Code:
{ OIFS="$IFS";IFS='
' set $(<file);IFS=",";echo "$*"; IFS="$OIFS";}


Example:

Code:
$ cat file
1521
1522
1523
1524
1525
1526

$ { OIFS="$IFS";IFS='
' set $(<file);IFS=",";echo "$*"; IFS="$OIFS";}
1521,1522,1523,1524,1525,1526

With bash:

Code:
$ v="$(<file)";echo "${v//
/,}"
1521,1522,1523,1524,1525,1526

Last edited by radoulov; 01-29-2007 at 05:02 PM..
# 3  
Old 01-29-2007
Smilie Woops, won't work for long lists; disregard.
Last edited by Glenn Arndt; 01-29-2007 at 05:03 PM.. Reason: Won't work
# 4  
Old 01-29-2007
I'll try to redeem myself with something that might work:
Code:
var=$(<infile.txt); echo $var | sed 's/ /,/g'

This also seems to work:
Code:
echo $(<infile.txt) | sed 's/ /,/g'

Last edited by Glenn Arndt; 01-29-2007 at 05:42 PM..
# 5  
Old 01-29-2007
perl -pi -e 's/^\n/,/' file

if you have a perl on you machine
# 6  
Old 01-29-2007
Quote:
Originally Posted by Glenn Arndt
Smilie Woops, won't work for long lists; disregard.
Neither mine.
May be tr and sed would be more appropriate in those cases.
# 7  
Old 01-29-2007
Use paste...
Code:
paste -s -d "," < file
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need some help in formatting answer of shell script

Dear all, I am new to shell scripting and have tried to make a small program for fun sake that tells age from the last number of cell phone and birth year. At the end we get a final 3 digit number and the first digit represents the last digit of cell phone and rest 2 numbers shows age. eg. 423... (4 Replies)
Discussion started by: stg44
4 Replies

2. Shell Programming and Scripting

Formatting a file using shell script

Hi, Please find the below lines of a file B1/OT "GIB10" 837 130308 1351 MONORONOUS DIGI PATH FAULT SUPER B1/OT "GIB10" 520 130418 1537 MONORONOUS DIGI PATH FAULT SUPER B1/XT "GIB10" 762 130421 0653 TV Y-CEIVER ADMIN RXOCF-62 241_OKEBOLE_NEW 1 B1/XT "GIB10" 385 130425 1931 TV Y-CEIVER... (2 Replies)
Discussion started by: Ardhendu
2 Replies

3. Shell Programming and Scripting

Formatting Shell script output to Excel

I am facing a problem formatting the output of my shell script in excel. We are directing the output of the script to an excel sheet and need long integer type data printed in Excel as it is (i.e. not in the default scientific notation). Also, leading zeroes(if any) in the output are getting... (4 Replies)
Discussion started by: bornali.p
4 Replies

4. Shell Programming and Scripting

Formatting File Using Shell Script

Hi Team, We have a requirement where we need to format input file using shell script by meeting the below conditions. 1. 1. Ignore first 549 characters of that file. 2. 2. After that we need to make a file of 100 characters per line, repeat it until the 3rd ... (16 Replies)
Discussion started by: ataneja7
16 Replies

5. Shell Programming and Scripting

formatting a shell script

there is one shell which calls for different sql scripts. output of different are formatted in frame like structure.i want columnar wise formatting to be done in such a manner that output of one sql may be comon input of rest sqls . ERC DML Closure Date ER DML SAP Transfer Date ... (0 Replies)
Discussion started by: arc
0 Replies

6. Shell Programming and Scripting

Formatting a file using shell script

I have a file with contents something similar to as below : SVCNAME,12m-1a,1a-2a,2a-3a,3a-4a,5a-6a,6a-7a,7a-8a,8a-9a,9a-10a,10a-11a,11a-12n,12n-1p,13p-14p,14p-15p,15p-16p,16p-17p,17p-18p,18p-19p,19p-20p,20p-21p,21p-22p,22p-23p,11p-12m, TOTALS... (5 Replies)
Discussion started by: deo_kaustubh
5 Replies

7. Shell Programming and Scripting

Date formatting in shell script

Hi, I am writing a script and I need to calculate last weeks date. I get the current date as; today=`date '+%Y%m%d'` and I need last week inthe same format. Thanks, (2 Replies)
Discussion started by: ozum
2 Replies

8. Shell Programming and Scripting

Help with shell script in formatting the records.

I have a text file in the following format. can any one please help me in printing the output in userfriendly format mentioned below. Input. 1) /ss/abc/1/w/s/domainname/abc1/logname/ ########error################### ########error################### ########error###################... (2 Replies)
Discussion started by: vinny81
2 Replies

9. Shell Programming and Scripting

formatting a file using shell script

Hi I have to do the following.I have to format a file test.t The contents are # Header 1231 xyz asdf asdapsdcsd //string1 = "pqrs" //string1 = "abcd"; //info //string1 = "*pqrs"; //add string1 = "#123"; //sub //string1 = "#1234567890" data = check(string1) //string1 = "#1234567890"... (12 Replies)
Discussion started by: gopsman
12 Replies

10. UNIX for Advanced & Expert Users

Date Formatting in Shell Script

Hi, Can anybody throw somelight on how to handle date in a shell script? I need to pass the date in this format 'yymmdd' and then pad it to a file. The way in which i've handled is given below, but the date is not getting passed rather the file is getting created with a null date. Any... (2 Replies)
Discussion started by: Isiva
2 Replies
Login or Register to Ask a Question