Skip to Content
Author's profile photo Former Member

How to Remove all Spaces from a Text

Hi,

I would like to share a way of removing all spaces from a Text.

My text is [Text] = “Rogerio Plank Goulart” and I want to see this as “RogerioPlankGoulart”.

To do so, Replace all spaces (” “) with null (“”), use Replace([Text];” “;””).

You can either prefer to Show each part of the text in a separate line to do so, use Replace([Text];” “;Char(10)). It will show [Text] as

Rogerio

Plank

Goulart

Regards,

Rogerio

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo wang zhanhui
      wang zhanhui

      good

      Author's profile photo Saurabh Sonawane
      Saurabh Sonawane

      nice document

      Author's profile photo Ganesh Kasar
      Ganesh Kasar

      Good One...

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks for your comments!

      Author's profile photo Former Member
      Former Member

      THANK YOU VERY MUCH!!!!!!!

      I spent hours searching for a solution like this.

       

      Ernesto

      Author's profile photo dudekula guruvaiah
      dudekula guruvaiah

      Don't worry use replacestring give your value in first input and second input give take constant double clik on constant give space take one more constant double click on that give empty next you can check test tab level ii will your expected output

      Ex input : Guru vaiah output : Guruvaiah.         It has removed space between Guru and vaiah

      Thanks

      Guru.

      8686863340