Knowledge Drop

Why is Looker adding apostrophes to my data in CSV downloads?

  • 15 June 2021
  • 0 replies
  • 251 views

Userlevel 5

Last tested: Oct 25, 2018
 

Check the General Settings Page for the Block Formulas and Macros in CSV Files toggle.

If fields start with the following special characters, then this feature will snap into action!

=, -, +, or @

 

>When this is enabled, Looker will add a 'character to any cell value that begins with a special character (=-+, or @) when generating a CSV file. This disables all macros in Looker-generated CSV files.

https://docs.looker.com/admin-options/tutorials/managing-bizusers/bizuser-features#preventing_injection_of_malicious_code_into_csv_files

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply