[SOLVED] Parsing delimited file

rexjenny · 07-09-2011, 09:16 AM

Advance thanks for your help. I have a tab delimited file containing the ldap username and their corresponding passwords in the following format

dn:uid=user1,o=foobar.com new_password
dn:uid=user2,o=foobar.com new_password
dn:uid=user3,o=foobar.com new_password

what i want to achieve is loop through the file and create text in the below format with a space in between them. Please help me out as am not so good with scripting. Thanks once again

dn:uid=user1,o=foobar.com
changetype:modify
replace:userpassword
userpassword:new_password

dn:uid=user2,o=foobar.com
changetype:modify
replace:userpassword
userpassword:new_password

dn:uid=user3,o=foobar.com
changetype:modify
replace:userpassword
userpassword:new_password

colucix · 07-09-2011, 09:24 AM

Time to learn awk!

Code:

awk -F"\t" '{ print $1; print "changetype:modify"; print "replace:userpassword"; print "userpassword:" $2; print "" }' infile > oufile

rexjenny · 07-09-2011, 09:33 AM

Quote:

Originally Posted by colucix

Time to learn awk!

Code:

awk -F"\t" '{ print $1; print "changetype:modify"; print "replace:userpassword"; print "userpassword:" $2; print "" }' infile > oufile

Geez

that was a fast reply or what

Works flawlessly. Thanks a lot will start learning awk and sed as soon as i can.