Visit Our UNIX and Linux User Community


records in a line


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting records in a line
# 1  
Old 09-30-2009
records in a line

Hi
I have a file "sample.txt"
--------------------
1
2
3
4
5
6
7

---------------------------

i want out like this
---------------------------
1,2,3,4,5,6,7
---------------------------


please provide script,
# 2  
Old 10-01-2009
if you don't mind a trailing comma, you can do it in one line
Code:
tr "\n" "," < in > out

if not:
Code:
#!/bin/sh
touch out
LINECT=`cat in|wc -l`
COUNTER=1
while read line
do
  if [ ${COUNTER} -lt ${LINECT} ]
  then
     echo $line|tr "\n" "," >> out
  else
     echo $line >> out
  fi
  COUNTER=`expr $COUNTER + 1`
done < in


Last edited by varontron; 10-01-2009 at 12:17 AM..
# 3  
Old 10-01-2009
Code:
# tr "\n" "," < file
1,2,3,4,5,6,7,
# awk -F, '{a=a?a FS$0:$0}END{print a}'  file
1,2,3,4,5,6,7

# 4  
Old 10-01-2009
Code:
cat urfile |xargs -n7

# 5  
Old 10-01-2009
Code:
tr '\n' ',' < file|sed 's/.$//'

regards,
Sanjay
# 6  
Old 10-01-2009
Hi

Code:
paste -s -d',' $file_name

# 7  
Old 10-01-2009
awk 'ORS=","{print $0}' file

Previous Thread | Next Thread
Test Your Knowledge in Computers #394
Difficulty: Medium
POSIX mandates 1024-byte default block sizes for the df and du utilities, reflecting the typical size of blocks on disks.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Creating duplicate records from a single line

Hi All, I would like to create a 1 million duplicate records from a single fixed length row. Is there a simple way to create this quickly in unix. I am using korn shell on the AIX OS. For ex, 100234 XHYSDDS SDSD OUPUT (1 million rows) 100234 XHYSDDS SDSD . . . 100234 XHYSDDS SDSD... (5 Replies)
Discussion started by: saratha14
5 Replies

2. Shell Programming and Scripting

Need the line number of failed records

Hi awk Gurus, I have file as below : file1.txt 7000,2,1,6 7001,2,1,7 7002,2,1,6 7003,1,2,1 file2.txt 7000,john,2,0,0,1,6 7000,john,2,0,0,1,7 7000,john,2,0,0,1,8 7000,john,2,0,0,1,9 7001,elen,2,0,0,1,7 7002,sami,2,0,0,1,6 7003,mike,1,0,0,2,1 (13 Replies)
Discussion started by: arunshankar.c
13 Replies

3. UNIX for Dummies Questions & Answers

Grep specific records from a file of records that are separated by an empty line

Hi everyone. I am a newbie to Linux stuff. I have this kind of problem which couldn't solve alone. I have a text file with records separated by empty lines like this: ID: 20 Name: X Age: 19 ID: 21 Name: Z ID: 22 Email: xxx@yahoo.com Name: Y Age: 19 I want to grep records that... (4 Replies)
Discussion started by: Atrisa
4 Replies

4. HP-UX

Utmpd(1M) can't handle records with same line but different ids

For ddfa(7), telnetd(1M) needs to create user accounting database records with the same line (representing the remote side) but different ids (representing the pty that comes to be used for the connection), like line "telnet/ss10" with first id "tb" and then id "tf". Utmpd(1M) cannot handle... (1 Reply)
Discussion started by: madhurtripathi
1 Replies

5. Shell Programming and Scripting

Help to Add and Remove Records only from first line/last line

Hi, I need help with a maybe total simple issue but somehow I am not getting it. I am not able to etablish a sed or awk command which is adding to the first line in a text and removing only from the last line the ",". The file is looking like follow: TABLE1, TABLE2, . . . TABLE99,... (4 Replies)
Discussion started by: enjoy
4 Replies

6. Shell Programming and Scripting

Capturing multi-line records containing known value?

Some records in a file look like this, with any number of lines between start and end flags: /Start Some stuff Banana 1 Some more stuff End/ /Start Some stuff End/ /Start Some stuff Some more stuff Banana 2 End/ ...how would I process this file to find records containing the... (8 Replies)
Discussion started by: cs03dmj
8 Replies

7. Shell Programming and Scripting

Singled line records

Hi, :cool: Im new on this Linux groups and like to learn more, Right now, Im working on a project (personal) and have a question fallowing problem Im making a bash script to read many files and extract some fields and separate them according certain criteria, let say a have a big file... (4 Replies)
Discussion started by: Zopilota
4 Replies

8. Shell Programming and Scripting

how to delete records with the given line numbers

I have a file which has about 10000 records and I need to delete about 50 records from the file. I know line numbers and am using sed '134,1357,......d' filename > new file. It does not seem to be working. Please Advice (5 Replies)
Discussion started by: mad_man12
5 Replies

9. Shell Programming and Scripting

Change a Char Multiple line records

Hi All i have a file that is to big for vi and is a multiple line record 3999||20090127163547796|196.46.162.250|1028|196.207.40.112|2152|00:0C:31:BB:25:5 4|00:00:0C:07:AC:06|655016000575511|05||3C65|0D029C1D|||00644B5A|||||||||||inter... (5 Replies)
Discussion started by: gseptember
5 Replies

10. UNIX for Advanced & Expert Users

delete records using line number(NR)

Hai I have a flat file which contains more than 6 crore lines or records. I want to delete only one line, using line number. For example I want to delete 414556 th line . How to do this using sed or awk command. thanks (3 Replies)
Discussion started by: tkbharani
3 Replies

Featured Tech Videos