Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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

 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    I would look at the Table.TransformColumns and use your Text.Trim within that function as a transform operation.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    I would look at the Table.TransformColumns and use your Text.Trim within that function as a transform operation.