asked on

how to parse a large file for information

I need to get information from a master file that contains user names and machines.
The 4th field contains the usernames and the 9th field contains systems that the user has access to.
My task is to create a list in 2 columns ( user host) that will list a user and every machines he/she has access to. The username will be repeated for each machine in the file.
i am looking for a simple script that can accomplish this.Can any scripting guru please help?
Thanks in advance.

omarfarid

initially, you could do:

awk '{print $1, $9}' filename

if you can provide sample file data then script can be improved

Tintin

Please give some sample input/output.

nesiuna_1

ASKER

this is the input file:
+gshepher:Yi/mOb6QeRcaU:5032:Greg Shepherd:/home/gshepher:/usr/bin/tcsh::staff,develop:ap1-bb15,ap1-bb15ua
t,ap1-chase,ap1-chasebb,ap1-cvmssm,ap1-gpcorr,ap1-gpmor,ap1-gprc
i need to parse the 4th field and the 9th field.
The 4th field is the username and the 9th field is the hostnames
what i need is a printout in this format:
User Hostname
user1 host1
user1 host2
user2 host1
user2 host2

Tintin

awk -F, '{printf "%-10s\t%s\n",$4,$9}' inputfile

simon3270

awk -F: 'BEGIN{printf "%s\t%s\n","User","Hostname"}{printf "%s\t%s\n",$4,$9}' inputfile

(-F: because colon is the field separator)

nesiuna_1

ASKER

The output of this script is this:
Felix Roytfeld ap8-qa,perfap1-dv,perfdb1-dv,perfwb1-dv,sjcapp05

But what i am looking for something like this:
User Host
Felix Roytfeld ap8-qa
Felix Roytfeld perfap1-dv
Felix Roytfeld perfb1-dv
Felix Roytfeld sjcapp05

How can i the program to print out in this format?
Thanks

ASKER CERTIFIED SOLUTION

simon3270

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nesiuna_1

ASKER

Thank you very much for your professional help.
i really appreciate the timely response.