Rta data needs regexp


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Rta data needs regexp
# 1  
Old 02-17-2014
Rta data needs regexp

Hi

echo "rta=58.124001ms;100.000000;150.000000;0.000000"

I required 58.12 and 0.00 i,e from first and last.

I tried using : awk -F"rta=" '{print $2}' and last one awk -F";" '{print $4}' but unsuccessful.

Thanks
# 2  
Old 02-17-2014
Code:
awk -F"[=;]" ' { print $2, $NF } '

This User Gave Thanks to anbu23 For This Post:
# 3  
Old 02-17-2014
Code:
echo "rta=58.124001ms;100.000000;150.000000;0.000000 pl=0%;5;15;0" | awk -F"[=;]" ' { print $2, $NF } '
58.124001ms 0

I just required 58.12 and 0.00 - Could you please assist.

Last edited by Franklin52; 02-17-2014 at 08:41 AM.. Reason: Please use code tags
# 4  
Old 02-17-2014
Code:
awk -F"[=;]" ' { printf("%.2f %.2f",$2, $NF) } '

This User Gave Thanks to anbu23 For This Post:
# 5  
Old 02-17-2014
You can try this for accurate result

Code:
cat file1 | awk -F"[=;]" '{ print $2,$NF }' | cut -c 1-5," ",13-16


Last edited by Franklin52; 02-17-2014 at 08:42 AM.. Reason: Please use code tags
This User Gave Thanks to 24ajay For This Post:
# 6  
Old 02-17-2014
Quote:
Originally Posted by ashokvpp
Code:
echo "rta=58.124001ms;100.000000;150.000000;0.000000 pl=0%;5;15;0" | awk -F"[=;]" ' { print $2, $NF } '
58.124001ms 0

I just required 58.12 and 0.00 - Could you please assist.
You didn't print that desired 0.000000 but the last single 0 that was not present in your post #1's sample.
Code:
rta=58.124001ms;100.000000;150.000000;0.000000 pl=0%;5;15;0"
                                      ^-desired           ^-printed

With this sample, even anbu23's formatted printout would not deliver the correct value. If the correct value is last in line, the proposals will work fine, if it's not, you need to supply more conditions how to identify it.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. What is on Your Mind?

A Regexp You Can Use Everywhere

\_(ツ)_/ bakunin (0 Replies)
Discussion started by: bakunin
0 Replies

2. Shell Programming and Scripting

Regexp

I would like to extract "1333 Fairlane" given the below text. The word "Building:" is always present. The wording between Building and the beginning of the address can be almost anything. It appears the the hyphen is there most of the time. Campus: Fairlane Business Park Building:... (9 Replies)
Discussion started by: bbaker@copesan.
9 Replies

3. Shell Programming and Scripting

Need help with sed and regexp

Hi everyone, I would really appreciate any help I could get on the following topic. I am not very familiar with reg expressions nor with sed, I just know the basic uses. What I am trying to do is the following: I have a huge text file where I would like to replace all occurnces of a certain... (13 Replies)
Discussion started by: Boxtuna
13 Replies

4. Shell Programming and Scripting

printing data between 2 occurances of regexp

Hi, I an new to this forum and i need help with awk regex processing. I am trying to print chunk of data between occurances of reg expression for example: regex chunkofdata1 regexp chunkofdata2 regexp i want to print "chunkofdata1" to file1 , "chunkofdata2" to file2 .. and so on ... (2 Replies)
Discussion started by: ss1984
2 Replies

5. UNIX for Dummies Questions & Answers

print the line immediately after a regexp; but regexp is a sentence

Good Day, Im new to scripting especially awk and sed. I just would like to ask help from you guys about a sed command that prints the line immediately after a regexp, but not the line containing the regexp. sed -n '/regexp/{n;p;}' filename What if my regexp is 3 word or a sentence. Im... (3 Replies)
Discussion started by: ownins
3 Replies

6. Shell Programming and Scripting

Help with regexp

Hi there! I would like to know how to find and replace all numbers in a *.html file and make them bold. Any help will be appreciated! :) (7 Replies)
Discussion started by: agasamapetilon
7 Replies

7. Shell Programming and Scripting

regexp help

I'd like to know if there is a catchall line for renaming the following patterns: s01e03 -> 01x03 s4e9 -> 04x09 s10e08 ->10x08 and possibly even: 318 -> 03x18 1002 ->10x02 if its the first 3 or first digit number in the string. thanks! (0 Replies)
Discussion started by: TinCanFury
0 Replies

8. Shell Programming and Scripting

regexp with sed again!!!

please help: I want to add 1 space between string and numbers: input file: abcd12345 output file: abcd 1234 The following sed command does not work: sed 's/\(+\)\(+\)/\1 \2/' file Any ideas, please Andy (2 Replies)
Discussion started by: andy2000
2 Replies

9. Shell Programming and Scripting

Need Help with Perl REGEXP

I need help with a Perl regular expression. The following string blows up my program: <david(greg jim)> If I type this string, there is no problem: <david(greg_jim)> or type david(gregjim) or type <david greg jim> the CGI program does not complain. For some reason that I do not understand the... (1 Reply)
Discussion started by: mh53j_fe
1 Replies

10. UNIX for Advanced & Expert Users

regexp

Hi guys, does anyone know how to test for a regular expression - i want to include it in a script to make sure the variable is a regexp cheers (1 Reply)
Discussion started by: penfold
1 Replies
Login or Register to Ask a Question

Featured Tech Videos