Take a part of a string and putting into another string

[Quijian]

Is it possible to take a portion of a string, forinstance and put into in another string or variable? Thanks, I'll take any suggestions.

 

[SkipVought]

Hi

Function InsertInto(s1 As String, s2 As String, p1 As Integer) As String
   InsertInto = Left(s2, Len(s2) - p1 - 1) & s1 & Right(s2, p1 + 1)
End Function

where s1 is the string to insert
s2 is the string to be inserted into
p1 is the position to put s1

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[DrJavaJoe]

Look up the Mid function.

strNewValue = Mid(string, start[, length])


Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.

 

[johnwm]

Also remember the Mid Statement:

Mid(stringvar, start[, length]) = string

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'