【转帖】if text not nil then

yang686526

if text not nil then...
i know nothing.
what i want to know is: if i have a piece of text that's blank (or is only a space), i want another piece of text to read the same unless the 1st, 2nd, 3rd etc. has a value in which case, i want the last case to be the value used:
eg.
txt1
txt2
(space)
(space)
output:
txt2
or...
txt1
txt2
(space)
txt3
output:
txt3
i know this is simple code that will end up in "custom properties" in a border (yes, i know it's redundant info).
any help is appreciated.
if i had a penny for every bug i've found... day...umm that's a buncha' copper...
dim arr() as string
const txt as string = "txt1,txt2, ,,txt3"
dim i as integer
arr = split(txt, ",")
for i = ubound(arr) to 0 step -1
if trim(arr(i)) <> "" then
exit for
end if
next i
msgbox arr(i)
quick