
I receive an email notification if something failed. I need to be able to parse the text in the email body to individual columns in Sharepoint.
This is the email body format.
Error code: 2
Error Message:
2,ERROR:::ERROR:::Invalid_NPI - COULD NOT PARSE THE FILE : File
Name::2414UHCCommunity5-220803h04567-nocd0000_1326098005.835
I want to parse it into columns in SP like this
| Column Name in SP | Data to Parse |
| Error Code | 2 |
| Error Message | 2,ERROR:::ERROR:::Invalid_NPI - COULD NOT PARSE THE FILE : File Name::2414UHCCommunity5-220803h04567-nocd0000_1326098005.835 |
| Payer Name (Comes from within the Body shown in red) | 2,ERROR:::ERROR:::Invalid_NPI - COULD NOT PARSE THE FILE : File Name::2414UHCCommunity5-220803h04567-nocd0000_1326098005.835 |
| Type of Error | 2,ERROR:::ERROR:::Invalid_NPI - COULD NOT PARSE THE FILE : File Name::2414UHCCommunity5-220803h04567-nocd0000_1326098005.835 |
If the message is always formatted the same, you should be able to parse out most or all of what you want by using a series of split() expressions.
See my example below where I parse out the error code. I used two compose actions for clarity but could have used just one.