JaysonJackson
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@oBdA
Well done!
~bp
Well done!
~bp
ASKER