Search notes:

VBA function: join

join(arrayVariable, joinString) creates a string from the values of the elements in an array by inserting joinString between the element values.

Thus, it behaves quite the same as Perl's join function.

option explicit

sub main() ' {

    dim ary(1 to 3) as string

    ary(1) = "foo"
    ary(2) = "bar"
    ary(3) = "baz"

    dim txt as string
    txt = join(ary, " - ")

    debug.print txt

end sub ' }

Github repository about-VBA, path: /functions/join.bas

The opposite of join is split

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1788522940, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/languages/VBA/functions/join/index(62): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

VBA function: join

See also