Search Results

It works! Wow that's brilliant.
Thank you so much for the help and for rekindling esteem for the awesome awk.

The final version for anyone who wants to know:

awk -F '[,:]' '{ for ( i=6; i <=...

Nearly!
It was having problems with the six trailing ,,,,,, so I have stripped these out with sed first.

But it is still is skipping the first subject. I think this is because of the delimiter....

Sorry. No good.

awk -F '[,:]' '{ for ( i=7, i <= NF i++) { printf "%s,%s,%s\n", $1, $2, $i } }'


The error message is:
awk: syntax error at source line 1
context is
{ for ( >>> ...

Hi Anbu
Thanks for this lovely looking awk array
awk -F"," ' {
str=$1
for( i = 2 ; i <= NF - 7 ; ++i )
str=str "," $i
n=split($(NF-6),arr,":")
for( i = 1 ; i <= n ; ++i )
print str ","...

Thanks - Yes, probably should have been really specific
The file I'm working with will have hundreds of lines. The first few lines basically like this (incl headers)


The end of each line always...

Wow! This rocks.
That seems to work. Unbelievable.

The actual file may have anywhere from 1 to 10 or more colon separated subjects per user. Do you think it will still work Ok?

I guess I'm...

Hello does anyone know how to do the following using some simple unix if possible:

I have a file with the following info as comma separated. It shows username, id number and all the subjects they...