Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

separating entries by using cat command

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting separating entries by using cat command
# 1  
Old 01-28-2008
separating entries by using cat command
Hi there,

Is there any option if I cat the following line from a file and than redirect to another as separate entries:

unixsrv1:unixsrv2:unixsrv3:mercury:mercury01:sunprd01:sunprd02:hpprod07:ibmprod43

output to file shoudld be:
unixsrv1
unixsrv2
unixsrv3
... and so on.

Your help is really appreciated.
# 2  
Old 01-28-2008
Code:
echo 'unixsrv1:unixsrv2:unixsrv3' | tr ':' '\n'

# 3  
Old 01-28-2008
try this:
Code:
sed 's/:/\n/g' file

# 4  
Old 01-28-2008
Code:
tr ":" "\n" < file

# 5  
Old 01-28-2008
MySQL Try this....
Input file:-
$ > cat 123.txt
unixsrv1:unixsrv2:unixsrv3:mercury:mercury01:sunprd01:sunprd02:hpprod07:ibmprod43
$ >

Command:-
$ > cat 123.txt | tr -s ":" "\n" > 123_1.txt
$ >

Output:-
$ > cat 123_1.txt
unixsrv1
unixsrv2
unixsrv3
mercury
mercury01
sunprd01
sunprd02
hpprod07
ibmprod43
$ >

Thanks,
Karthik.
# 6  
Old 01-29-2008
Excellent !! you guys are the best helpers.

A quick ?, how can I get rid of the duplicate entries: This is what I have now;
unixsrv1
unixsrv1
.
.
.
unixsrv1 (20 entries)
same for the other hosts.

I ran the following command but no luck!
# cat file | sort | uniq -d

Thanks again guys.
# 7  
Old 01-29-2008
do not use the -d option of uniq command

edit: so this should do the job for you: cat file | sort | uniq
Last edited by Yogesh Sawant; 01-29-2008 at 07:56 AM.. Reason: added the complete command
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help need on cat command

I have two files as below 1.txt AA 123 CC 145 DD 567 2.txt AA 111 YY 128 CC 144 FF 222 DD 777 ZZ 875 basically 1.txt is updated file, if i do cat 1.txt 2.txt output should be as below o/p (2 Replies)
Discussion started by: Tecnical_help12
2 Replies

2. AIX

cat command

Hi. How can i write a command on AIX like the one i did at linux that find string in a file and show me that string, and return 3 lines before and 4 lines after that string. my linux command is: /bin/cat <filename> | tail -150 | grep -B2 -A8 "<string to look for>" Example: /bin/cat ... (10 Replies)
Discussion started by: yechi_r
10 Replies

3. Homework & Coursework Questions

Need some help on using cat command

I have a file "sample.txt" with the content as below: Hi This is a Sample Text. I need a single command using cat which serve the following purpose. 1.display the contents of sample.txt 2.append some text to it 3. and then exit But, all should be served by a sinle... (1 Reply)
Discussion started by: ashok.g
1 Replies

4. Shell Programming and Scripting

Cat command help

I want to concatenate 100 files to one file and append file name in each record to find out which file it came from for a in $(<shal_group) do cat $a >> bigoutput.group The above code put all files in one file but i want file name appended to each file Record should be like this... (3 Replies)
Discussion started by: pinnacle
3 Replies

5. UNIX for Advanced & Expert Users

cat command

I believe I used the cat command to append a file beside another file (instead of below it) but I did not document it any where and I can't remember exactly how I did it. Has anyone else done this? I have tried all the cat options individually with no luck. It may be a combination of options. ... (2 Replies)
Discussion started by: nickg
2 Replies

6. Shell Programming and Scripting

cat in the command line doesn't match cat in the script

Hello, So I sorted my file as I was supposed to: sort -n -r -k 2 -k 1 file1 | uniq > file2 and when I wrote > cat file2 in the command line, I got what I was expecting, but in the script itself ... sort -n -r -k 2 -k 1 averages | uniq > temp cat file2 It wrote a whole... (21 Replies)
Discussion started by: shira
21 Replies

7. UNIX for Dummies Questions & Answers

Difference between cat , cat > , cat >> and touch !!!

Hi Can anybody tell the difference between Difference between cat , cat > , cat >> and touch command in UNIX? Thanks (6 Replies)
Discussion started by: skyineyes
6 Replies

8. AIX

cat command

I would like to append some statement into 1 single file so that it can be concatenate together in 1 word. I have tried >> but it will seperate my 2 statement into 2 rows. # cat abc.txt cde.txt > result.txt where abc.txt is "abcde" and cde.txt is "12345" the result should come out as... (3 Replies)
Discussion started by: kwliew999
3 Replies

9. UNIX for Dummies Questions & Answers

CAT command

All - how do i save the file after i used CAT command line to modify? Thanks :confused: (2 Replies)
Discussion started by: March_2007
2 Replies

10. Shell Programming and Scripting

the CAT command

hi everybody, how do i open a txt file writen in unix on to a web page so when i want to view the txt file that was generated from a shell program, that file is open on a web page do i use the cat > filename.html command to do this, or is there another way many thanks :D (2 Replies)
Discussion started by: alexd
2 Replies
Login or Register to Ask a Question