Trim the string when you request it from the text area, then place it in your array.
Or you can try this (inside your for loop)
pos = InStr(splitArray(i), " ")
if pos > - 1 then
sSQL = sSQL & "'" & Right(splitArray(i), 10) &"',"
else
sSQL = sSQL & "'" & splitArray(i) &"',"
end if
This method assumes that the space is at the begining of the phone number.
-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
^^Thats my signature
|
