Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Easy, whats VB Constant for Space?

Posted on 2000-03-27
9
Medium Priority
?
1,532 Views
Last Modified: 2012-05-04
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
Comment
Question by:fredmastro
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 4

Expert Comment

by:ruperts
ID: 2661005
char(32)

Have nice day!

0
 
LVL 4

Expert Comment

by:ruperts
ID: 2661011
ok...

chr(32)

I got carried away in the excitement!
0
 
LVL 2

Author Comment

by:fredmastro
ID: 2661013
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 2

Author Comment

by:fredmastro
ID: 2661018
lol
0
 
LVL 2

Author Comment

by:fredmastro
ID: 2661022
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
 
LVL 4

Accepted Solution

by:
ruperts earned 100 total points
ID: 2661023
ok...

chr(32)

I got carried away in the excitement!
0
 
LVL 2

Author Comment

by:fredmastro
ID: 2661024
maybe there's a trick to using two replace statments? Works fine one of them, I get error with two.
0
 
LVL 2

Author Comment

by:fredmastro
ID: 2661027
Ahh got it thanks

Text=Replace(News("News"),vbCrLf,"<BR>")
      
Text=Replace(Text,chr(32),"&nbsp;")
0
 
LVL 4

Expert Comment

by:ruperts
ID: 2661033
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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question