Mid not working?

[ironhide1975]

Hey trying to do a simple mid

DividerPos =  Instr(1, FirstName, " ", 1)
Last =        mid(First,DividerPos,50)

and I get this error

Microsoft VBScript runtime error '800a0005' 

Invalid procedure call or argument: 'mid'

 

[monksnake]

I think you are putting the wrong parameters in the Mid function

It needs to be Mid(string, int, int), I believe that the variable First is not a string variable, I tested this and got the same error you did when First was not a string.

<.

 

[ironhide1975]

First is the string variable, I basically want to find the space in the string and break it apart because its a first and last name.

 

[tsuji]

[tt]DividerPos = Instr(1, FirstName, " ", 1)
Last = mid(First[red]Name[/red],DividerPos[red]+1[/red],[blue]len(FirstName)-DividerPos[/blue])
[/tt]
That number is the exact value. The freedom is that it can be larger but not smaller. If no space appears, the whole string is returned. If multiple space, its return the substring after the first.

 

[ironhide1975]

figured it out, sometimes the DividerPos would be 0 and thus produce an error. Sorry for the inconvenience.