Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

How to have the output in grep?

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers How to have the output in grep?
# 1  
Old 04-22-2014
How to have the output in grep?
Hi guys -

I am trying to have a certain file display information horizontally divided by a pipe.

for example

file name: foo.dat has information like this:
Code:
name1
name2
name3
namenamename4
namene5

I would like it to display like this:
Code:
name1|name2|name3|namenamename4|namene5

Any help is appreciated.
Last edited by Franklin52; 04-23-2014 at 02:54 AM.. Reason: Please use code tags
# 2  
Old 04-22-2014
Please use code tags as required by forum rules!

Try
Code:
paste -sd'|' file
name1|name2|name3|namenamename4|namene5

This User Gave Thanks to RudiC For This Post:
Azrael
# 3  
Old 04-22-2014
Hi DallasT,

Can you show an example of the data, is it just one file? It may be better to use something like awk for this. Or alternatvely 'paste' will do itSmilie

Regards

Gull04
# 4  
Old 04-22-2014
Code:
awk '1' ORS='|' foo.dat

---------- Post updated at 01:24 PM ---------- Previous update was at 01:23 PM ----------

Code:
tr '\n' '|' < foo.dat

This User Gave Thanks to SriniShoo For This Post:
DallasT
# 5  
Old 04-22-2014
thanks everyone.

Special thanks to SriniShoo (as always).
# 6  
Old 04-22-2014
@SriniShoo: Unfortunately, both your proposals remove the final <new line> character necessary to make the output a correct *nix text file, and have a pipe char at the end that was not specified.
# 7  
Old 04-22-2014
pipe the output to sed and delete last character if you want to remove the last '|'
Code:
awk '1' ORS='|' foo.dat | sed 's/|$//'

This User Gave Thanks to SriniShoo For This Post:
Azrael
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Grep output

Hi. I have a command line that will generate exif data from .jpg files... So to get the Camera Model I use: find -iname "*.jpg" -print0 | xargs -0 exiftool -a | grep "Camera Model" But I want the file name AND the camera model... How to I get the grep to give me TWO bits of information from... (2 Replies)
Discussion started by: TuftyDave
2 Replies

2. Shell Programming and Scripting

How to grep the desired output and output to a file?

currently I have process from a raw file to this stage ALTER TABLE "EXCEL_ADMIN"."TC_TXN_VOID" ADD CONSTRAINT "PK_TC_TXN_VOID" PRIMARY KEY ("TC_TXN_IID") ALTER TABLE "EXCEL_ADMIN"."TC_TXN_AMT" ADD CONSTRAINT "PK_TC_TXN_AMT" PRIMARY KEY ("TC_TXN_AMT_IID") ALTER TABLE... (10 Replies)
Discussion started by: jediwannabe
10 Replies

3. UNIX for Dummies Questions & Answers

Grep output problem

Hi all, Here is my problem: I'm testing a login script for our mac Machines. This script output's in a csv file. The login script looks like this: echo "${computername}|${data1}|${data2}|${data3}" >> file.csv The csv file looks like this: Computername1|data1|data2|data3... (4 Replies)
Discussion started by: mattiasvdm
4 Replies

4. Shell Programming and Scripting

grep output

hi i am running grep -c on a bunch of files some of which may be non existent. The output i get is in the same order as the files grep checks and this is what i want as i need to copy the output to a spreadsheet. However when i tried to pipe the output to sed to strip away the filenames and just... (5 Replies)
Discussion started by: chronics
5 Replies

5. Shell Programming and Scripting

grep output

From below mentioned line,i have to display output as last word only ie:arch_1_105366_720809746.dbf -rw-r----- 1 oracle dba 98887680 02 Mar 12:01 arch_1_105366_720809746.dbf Please .. (5 Replies)
Discussion started by: Sanal
5 Replies

6. UNIX for Dummies Questions & Answers

Help with grep output

Hello, I have a list of stings that I'm using with grep to determine which files contain the strings. Here's what I have now: list of strings in a file (list.txt): /directory/direc tory/file.jsp /dire ctory/directory/direct ory/file.jsp grep I'm doing to find files that contain the... (4 Replies)
Discussion started by: upstate_boy
4 Replies

7. Shell Programming and Scripting

GREP with contain output

How can I perform a grep and it will give me a contain word (maintenance) instead of a string or the whole line of info. grep with exclusive output? or is there a CONTAIN with IF statement ? I have a file call yast2_vhost.conf and it contain multiple entries call maintenance.html... (2 Replies)
Discussion started by: yoom@hostwebase
2 Replies

8. UNIX for Dummies Questions & Answers

recursive grep output

I'm using this command to get a recursive grep find . -name *.i -exec grep 'blah blah' {} \; -exec ls {} \; now I would like to obtain just the list of the files and not also the line of the file. How should I change the syntax? thank you, (5 Replies)
Discussion started by: f_o_555
5 Replies

9. Shell Programming and Scripting

output of grep

hi, why the following is giving entire /etc/passwd file as output even when it does not contain ^ or $ . grep ' ' /etc/passwd whereas the following is not giving any output grep ' ^$ ' /etc/passwd (3 Replies)
Discussion started by: useless79
3 Replies

10. UNIX for Dummies Questions & Answers

Strange output from grep

Hi, I am getting different output for grep depending which directory I am in. The following is a transcript of my session, I am using egrep but have also used grep -E. The directory names have been changed for security: $pwd /dir1/dir2/dir3/dir4 $echo 000000 |egrep -v $echo $? 1 $cd ..... (10 Replies)
Discussion started by: Bab00shka
10 Replies
Login or Register to Ask a Question