String Concatenation & Removing Space

Tech-Archive recommends: Fix windows errors by optimizing your registry



I am able to build a string for a product revision and was curious
about removing the space. The only way that I have successfully built
the string was to use:

a = integer
strRevision = string

ds.Tables("DataTable").Rows(i)("RevisionString") += strRevision & a &
","

so if product A had 4 revisions, it would look like:
A 1,A 2,A 3,A 4,

I would like this to look like:

A1,A2,A3,A4,etc...

How would I go about doing this? Would I have to create a function that
will Replace the space with ""?

.



Relevant Pages

  • Re: String Concatenation & Removing Space
    ... Try using Trim, ... HTH, ... >I am able to build a string for a product revision and was curious ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: String Concatenation & Removing Space
    ... > I am able to build a string for a product revision and was curious ... > about removing the space. ... The only way that I have successfully built ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Special Characters
    ... "Christoph Basedau" wrote in message ... > you have to close the string and then concatenate the next substr. ... it by removing' ... Then you have tiny function calls and the popUp-Function gets ...
    (microsoft.public.scripting.jscript)
  • Re: How to fix spaces between last name comma first name
    ... algorithm deals with multiple consecutive spaces, though, removing all but ... Assume neither * neither % initially occur in the string. ... first name without removing spaces between first name and middle ...
    (microsoft.public.access.queries)
  • Re: Database Lookup Functoid Access Connection String
    ... try removing some part of the string I suggested? ... try removing "Persist Security Info=False" or something. ... representing himself and not the company he works for. ...
    (microsoft.public.biztalk.general)