Shell Programming and Scripting

i have this sample data:

test01 --- abc-01 name1
abc-02 name2
abc-03 name3

test02 --- abc-20 name4
abc-21 name5

test03 --- abc-22 name6
abc-23 name7


i want to generate a file that looks like:

test01 abc-01 name1
test01 abc-02 name2
test01 abc-03 name3
test02 abc-20 name4
test02 abc-21 name5
test03 abc-22 name6
test03 abc-23 name7

i know awk can use RS (record seperator) but i dont know much of it. pls help

thanks!

Here's your sample data in a code block to remove ambiguity about spacing after fishing around in "view page source" in my browser. I also realigned it to what I guess your data really looks like. The fact of spacing matters more to awk than the amount of spacing anyhow, but everyone who posts here should be aware that alignment gets ruined by the VBcode->HTML conversion unless it's in a code block.

Code:

test01 ---   abc-01     name1
             abc-02     name2
             abc-03     name3

test02 ---   abc-20     name4
             abc-21     name5

test03 ---   abc-22     name6
             abc-23     name7

Fiddling with RS is not helpful here.
This should do what you want, though it is untested code, and you shouldn't run it until you understand it.

Code:

#!/usr/bin/awk
NF == 0 { next }                      # Skip empty lines
NF == 4 { tag = $1 }                  # Pick up the tag
        { print tag, $(NF - 1), $NF } # Print lines with data

The moderators will probably want to move this to the shell scripting forum.

You know more than I do about awk - I would've come up with some convoluted mess to do that.

I can tell what your code is doing, but I'm wondering, won't the two lines

Code:

NF == 4 { tag = $1 }                  # Pick up the tag
        { print tag, $(NF - 1), $NF } # Print lines with data

only pick up on, say,

Code:

test01 ---   abc-01     name1

but not

Code:

             abc-02     name2
             abc-03     name3

?

hey, you are right about the spacing and the forum. i think this topic should be moved with the shell scripting forum. will the moderators do this for me :P

thanks alot!

Nope. Your confusion may come from a mistaken notion that the pattern/action pairs look like exclusive cases, but you should look at them like a C switch statement: You fall through to the next "case" (awk "pattern") unless you encounter a "break" (awk "next"). So NF == 0 { next } skips empty lines. Then NF == 4 { tag = $1 } picks up the first field and goes to the next pattern when there are four fields. The next pattern is empty, so it matches every line that wasn't "next"-ed so far, and its action is to print the saved tag and the last two fields from the current input line. If there is exactly one field on a line, awk will break in this last case, but that wasn't part of the OP's stated problem.

how do i code block? i would like to make some corrections in my post :P

When you're making a post to the forums, you should see some buttons above the textbox you type your message in. Look for a button with the # symbol on it to insert code. Read the help page for more on VB Code.