I'm currently faced with a spreadsheet that has data formatted like this:
[MEMBER]
userid=ABC
last_name=DEF
first_name=ABD
[email protected]
telephone=xxxxxxxx
fax=8888888
title=Engineer
department=abcd
group=admin
[MEMBER]
userid=XYZ
last_name=IJK
access=0
role= MMM
group=consultant
[MEMBER]
userid=SSUSER
access=1
role=MMD
group=ADS
Every [MEMBER] is a new set of data that repeats itself. But might not have all the entries compared to other set.
I need to figure out a way to get the data in below mentioned format.
userid last_name first_name email_address telephone fax title department role group access
ABC DEF ABD [email protected] xxxxxxxx 8888888 Engineer abcd admin
XYZ IJK MMM consultant 0
SSUSER MMD ADS 1
Any help is greatly appreciated.
Regards,
Swaroopa
Bookmarks