I have little problem with the join function
Join(soucearray, delimiter)
Let's say I have an array of names, but some of the names are null. So I only need the join function to join those are not null. For example:
Name1=
Name2
Name3="Tom"
Name4
Name5="Jack"
When I use
Join(Array(name1, name2, name3, name4, name5), ",")
I need the result to be: Tom,Jack
not: ,,Tom,,Jack
I don't know which name is null and which may have value in it, so I need to include the full list of the name there.
Thanks for the help!
Join(soucearray, delimiter)
Let's say I have an array of names, but some of the names are null. So I only need the join function to join those are not null. For example:
Name1=
Name2
Name3="Tom"
Name4
Name5="Jack"
When I use
Join(Array(name1, name2, name3, name4, name5), ",")
I need the result to be: Tom,Jack
not: ,,Tom,,Jack
I don't know which name is null and which may have value in it, so I need to include the full list of the name there.
Thanks for the help!