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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 |