Hi @tommyd369 ,
Apparently your expressions were incorrect. I took this text based on your template as example:
And after run 3 of the expressions, the results were all the same:
The expression starts to run from the most internal command, and achieve the external ones at last. In your case, taking the 'Caller Id' as example, you are doing the following:
- Splitting the text by 'Caller ID' (which is an error, as the text that you should capture is 'CallerID', without space) (red)
- Accessing the first element from the generated array, which is everything before the 'Caller ID' substring (and here is one other error: you should be accessing everything after this separator) (blue)
- After taking this first part, you split it again, but now for ":", resulting in a new array (orange)
- Then you generate a new array from its second element to the end(green)
- And finally you return this first element
Expression: first(skip(split(first(split(body('Html_to_text'),'Caller ID')),': '),1))
I wrote a different expression template that may be a little easier to apply. Here is an example of the expression to access the Caller Id: trim(first(split(last(split(body('Html_to_text'), 'CallerID:')), 'First and Last')))
To replicate it to the rest of the elements that you need to extract, just replace the green text for the element that you want to extract, and the red for the first element after it. For example: if you want to return the 'File ID Number', replace the green for 'File ID Number' and the red for 'Additional Information'.
Also, make sure to add the ":" when writing the green text, otherwise your final output will look like this:
This is the output of the flow, when using this expression template:
As a final recommendation, make sure to always include a 'trim' as external expression when you are working with text extraction. It will prevent you to pull extra blank spaces at the beginning or at the end of the extracted text (the trim transforms ' Mailer Inquires ' into 'Mailer Inquires', without the extra spaces at beginning/end).
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/
