Hi,

I am stuck and need help. I have a string str which can have variuos
values ex.

str="C7,CR101,CR102,"
str="RF1003"
str="FE12,FE36,"

I need to have str without the comma. I have the code that I have
written and it does not work. Any ideas as to what is missing.

My Code
------------
findComma = Right(str,1)
start = len(str) -1
if findComma = "," then
mystring=Replace(str, findComma, "" , start ,1)
end if

On Nov 18, 12:09*pm, sa <agarwasa2...@xxxxxx> wrote:

> Hi,
>
> I am stuck and need help. I have a string str which can have variuos
> values ex.
>
> str="C7,CR101,CR102,"
> str="RF1003"
> str="FE12,FE36,"
>
> I need to have str without the comma. I have the code that I have
> written and it does not work. *Any ideas as to what is missing.
>
> My Code
> ------------
> findComma = Right(str,1)
> start = len(str) -1
> if findComma = "," then
> * * * * mystring=Replace(str, findComma, "" , start ,1)
> end if

How about ...

if Right(str,1) = "," then str = left(str, len(str) - 1)

Tom Lavedas
***********
http://there.is.no.more/tglbatch/

On Nov 18, 10:44*am, Tom Lavedas <tglba...@xxxxxx> wrote:

> On Nov 18, 12:09*pm, sa <agarwasa2...@xxxxxx> wrote:
>
>
>
>
>

> > Hi,

>

> > I am stuck and need help. I have a string str which can have variuos
> > values ex.

>

> > str="C7,CR101,CR102,"
> > str="RF1003"
> > str="FE12,FE36,"

>

> > I need to have str without the comma. I have the code that I have
> > written and it does not work. *Any ideas as to what is missing.

>

> > My Code
> > ------------
> > findComma = Right(str,1)
> > start = len(str) -1
> > if findComma = "," then
> > * * * * mystring=Replace(str, findComma, "" , start ,1)
> > end if

>
> How about ...
>
> * if Right(str,1) = "," then str = left(str, len(str) - 1)
>
> Tom Lavedas
> ***********http://there.is.no.more/tglbatch/- Hide quoted text -
>
> - Show quoted text -

Appreciate your help !!! Thanks!

sa wrote:

>
> I am stuck and need help. I have a string str which can have variuos
> values ex.
>
> str="C7,CR101,CR102,"
> str="RF1003"
> str="FE12,FE36,"
>
> I need to have str without the comma. I have the code that I have
> written and it does not work. Any ideas as to what is missing.

With New RegExp
.Pattern = ",$" ' match comma at end of string
For Each str In Array("C7,CR101,CR102,", "RF1003", "FE12,FE36,")
WScript.Echo .Replace(str, "")
Next
End With

--
Introduction to Regular Expressions (Scripting)
<http://msdn.microsoft.com/en-ca/library/6wzad2b2(VS.85).aspx>

--
Steve

We do not see things as they are, we see things as we are.
-Talmudic Saying