I am running a query list to pick up an email , it is stored in a collection. I found if i tried using it in an email it failed. Having looked at the collection with log to history it produces [firstname.lastname@example.org]. The  are the issue. I found that if i use For each and set the output value to a variable (person) then it works. However if the field i am looking at in the first place has the option of multiple people then the collection output is [[email@example.com]]. So the option i used prior does not work as it only strips the first .
Soooo I then used a "get from collection" creating a new collection that now only has [firstname.lastname@example.org] which i can use in my For Each.
This works (took me many hours of fiddle) however there is no need for the for each loop beyond stripping the . There must be an easier way to strip the  or [] from my initial collection.
I suspect it may be a regular expression but have no idea how.
Solved! Go to Solution.
The regular expression would look like this:
It looks for any letter, number full stop and @ and ignores them which only leaves [ ] which are replaced with spaces.
Thank you. This worked, the (replace substring). I think i would rather replace string as it would be one step meaning I will stay under the limit of steps more often , however this saves a great deal of faf.