Remove the space in a string…


Last week I was searching a way to suppress spaces in a string. I thought about the trim function… but it doesn’t do the magic.
After several minutes of thinking with the web I found a simple way…
The conclusion is : we become stupid, we can’t think first, we’re going on the web…

Dim x as string
x=”1  2   2 3  4 5″
‘*** Packed x without spaces !
x = replace(x, ” “, “”)

Advertisements

About pierrekoerber
Hey, pour faire connaissance, laisse-moi un message... drop me a line.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: