UNIX for Dummies Questions & Answers

Hi I have some data where each line will look something like this:

Code:

Time, name, i.d number, RB: 0.9949; RMQA: 0.0005; RB: 0.9951; RRA: 0.3; RA: 0.995; RA: 0.996; EA: 0.99105

etc.

I want to cut out all the RB: and RA:'s with the numbers after.

so in the above example i'd be left with:

Code:

RB: 0.9949; RB: 0.9951; RA: 0.995; RA: 0.996

theres about 50 odd lines like this so I want to loop over them all.

Currently I'm trying

Code:

awk 'BEGIN { FS = "R[A|B]:" } { for (i=2; i <=NF; i++) printf "%s\n", $i }'

but its not working.

If possible I'd also like to include the time at the beginning of each line, which is in the format hh.mm.ss.000

I am a beginner to UNIX and do not have that much knowledge, any help would be greatly appreciated!

Thanks in advance

Moderator's Comments:

Please use code tags next time for your code and data.

Not sure how the other other lines look like, but this could be generic enough:

Code:

awk -F"[;,]" '{for(i=1; i<=NF; i++){if($i ~ /(RA|RB):/){x?x=x";"$i:x=$i}}} {print x; x=a}' infile

perfect thank you so much!!, I added a ^ before the RA as I just realised some of the lines had RRA or RRB so it was returning those too. I've been trying to solve this by googling for the past few hours!

---------- Post updated at 11:38 AM ---------- Previous update was at 11:30 AM ----------

sorry - one more thing,

how would I get the timestamp at the beginning of each line included?

hh:mm:ss.000

Code:

# awk -F"[;,]" -v date="$(date +%H:%M:%S).000;" '{for(i=1; i<=NF; i++){if($i ~ /(RA|RB):/){x?x=x";"$i:x=$i}}} {print date, x; x=a}' infile
105337.000;  RB: 0.9949; RB: 0.9951; RRA: 0.3; RA: 0.995; RA: 0.996

If the timestamp is instead supplied from the input file, you will have to show a relevant snippet of it.