Sunday, 1 December 2019

Convert an array into string and vice versa.

Join function returns a String after joining substrings present in an array.

arr = array("H","e","l","l","o")
strText = join(arr,";")
MsgBox strText


Split function returns an Array after splitting a string with delimiter. e.g ";"
Note : Default delimiter is the space character.

newarr = split(strText,";")
arrUbound =  Ubound(newarr)
For i = 0 to arrUbound
     MsgBox newarr(i)
Next

No comments:

Post a Comment