Forum Discussion

arthastic's avatar
arthastic
Icon for Advocate I rankAdvocate I
9 years ago
Solved

How to remove nonessential characters such as punctuation, numbers, web addresses

Hi! Help me please with removing nonessential characters from text column. I use Replace Values function to remove this characters: = Table.ReplaceValue(#"Removed Columns1",",","",Replacer.Replace...
Need Help
Tips and Tricks
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    Greg_Deckler: Text.Trim only removes characters at the start or at the end of a text.

     

    My suggestion would be to convert the text to a list of characters, remove the unwanted characters and return the result back to a text.

     

    = Text.Combine(List.RemoveItems(Text.ToList("M,,,a.r;;;celB.;e.u.;g"),Text.ToList(",.;")))

     

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

Sean I'm afraid you are mixing up "non-essential" with "non-printable".

This solution will not return "MarcelBeug" from my example. :smileylol:

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

MarcelBeug

Transform tab - Forrmat button - Clean => read the Tooltip! :smileyhappy:

 

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      9 years ago

      MarcelBeug:smileyvery-happy: :smileylol:

      I never said Clean would be a solution!

      Before arthastic accepted your answer as a solution he gave smpoure the heads up as if Trim would be enough!

      So I started preparing my answer before yours was marked as the solution!

      Just wanted to show the Trim can be accessed through the User Interface

      And because Clean is right underneath Trim I decided to include it - thats it - nothing else! :smileylol: :smileylol: :smileylol:

       

      EDIT: The Audio is amazing! :smileylol: