Alteryx Publish to SharePoint list- Hexadecimal Error

[aehrenwo]

I have a workflow that was working properly until last week. 

The long story short is that is determines new rows to add to a SharePoint list. As of last week it started triggering this error.

Error: SharePoint List Output (3): Error while adding records: '', hexadecimal value 0x1A, is an invalid character.

When I looked at the 11 rows it was trying to add today and I added each one individually it worked fine. 

I am looking at the source data and there is no arrow character that I can see. 

Is there an easy way to remove that type of character from any of the fields at once? 

It tried using a multi-field formula like this but it didn't seem to work. 

REGEX_Replace([_CurrentField_],'_0x1a_', '')

[BrandonB]

Just a thought, but could you try the UrlEncode() function on your strings before they are written out? This encodes a UTF-16 String as a web-legal URL which makes me think it might actually help with this issue as well.