I've been searching for a substr method for VBScript. Is there one?
Thanks!

Use Mid$

MID$(string, start, len)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message
...
I've been searching for a substr method for VBScript. Is there one?
Thanks!

VBA and VBS are not the same thing.
Which one are you referring to?
What does your "substr" method do?
What version of Excel do you use?
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


wrote in message
I've been searching for a substr method for VBScript. Is there one?
Thanks!

Hi!
I'm using Excel 2003 - writing a script with VBScript to read in data
from a CSV file.
One of the fields ("Client Name") will be used as the name of a
Worksheet and all the customer's info will be in the worksheet.
The field is free text, and sometimes contains illegal characters (for
Worksheet name) - *?[]\/ - and is sometimes too long.

Replace clientName, "*", "#"
Replace clientName, "\", "|"
Replace clientName, "/", "|"
Replace clientName, "?", "!"
Replace clientName, "[", "{"
Replace clientName, "]", "}"
If Len(clientName) 30 Then
clientName = Substring(clientName, 1, 30)
End If

I don't think these rows work in VBScript...
Thanks for any help,
Mechi


On Jun 4, 3:05*pm, "Jim Cone" wrote:
VBA and VBS are not the same thing.
Which one are you referring to?
What does your "substr" method do?
What version of Excel do you use?
--
Jim Cone
Portland, Oregon *USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

wrote in message

I've been searching for a substr method for VBScript. *Is there one?
Thanks!

If you are using the Visual Basic Editor and not
the Microsoft Script Editor then try...

clientName = Replace(clientName, "*", "#")
clientName = Replace(clientName, "\", "|")
clientName = Replace(clientName, "/", "|")
clientName = Replace(clientName, "?", "!")
clientName = Replace(clientName, "[", "{")
clientName = Replace(clientName, "]", "}")
clientName = Left(clientName, 30)
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




wrote in message
Hi!
I'm using Excel 2003 - writing a script with VBScript to read in data
from a CSV file.
One of the fields ("Client Name") will be used as the name of a
Worksheet and all the customer's info will be in the worksheet.
The field is free text, and sometimes contains illegal characters (for
Worksheet name) - *?[]\/ - and is sometimes too long.

Replace clientName, "*", "#"
Replace clientName, "\", "|"
Replace clientName, "/", "|"
Replace clientName, "?", "!"
Replace clientName, "[", "{"
Replace clientName, "]", "}"
If Len(clientName) 30 Then
clientName = Substring(clientName, 1, 30)
End If

I don't think these rows work in VBScript...
Thanks for any help,
Mechi




On Jun 4, 3:05 pm, "Jim Cone"
wrote:
VBA and VBS are not the same thing.
Which one are you referring to?
What does your "substr" method do?
What version of Excel do you use?
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)





wrote in message
I've been searching for a substr method for VBScript. Is there one?
Thanks!

On Jun 5, 5:31*pm, "Jim Cone" wrote:
If you are using the Visual Basic Editor and not
the Microsoft Script Editor then try...

*clientName = Replace(clientName, "*", "#")
*clientName = Replace(clientName, "\", "|")
*clientName = Replace(clientName, "/", "|")
*clientName = Replace(clientName, "?", "!")
*clientName = Replace(clientName, "[", "{")
*clientName = Replace(clientName, "]", "}")
*clientName = Left(clientName, 30)
--
Jim Cone
Portland, Oregon *USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


wrote in message
Hi!
I'm using Excel 2003 - writing a script with VBScript to read in data
from a CSV file.
One of the fields ("Client Name") will be used as the name of a
Worksheet and all the customer's info will be in the worksheet.
The field is free text, and sometimes contains illegal characters (for
Worksheet name) - *?[]\/ - and is sometimes too long.

Replace clientName, "*", "#"
Replace clientName, "\", "|"
Replace clientName, "/", "|"
Replace clientName, "?", "!"
Replace clientName, "[", "{"
Replace clientName, "]", "}"
If Len(clientName) 30 Then
clientName = Substring(clientName, 1, 30)
End If

I don't think these rows work in VBScript...
Thanks for any help,
Mechi

On Jun 4, 3:05 pm, "Jim Cone"



wrote:
VBA and VBS are not the same thing.
Which one are you referring to?
What does your "substr" method do?
What version of Excel do you use?
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
wrote in message
I've been searching for a substr method for VBScript. Is there one?
Thanks!- Hide quoted text -

- Show quoted text -

It worked!!!
I'm using VBSedit (free version)
Thanks!