Forum Discussion
Using regex to match a sting in a replace function
Hoping someone can help me with an issue. I have some text that comes from an RSS feed that I post to Yammer using Flow. The source randomly includes text between square brackets. The text is diff...
Hi lfkentwell
RegEx has some limited support in Plumsail and AquaForest PDF connectors, but nothing else that I can see.
Perhaps the easiest workaround is to pass the RSS feed output through Excel Online and use this formula to remove the brackets and text between.
=LEFT(A1,FIND("[",A1)-1)&RIGHT(A1,LEN(A1)-FIND("]",A1)-1)
So basically have the RSS feed output inserted into cell A1 and the formula can be in A2.
The formula then removes the bracketed info and you can retrieve the result of A2 and pass it to Yammer.
A few extra steps but you'll get the result.
Hopefully that gives you something to play with?
Cheers
Damien
EDIT: Forgot to mention, make A1 and A2 into a table as the Excel connector will need to reference it.