This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I would like to report in the form of a error messages like:
AG18 - Special Character "&'" found
M14 - Special Character "Line Feed" found
T16 - Special Character "Line Feed" found
(We can't modify the spreadsheet without permission, we're tasked with finding things like this and reporting back)
The only way I can think of doing this is to have a filter for each character and for each column. Since our spreadsheets go to Column AH I can't imagine creating 422 filter tools for each tab. There's got to be a better tool for something like this.
For all my other checks I do a filter tool, send it to a "Report Text" tool which provides the error message and on it goes to a Union, and a render.....
Think TRANSPOSE! If your data is named with column headers, here's an example:
202|2017-12-19|Mark & Gina
You can use a RECORDID tool and get a Row number and then TRANSPOSE the incoming data on ROW (as the key) and all other fields as data. Now your output will be:
2|NAME|Mark & Gina
Now you can use a FORMULA to create a new field via regular expressions to see what weird stuff you found. FILTER on IsNull([STUFF]) and take the False output to see what was found where and in which rows.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.