Forum Discussion
Text.Trim over entire table
Hi there, Does anyone know how to use Text.Trim over an entire table of data? I have many fields which each have a leading and trailing apostrophe, which I want to remove. Regards, Will
I would look at the Table.TransformColumns and use your Text.Trim within that function as a transform operation.
Greg_Deckler
Community Champion
Community ChampionI would look at the Table.TransformColumns and use your Text.Trim within that function as a transform operation.