@DaveR
You bet. So, check out this blog where I go into more detail on Split. The main thing with any kind of string/text manipulation is that the inputs need to be consistent, right? Looking at your example:
lp-form/ Keywords: Email address daverndn@gmail.comNamedaveCompanytestPhone Number54249448178CountryBrazil
State / ProvincePage
We have an opportunity to isolate the email address by breaking the text first at 'Name' and then again at 'address '. With Split, you can identify a delimiter, and it will break that string of text into an Array. Since Arrays have 'elements', you can indicate which element you are interested in using an integer (keeping in mind that they start at zero).
Using my example above (where I didn't know the stuff before the email address), you would end up with two elements in the array:
lp-form/ Keywords: Email address daverndn@gmail.com would be the first one ([0]) and
daveCompanytestPhone Number54249448178CountryBrazil State / ProvincePage would be [1].
My original expression had the [0] at the end, so we will only be working with the part that starts with 'Ip-form/'.
We can further break that down using the same technique either in a follow up Compose, or by wrapping our new expression around the first one, like this (new parts are in bold):
Split(split(outputs('SampleData'),'Name')[0],'address ')[1]
(note the space after 'address' is included in the delimiter). That should break things down so the final array is:
lp-form/ Keywords: Email is the first element [0]
daverndn@gmail.com is the second element [1] (that's the one we want) Notice that your delimiter ('address ') isn't in either.
Kep us posted.
-Ed-
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
