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
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 ""?

Sparky Arbuckle

Try using Trim, Replace would work as well... strRevision.Trim

HTH,
Ben

"Sparky Arbuckle" <> wrote in message
news: oups.com...
>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 ""?
>

Ben

ds.Tables("DataTable").Rows(i)("RevisionString")+= rtrim(ds.tables("DataTable
").rows(i)("RevisionString") & a & ","




"Sparky Arbuckle" <> wrote in message
news: oups.com...
> 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 ""?
>

Clamps

Thanks for the trim suggestions. I copied & pasted Clamps' code sample
and the end result wasn't what I expected.

Before: A 1,A 2,A 3,A 4,A 5,
After: 1,1,2,1,1,2,3,1,1,2,1,1,2,3,4,1,1,2,1,1,2,3,1,1,2, 1,1,2,3,4,5,

Am I doing something wrong here?

Sparky Arbuckle

Based on your original post I would try somthing like...

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

I don't know vb.net soo that code is a guess.

Personally I'd do a standard trim, because your rtrim will only trimming
trailing spaces.

"Sparky Arbuckle" <> wrote in message
news: oups.com...
> Thanks for the trim suggestions. I copied & pasted Clamps' code sample
> and the end result wasn't what I expected.
>
> Before: A 1,A 2,A 3,A 4,A 5,
> After: 1,1,2,1,1,2,3,1,1,2,1,1,2,3,4,1,1,2,1,1,2,3,1,1,2, 1,1,2,3,4,5,
>
> Am I doing something wrong here?
>

Ben

Thanks Ben

Sparky Arbuckle