Remove data from payload

[KerwinBradshaw]

Hi there,

I am new to Pabbly, so forgive me if this question has already been answered (could not find).
When I perform a call and want to insert data into an app I get the following;

"{{First Name}}<textarea id=""BFI_DATA"" style=""width: 1px; height: 1px; display: none;""></textarea>
<div id=""WidgetFloaterPanels"" class=""LTRStyle"" style=""display: none; text-align: left; direction: ltr; visibility: hidden;"" translate=""no"">
<div id=""WidgetFloater"" style=""display: none;"">
<div id=""WidgetLogoPanel""><span id=""WidgetTranslateWithSpan"">TRANSLATE with <img id=""FloaterLogo"" /></span> <span id=""WidgetCloseButton"" title=""Exit Translation"">x</span></div>
<div id=""LanguageMenuPanel"">
<div class=""DDStyle_outer""><input id=""LanguageMenu_svid"" style=""display: none;"" autocomplete=""on"" name=""LanguageMenu_svid"" type=""text"" value=""en"" /> <input id=""LanguageMenu_textid"" style=""display: none;"" autocomplete=""on"" name=""LanguageMenu_textid"" type=""text"" /> <span id=""__LanguageMenu_header"" class=""DDStyle"" tabindex=""0"">English</span>
<div style=""position: relative; text-align: left; left: 0;"">
<div style=""position: absolute; ;left: 0px;"">
<div id=""__LanguageMenu_popup"" class=""DDStyle"" style=""display: none;"">
<table id=""LanguageMenu"" border=""0"">
<tbody>
<tr>
<td><a tabindex=""-1"" href=""#ar"">Arabic</a></td>
<td><a tabindex=""-1"" href=""#he"">Hebrew</a></td>
<td><a tabindex=""-1"" href=""#pl"">Polish</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#bg"">Bulgarian</a></td>
<td><a tabindex=""-1"" href=""#hi"">Hindi</a></td>
<td><a tabindex=""-1"" href=""#pt"">Portuguese</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#ca"">Catalan</a></td>
<td><a tabindex=""-1"" href=""#mww"">Hmong Daw</a></td>
<td><a tabindex=""-1"" href=""#ro"">Romanian</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#zh-CHS"">Chinese Simplified</a></td>
<td><a tabindex=""-1"" href=""#hu"">Hungarian</a></td>
<td><a tabindex=""-1"" href=""#ru"">Russian</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#zh-CHT"">Chinese Traditional</a></td>
<td><a tabindex=""-1"" href=""#id"">Indonesian</a></td>
<td><a tabindex=""-1"" href=""#sk"">Slovak</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#cs"">Czech</a></td>
<td><a tabindex=""-1"" href=""#it"">Italian</a></td>
<td><a tabindex=""-1"" href=""#sl"">Slovenian</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#da"">Danish</a></td>
<td><a tabindex=""-1"" href=""#ja"">Japanese</a></td>
<td><a tabindex=""-1"" href=""#es"">Spanish</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#nl"">Dutch</a></td>
<td><a tabindex=""-1"" href=""#tlh"">Klingon</a></td>
<td><a tabindex=""-1"" href=""#sv"">Swedish</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#en"">English</a></td>
<td><a tabindex=""-1"" href=""#ko"">Korean</a></td>
<td><a tabindex=""-1"" href=""#th"">Thai</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#et"">Estonian</a></td>
<td><a tabindex=""-1"" href=""#lv"">Latvian</a></td>
<td><a tabindex=""-1"" href=""#tr"">Turkish</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#fi"">Finnish</a></td>
<td><a tabindex=""-1"" href=""#lt"">Lithuanian</a></td>
<td><a tabindex=""-1"" href=""#uk"">Ukrainian</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#fr"">French</a></td>
<td><a tabindex=""-1"" href=""#ms"">Malay</a></td>
<td><a tabindex=""-1"" href=""#ur"">Urdu</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#de"">German</a></td>
<td><a tabindex=""-1"" href=""#mt"">Maltese</a></td>
<td><a tabindex=""-1"" href=""#vi"">Vietnamese</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#el"">Greek</a></td>
<td><a tabindex=""-1"" href=""#no"">Norwegian</a></td>
<td><a tabindex=""-1"" href=""#cy"">Welsh</a></td>
</tr>
<tr>
<td><a tabindex=""-1"" href=""#ht"">Haitian Creole</a></td>
<td><a tabindex=""-1"" href=""#fa"">Persian</a></td>
<td> </td>
</tr>
</tbody>
</table>
<img style=""height: 7px; width: 17px; border-width: 0px; left: 20px;"" alt="""" /></div>
</div>
</div>
</div>
</div>
<div id=""CTFLinksPanel""><span id=""ExternalLinksPanel""><a id=""HelpLink"" title=""Help"" href=""https://go.microsoft.com/?linkid=9722454"" target=""_blank"" rel=""noopener""> <img id=""HelpImg"" /></a> <a id=""EmbedLink"" title=""Get this widget for your own site""></a> <img id=""EmbedImg"" /> <a id=""ShareLink"" title=""Share translated page with friends""></a> <img id=""ShareImg"" /> </span></div>
<div id=""FloaterProgressBar""> </div>
</div>
<div id=""WidgetFloaterCollapsed"" style=""display: none;"">TRANSLATE with <img id=""CollapsedLogoImg"" /></div>
<div id=""FloaterSharePanel"" style=""display: none;"">
<div id=""ShareTextDiv""><span id=""ShareTextSpan""> COPY THE URL BELOW </span></div>
<div id=""ShareTextboxDiv""><input id=""ShareTextbox"" name=""ShareTextbox"" readonly=""readonly"" type=""text"" /> <!--a id=""TwitterLink"" title=""Share on Twitter""> <img id=""TwitterImg"" /></a> <a-- id=""FacebookLink"" title=""Share on Facebook""> <img id=""FacebookImg"" /></a--> <a id=""EmailLink"" title=""Email this translation""></a> <img id=""EmailImg"" /></div>
<div id=""ShareFooter""><span id=""ShareHelpSpan""><a id=""ShareHelpLink""></a> <img id=""ShareHelpImg"" /></span> <span id=""ShareBackSpan""><a id=""ShareBack"" title=""Back To Translation""></a> Back</span></div>
<input id=""EmailSubject"" name=""EmailSubject"" type=""hidden"" value=""Check out this page in {0} translated from {1}"" /> <input id=""EmailBody"" name=""EmailBody"" type=""hidden"" value=""Translated: {0}%0d%0aOriginal: {1}%0d%0a%0d%0aAutomatic translation powered by Microsoft® Translator%0d%0ahttp://www.bing.com/translator?ref=MSTWidget"" /> <input id=""ShareHelpText"" type=""hidden"" value=""This link allows visitors to launch this page and automatically translate it to {0}."" /></div>
<div id=""FloaterEmbed"" style=""display: none;"">
<div id=""EmbedTextDiv""><span id=""EmbedTextSpan"">EMBED THE SNIPPET BELOW IN YOUR SITE</span> <a id=""EmbedHelpLink"" title=""Copy this code and place it into your HTML.""></a> <img id=""EmbedHelpImg"" /></div>
<div id=""EmbedTextboxDiv""><input id=""EmbedSnippetTextBox"" name=""EmbedSnippetTextBox"" readonly=""readonly"" type=""text"" value=""<div id='MicrosoftTranslatorWidget' class='Dark' style='color:white;background-color:#555555'></div><script type='text/javascript'>setTimeout(function(){var s=document.createElement('script');s.type='text/javascript';s.charset='UTF-8';s.src=((location && location.href && location.href.indexOf('https') == 0)?'https://ssl.microsofttranslator.com':'http://www.microsofttranslator.com')+'/ajax/v3/WidgetV3.ashx?siteData=ueOIGRSKkd965FeEGM5JtQ**&ctf=true&ui=true&settings=manual&from=en';var p=document.getElementsByTagName('head')[0]||document.documentElement;p.insertBefore(s,p.firstChild); },0);</script>"" /></div>
<div id=""EmbedNoticeDiv""><span id=""EmbedNoticeSpan"">Enable collaborative features and customize widget: <a href=""http://www.bing.com/widget/translator"" target=""_blank"" rel=""noopener"">Bing Webmaster Portal</a></span></div>
<div id=""EmbedFooterDiv""><span id=""EmbedBackSpan""><a title=""Back To Translation"">Back</a></span></div>
</div>
</div>"

Question: How do I remove the css data following the {{xxxx}} data so that I get the clean data without the css/html?

Thank you all in advance,
Kerwin Bradshaw

 

[Supreme]

Hey @KerwinBradshaw

How do I remove the css data following the {{xxxx}} data so that I get the clean data without the css/html?

You can use the Text Formatter action step in your wokrlfow to strip the HTML content from the given data.

Kindly try this on your end and let us know if that works for you.

 

[KerwinBradshaw]

Hi Supreme,
Thanx for the quick response!
I will try this and let you know.

Kind regard

 

[KerwinBradshaw]

Hi Supreme,

This works. It seems that I have to remove the tag for every data field. Is there a "bulk" way to do this?

Thank you!

 

[Supreme]

Hey @KerwinBradshaw

You need to use the Text Formatter action step separately, as you cannot use it in bulk.