I am using the Email Parser -> Text Formatter -> Text Parser to pull text data from gmails to send to a google sheet.
One of my fields sometimes has apostraphes. When choosing a field from the text parser, I choose a field and the data in that field is displayed. Text with apostraphes is rendered correctly, showing apostraphes, BUT the extracted text has converted the apostraphes to escaped text ( ' ). This escaped text is what is sent to my google sheet.
My first thought was to use the Text Formatter -> Replace Text to fix this, BUT because the apostraphe is rendered correctly when choosing a field to replace text from, my pattern match to fix this will fail because the escaped text isn't present.
So...how do I fix this so the data sent to my google sheet after pulling everything from the email using the email parser will actually show apostraphes instead of escaped text??
One of my fields sometimes has apostraphes. When choosing a field from the text parser, I choose a field and the data in that field is displayed. Text with apostraphes is rendered correctly, showing apostraphes, BUT the extracted text has converted the apostraphes to escaped text ( ' ). This escaped text is what is sent to my google sheet.
My first thought was to use the Text Formatter -> Replace Text to fix this, BUT because the apostraphe is rendered correctly when choosing a field to replace text from, my pattern match to fix this will fail because the escaped text isn't present.
So...how do I fix this so the data sent to my google sheet after pulling everything from the email using the email parser will actually show apostraphes instead of escaped text??