I have the below code that I am trying to modify to split a subject line into to six columns to view in Excel.
My data is in the below format (please note that this is subject line information only - the body of the email is not required)
SLWP Ottawa | Sales Eng. | 26-Jun-15 | Shift End: 21:00 | Leave Time: entire day | SLWP (Unpaid)
SLWP Brampton | Sales Eng. | 26-Jun-15 | Shift End: 19:00 | Leave Time: entire day | SLWP (Unpaid)
SLWP Ottawa | Sales Eng. | 26-Jun-15 | Shift End: 16:00 | Leave Time: 12:15 | SLWP (Unpaid)
I will like to have it split into the following column headers:
Column A will be - Sender
Column B will be - Location
Column C will be - LOB
Column D will be - Date
Column E will be - Shift End Time
Column F will be - Requested Leave Time
Column G will be - Paid / Unpaid
Any help will be most appreciative.
I also tried to modify the code with the below but still to no avail
Bookmarks