How to get extract specific data in mail's body



Dear Experts,

I have a question regarding how to get the specific data from the mail’s body

by using outlook mail message.
If the error no. is not 0, there will be the error lines which contain error information.

I would like to get the IDOC no. for each line, (Refer attachment)
but it comes with long text with many spaces.

In this case, how can i get the IDOC no. for all line and assign it to variable without containing 0 that lays before it’s no.

Thank you so much for your help.


Hi @Somboon_Olanvech,

Have you try use split?