U
ulfb
Hi
I am exporting mail bodies from Outlook into column B in an xls sheet
First four rows in each cell look like example below. Length of these rows
vary.
What I need is a macro that can loop throu rows and:
- copy text "Username: ......." to col C
- copy text "Error in: ......." to col D
- copy text "Error message: .." to col E
Only text after : would be perfect, but not neccesary
(column B will be deleted when copying is completed)
My programming "skills" are limited - any help would be highly appreciated
Thank you!
Ulf
-----------------------------------
Error Caught in Application_Error event
Username: 01234asdfg
Error in: https://www.xxxxxxx.com/Main/Event/reg.item.aspx?ItemId=12345
Error Message: Invalid length for a Base-64 char array.
Stack Trace: at System.Convert.FromBase64String(String s)
at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString)
at
System.Web.UI.ObjectStateFormatter.System.Web.UI.IStateFormatter.Deserialize(String serializedState)
at System.Web.UI.Util.DeserializeWithAssert(IStateFormatter formatter,
String serializedState)
at System.Web.UI.HiddenFieldPageStatePersister.Load()
TargetSite: Byte[] FromBase64String(System.String)
I am exporting mail bodies from Outlook into column B in an xls sheet
First four rows in each cell look like example below. Length of these rows
vary.
What I need is a macro that can loop throu rows and:
- copy text "Username: ......." to col C
- copy text "Error in: ......." to col D
- copy text "Error message: .." to col E
Only text after : would be perfect, but not neccesary
(column B will be deleted when copying is completed)
My programming "skills" are limited - any help would be highly appreciated
Thank you!
Ulf
-----------------------------------
Error Caught in Application_Error event
Username: 01234asdfg
Error in: https://www.xxxxxxx.com/Main/Event/reg.item.aspx?ItemId=12345
Error Message: Invalid length for a Base-64 char array.
Stack Trace: at System.Convert.FromBase64String(String s)
at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString)
at
System.Web.UI.ObjectStateFormatter.System.Web.UI.IStateFormatter.Deserialize(String serializedState)
at System.Web.UI.Util.DeserializeWithAssert(IStateFormatter formatter,
String serializedState)
at System.Web.UI.HiddenFieldPageStatePersister.Load()
TargetSite: Byte[] FromBase64String(System.String)