The "Select to File" activity exports the data for each row into an Excel file. However, if one of the rows of the driving query contains an "&" symbol, the automation fails when that row is processed. The following error appears:
'AutomationNotWorking.log: File_1 - '"' is an unexpected token. The expected token is ';'. Line 27, position 22.'
