troubleshooting Question

convert TXT from list to Column csv/xls

Avatar of JaysonJackson
JaysonJacksonFlag for United States of America asked on
Microsoft DOSMicrosoft Excel
3 Comments1 Solution571 ViewsLast Modified:
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
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros