In case anyone is interested, we used the functions right/left/mid.
We can go right 87 characters to the end of the area we expect, we could do the same thing using left.
Ultimately we used mid:
nProjId=mid(sTemp, 87, 7)
nProjId is the number we need.
sTemp holds the string we expect to get back.
we go in 87 characters and then nProjId becomes the 7 characters from there.
Just thought you might want to know.
We can go right 87 characters to the end of the area we expect, we could do the same thing using left.
Ultimately we used mid:
nProjId=mid(sTemp, 87, 7)
nProjId is the number we need.
sTemp holds the string we expect to get back.
we go in 87 characters and then nProjId becomes the 7 characters from there.
Just thought you might want to know.