Link to home
Start Free TrialLog in
Avatar of JaysonJackson
JaysonJacksonFlag for United States of America

asked on

convert TXT from list to Column csv/xls

I have a txt file that is in a list form. (below and attached List.txt) I would like to convert this to a spread sheet that has the columns  and the data filled in (attached column.txt).  any help is appreciated


List data


FirstName            : Test
LastName             : account
Email                : taccount@xyz.com
SamAccountName       : taccount
PasswordNeverExpires : True
ProfilePath          :
LogonScript          : users.bat
HomeDirectory        : \\profiles\$data\taccount
PasswordLastSet      : 6/23/2011 2:27:15 PM
LastLogonTimestamp   : 5/19/2012 7:33:45 AM


FirstName            : Test1
LastName             : account
Email                : t1account@xyz.com
SamAccountName       : t1account
PasswordNeverExpires : True
ProfilePath          :
LogonScript          : users.bat
HomeDirectory        : \\profiles\$data\t1account
PasswordLastSet      : 6/23/2011 2:27:15 PM
LastLogonTimestamp   : 5/19/2012 7:33:45 AM



Column data
FirstName      LastName      Email      SamAccountName      PasswordNeverExpires      ProfilePath      LogonScript      HomeDirectroy      PasswordLastSet      LastLogonTimeStamp
Test      account      taccount@xyz.com      taccount      TRUE            Users.bat      \\profies\$data\taccount      6/23/2011 14:27       5/19/2012 7:33:45 AM
Test1      account      t1account@xyz.com      t1account      TRUE            Users.bat      \\profies\$data\1taccount      6/23/2011 14:27       5/19/2012 7:33:45 AM
list.txt
column.txt
ASKER CERTIFIED SOLUTION
Avatar of oBdA
oBdA

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of JaysonJackson

ASKER

thanks you made this look so simple..
Avatar of Bill Prew
Bill Prew

@oBdA

Well done!

~bp