String concatenation problem

[sanders720]

xCompOccurrence.Name = "36570-0101:2XXX"


CompStr = Microsoft.VisualBasic.Left(xCompOccurrence.Name, chp - 1) + (Microsoft.VisualBasic.Right(Str(Q), Len(Q - 1))) + Microsoft.VisualBasic.Right(xCompOccurrence.Name, Len(xCompOccurrence.Name) - chp)

CompStr = "36570-0101: 2XXX"

I am trying to manipulate this data. These variables are being created for comparitive purposes.

About here: + (Microsoft.VisualBasic.Right(Str(Q), Len(Q - 1))) +

A speca is being added. You can see the space after the :. I've tried a few things at the string creation to elliminate the first space after the string conversion without any luck.

Any help with this would be greatly appreciated.

 

[chrissie1]

we really need to know what Q and chp are?

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[chmohan]

Use Trim Function while concatenating

 

[chmohan]

Or use IndexOf to find the position of the space and use the Remove Function