KNOWLEDGE BASE

No Quick Menu Available for Trimming Double Quotation from All String Fields


Published: 16 Oct 2020
Last Modified Date: 16 Oct 2020

Issue

There is no quick menu in Tableau Prep Builder for trimming double quotation from all string fields.

Environment

  • Tableau Prep Builder

Resolution

Workaround

Use REPLACE() function to trim double quotation of the string fields one by one:

For example
REPLACE(["ID"],'"','')
 

Cause

The ability to trim double quotation marks from all string fields via quick menu is not built into the product currently.
Did this article resolve the issue?