Hi,

You can do it quite easily. Just increment through the array and don't add the item if there is no check.

To see what I mean, consider copying your array to another array:

j = 0
For i = 1 to firstarraycount

if firstarray(i) <> "" then
secondarray(j) = firstarray(i)
j = j+1
end if

next i

Actually, you might want to use a Trim statement to remove all padded spaces from firstarray(i).

Then try doing it without needing to use the second array.



But on a practical note, I wouldn't do this at all. If you were to then read the text file back in without the delimiting spaces, you won't know how to match the data with the fields, i.e.

Bob Jones, 121 Fluff St, Ann Arbor, , US

gives:

Name: Bob Jones
Street: 121 Fluff St
City: Ann Arbor
State:
Country: US

whereas

Bob Jones, 121 Fluff St, Ann Arbor, US

gives:

Name: Bob Jones
Street: 121 Fluff St
City: Ann Arbor
State: US
Country:


HTH

zaza