Mid() Function 1

[demoniac]

Hello. I'm trying to create a form in Outlook at my company (exchange server 5.5, outlook 2000). But I can't seem to use the Mid function for some reason.

I'm not familiar with VBScript so I don't know if I have to do something special to be able to use it, but when I try it just says invalid function or arguement.

Anybody know how to stop this?

 

[FengShui1998]

demoniac,

Can you show us your code and how you are using it?


fengshui_1998

 

[jonscott8]

Post your code. Jon Hawkins

 

[acron]

You cannot use Mid in VBScript as a way of substituting part of a string with different text, like you can in VBA.

Also Mid$ is not supported as VBScript does not have strong Data typing.

A.C.

 

[CodeFish]

Acron,

I don't understand what you mean by the Mid (or Mid$) function "substituting part of a string with different text"

The Mid Function Returns a Variant (String) containing a specified number of characters from a string.

To substituting part of a string with different text you use the Replace Function.

You are correct in that VBScript doesn't Support Mid$ (since all variables in VB Script are Variant in nature)

The Mid Function is the same in VBA and VBScript.



Codefish

 

[acron]

There is a Mid() function which does as you say, but there is also a Mid Statement (only in VB & VBA, but not VBScript) which can be used to assign a new value to part (or all) of a string. Try the following in VB or VBA :

Sub TestMid()
Dim Test As String
Test = "Abcdef"
Mid(Test, 4) = "xyz"
MsgBox Test ' It should display "Abcxyz"
End Sub

A.C.

 

[CodeFish]

acron,

Quite correct - learn something new everyday!

Thus for In VBScript,

To get the same Functionality that the Mid Satement gives, demoniac will have to use a combination of Left and Right Functions. E.g.

Left(Test, 3) & "xyz" & Right(Test, Len(Test) - Len(sReplace) - 3)

Regards,

Codefish