[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1576
  • Last Modified:

Easy, whats VB Constant for Space?

Easy, whats the VBConstant or equivlent of a space?
Like vbCrLf is for Carriage return–linefeed combination.

Whats the one for a 's p a c e'?
0
fredmastro
Asked:
fredmastro
  • 5
  • 4
1 Solution
 
rupertsCommented:
char(32)

Have nice day!

0
 
rupertsCommented:
ok...

chr(32)

I got carried away in the excitement!
0
 
fredmastroAuthor Commented:
ack I knew that, whats the vb string for that? So I can use the Replace command.

Replace(Text32,????," ")

I tried (Text32,char(32)," ") doesn't like it.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
fredmastroAuthor Commented:
lol
0
 
fredmastroAuthor Commented:
Not sure if it's related but I get a :

Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'Replace'


error now.
That my code.

Text=Replace(News("News"),vbCrLf,"<BR>")

Text=Replace(News("News"),chr(32),"&nbsp;")
0
 
rupertsCommented:
ok...

chr(32)

I got carried away in the excitement!
0
 
fredmastroAuthor Commented:
maybe there's a trick to using two replace statments? Works fine one of them, I get error with two.
0
 
fredmastroAuthor Commented:
Ahh got it thanks

Text=Replace(News("News"),vbCrLf,"<BR>")
      
Text=Replace(Text,chr(32),"&nbsp;")
0
 
rupertsCommented:
ok - a result at last..

(although have you checked that you can pass a NULL value to the replace function?)
.......................................
And finally you can use the asc(character) function to find out any character value but you probally knew that anyway!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now