Search and sort help


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Search and sort help
# 1  
Old 05-20-2014
Search and sort help

Hi guys - I have a file that has messages like this below.

Code:
Message 1:
1=ADBN 11324=OIN24 334=34RD 10=10.11
 
Message 2:
12=345 199=WWLO 99=WWED


Both messeges arent related to each other.

I am trying to get all the values before the "="

For example, I would like to grep and get an output for Message 1 to look like this:

1
11324
334
10

Then I do the same for Message 2.

How to get it?

Thanks
# 2  
Old 05-20-2014
Code:
awk -F'[= ]' '/^Message/ {print;next}; NF{for(i=1;i<=NF;i+=2) print $(i)}' myFile

This User Gave Thanks to vgersh99 For This Post:
# 3  
Old 05-20-2014
If you don't care about anything in the other lines:
Code:
awk '!/Message/ && /=/ {for (i=1; i<=NF; i++){split($i, a, "=");print a[1]}}' file1

If you want to separate them by messages:
Code:
awk '/^Message/{print;next}; /=/{for (i=1; i<=NF; i++){split($i, a, "=");print a[1]}}' file1


Last edited by Aia; 05-20-2014 at 04:47 PM.. Reason: Added Message alternative
This User Gave Thanks to Aia For This Post:
# 4  
Old 05-20-2014
Thank you.

Also, how should I get the entire value.

For example an output like this:

Code:
1=ADBN 
11324=OIN24 
334=34RD 
10=10.11


Last edited by vgersh99; 05-20-2014 at 05:05 PM.. Reason: code tags, please!
# 5  
Old 05-20-2014
Code:
awk '/^Message/{print;next}; /=/{for (i=1; i<=NF; i++)print $i}' file1

or
Code:
 awk '!/Message/ && /=/ {for (i=1; i<=NF; i++)print $i}' file1

This User Gave Thanks to Aia For This Post:
# 6  
Old 05-20-2014
Actually Aia, in the first code you gave me is showing everything to the right of the "="

How to produce the left of "="

For example the output should be like this:

1
11324
334
10
# 7  
Old 05-20-2014
Quote:
Originally Posted by DallasT
Thank you.

Also, how should I get the entire value.

For example an output like this:

Code:
1=ADBN 
11324=OIN24 
334=34RD 
10=10.11

Code:
awk '/^Message/ {print;next}; NF{for(i=1;i<=NF;i++) print $i}' myFile

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Use sort to sort numerical column

How to sort the following output based on lowest to highest BE? The following sort does not work. $ sort -t. -k1,1n -k2,2n bfd.txt BE31.116 0s 0s DOWN DAMP BE31.116 0s 0s DOWN DAMP BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 Replies

2. UNIX for Beginners Questions & Answers

Difference of Sort -n -k2 -k3 & Sort -n -k2,3

Hi, Could anyone kindly show me a link or explain the difference between sort -n -k2 -k3 & sort -n -k2,3 Also, if I like to remove the row with repetition at both $2 and $3, Can I safely use sort -u -k2 -k3 Example; 100 20 30 100 20 30 So, both $2 and $3 are same and I... (2 Replies)
Discussion started by: Indra2011
2 Replies

3. Shell Programming and Scripting

Sort data by date and then search by column

Hi, I have a file where data is pipe separated.First i want to sort the file content by date . Then i want to pick up the records based on the first column which should be unique and not have duplicates. NYSE|yyyrrrddd|toronto|isin|ticker|2013-05-15... (2 Replies)
Discussion started by: samrat dutta
2 Replies

4. Shell Programming and Scripting

Sort help: How to sort collected 'file list' by date stamp :

Hi Experts, I have a filelist collected from another server , now want to sort the output using date/time stamp filed. - Filed 6, 7,8 are showing the date/time/stamp. Here is the input: #---------------------------------------------------------------------- -rw------- 1 root ... (3 Replies)
Discussion started by: rveri
3 Replies

5. Shell Programming and Scripting

Help with sort word and general numeric sort at the same time

Input file: 100%ABC2 3.44E-12 USA A2M%H02579 0E0 UK 100%ABC2 5.34E-8 UK 100%ABC2 3.25E-12 USA A2M%H02579 5E-45 UK Output file: 100%ABC2 3.44E-12 USA 100%ABC2 3.25E-12 USA 100%ABC2 5.34E-8 UK A2M%H02579 0E0 UK A2M%H02579 5E-45 UK Code try: sort -k1,1 -g -k2 -r input.txt... (2 Replies)
Discussion started by: perl_beginner
2 Replies

6. Shell Programming and Scripting

Alternate to sort --random-sort

sort --random-sort The full command is path=`find /testdir -maxdepth 1 -mindepth 1 -type d | ***Some sort of sort function*** | head -1` I have a list I want to randomly sort. It works fine in ubuntu but on a 'osx lion' sort dosen't have the --random-sort option. I don't want to... (5 Replies)
Discussion started by: digitalviking
5 Replies

7. Shell Programming and Scripting

Is it Possible to sort a list of hexadecimal numbers using "sort" command?

Hello Everybody :) !!!. i have question in mind, is it possible to sort a list of hexadecimal numbers using "sort" command? (9 Replies)
Discussion started by: Kesavan
9 Replies

8. UNIX for Advanced & Expert Users

Script to sort the files and append the extension .sort to the sorted version of the file

Hello all - I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
Discussion started by: pankaj80
3 Replies

9. Shell Programming and Scripting

How to Sort Floating Numbers Using the Sort Command?

Hi to all. I'm trying to sort this with the Unix command sort. user1:12345678:3.5:2.5:8:1:2:3 user2:12345679:4.5:3.5:8:1:3:2 user3:12345687:5.5:2.5:6:1:3:2 user4:12345670:5.5:2.5:5:3:2:1 user5:12345671:2.5:5.5:7:2:3:1 I need to get this: user3:12345687:5.5:2.5:6:1:3:2... (7 Replies)
Discussion started by: daniel.gbaena
7 Replies

10. Shell Programming and Scripting

Search max value in a column in a file instead of sort

Hi Everyone, 1.txt 00:00:00 0 0 0 0 0 0 0 00:00:01 0 0 0 2 1 33 2 00:00:02 5 0 0 0 0 0 0 00:00:03 0 4 0 0 0 0 0... (5 Replies)
Discussion started by: jimmy_y
5 Replies
Login or Register to Ask a Question