Hi everyone, I need some help with a flow that I have, when a new email is received it splits the body of the email by a ":" and a new row is added into an excel document. The problem I am facing is that sometimes the field value I need to split takes up more than one line and customers may use delimiters which is stuffing up my flow. At the moment, it only brings in one line of data but if it takes up more than one line, it doesnt bring in the rest.
For example:
"Body Corporate records holder:" is the form field
"WALKER BODY CORPORATE MANAGEMENT, 123 ABC STREET SMITHVILLE QLD 4215 Ph: 5555 5555" Is the customers response.
The flow only split "WALKER BODY CORPORATE MANAGEMENT, 123 ABC" and did not split " STREET SMITHVILLE QLD 4215 Ph: 5555 5555" and because there was a ":" after "PH", it split "5555 5555" into the next column of the excel document which totally stuffs it up.
Any ideas on how to fix this would be fantastic.
Thank you.