awk question

jonlake · 05-04-2005, 12:47 PM

I have a file named output and it is formatted like this

uid=xxxxxxxx
mail=xxxxxxxxxxx
usfvaultgrp=SECURITY
usfvaultuserkey=mOiGd+od8is=
USFLdapAdminRole=super
cn=Walter
sn=Walter
gecos=Scott Walter
objectClass=top
objectClass=person
objectClass=organizationalPerson
objectClass=inetorgperson
objectClass=posixAccount
objectClass=shadowAccount
objectClass=account
objectClass=usfperson
telephoneNumber=xxxxxxx
givenName=Scott
homeDirectory=/net/home/swalter
gidNumber=7
uidNumber=1003
uid=swalter
loginShell=/bin/ksh

uid=TSC
mail=xxxxxxxxxxxxx
objectClass=top
objectClass=person
objectClass=organizationalPerson
objectClass=inetorgperson
telephoneNumber=xxxxxxxxx
givenName=Help
sn=Desk
uid=TSC
cn=Help Desk

with many more sections. I am putting a line in my script that says

Code:

awk '{ FS="\n" ; OFS="," ; RS="^$" ; ORS="\n" ; print ; }' output > file

My understanding is it should take each line in a section, change it to a csv line, and each section should be a new line. However, I get an error

Code:

migrrufrsa01:jlake> ./script
awk: record `mail=xxxxxxxxxxxxxxxx...' too long
 record number 1
host:jlake>

homey · 05-04-2005, 03:38 PM

This site has an example which may be what you're after
http://www-106.ibm.com/developerwork...ry/l-awk2.html

I run it like this: awk -f test file.txt > file1.txt

Code:

#!/bin/bash

BEGIN {
    FS="\n"
    RS=""
    ORS=""
}

{
        x=1
        while ( x<NF ) {
                print $x ","
                x++
        }
        print $NF "\n\n"
}

Edit: I changed this to give better record separation....
print $NF "\n\n"

jonlake · 05-04-2005, 03:58 PM

Ok I want to go a different way than I initially though, when I posted this.

I want to print out the UID, CN, GECOS, Mail, Telephone, Homedirectory in each column.
I got that I can setup each section as a record, and each line as a field. As you can see, they aren't always the same field (cn would be $6 on the first record, and $11 on the second). I only want these fields, in the specified order. I know how to do it if they were in the same order everytime, but they aren't.

Currently I am to the point of where sed gets rid of the unneeded lines (although i can't get rid of the first uid line) and as said before, can get awk to see each section as a record, and each line as a field.

Thanks,

Jon