Imploding an array into a string using VB

Question

I'm extremely unfamiliar with ancient VB, and I'm trying to figure out the proper commands to concatenate an array (I am assuming it is in array form) into a string with comma separated values.

The values are being provided by a multiselect box, which is being assigned to the areas variable, which is grabbed from the areas select box.

dim name
dim from
dim company
dim phone
dim zip
dim message
dim areas

name = Request.Form("name")
from = Request.Form("from")
company = Request.Form("company")
phone = Request.Form("phone")
zip = Request.Form("zip")
areas = Request.Form("areas")
message = Request.Form("message")

I want to take areas, and implode it into a string.

What's the command in very old VB to do this?

VB.NET or VB6? VB.NET is rather new actually. Also, what do you want exactly? Please specify expected result. — Victor Zakharov
– Victor Zakharov, Commented Dec 20, 2013 at 16:30
VB6 I believe. I want to take an array, such as ["item", "item2", "item3", "item4"] and join them into a single string, such as "item, item2, item3, item4" — Steven Matthews
– Steven Matthews, Commented Dec 20, 2013 at 16:32
I am trying to read the Microsoft example on this - I think this is it, but I'm not quite sure of syntax: msdn.microsoft.com/en-us/library/… — Steven Matthews
– Steven Matthews, Commented Dec 20, 2013 at 16:32
You need to know for sure, because there will be different solutions. In VB.NET it's String.Join. — Victor Zakharov
– Victor Zakharov, Commented Dec 20, 2013 at 16:33
This, to me, looks like ASP classic which actually uses vbscript for the coding language. Basically, if you open a browser and type a url with a .asp extension, then my assumption is correct. If my assumption is correct, then areas may already be a comma separated string. — George Mastros
– George Mastros, Commented Dec 20, 2013 at 17:47

FoxHound · Accepted Answer · 2013-12-20 16:49:27Z

3

The Join function does also exist in VB6, the syntax is like this:

myString = Join(myArray, ",")

EDIT: Note that the array goes before the delimiter. The delimiter is optional, it'll be a space if left empty.

edited Dec 20, 2013 at 16:49

answered Dec 20, 2013 at 16:34

FoxHound

4045 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Steven Matthews Over a year ago

I didn't ask how to concatenate. I asked how to implode/join an array of string values into a single string.

user1336827 · Accepted Answer · 2013-12-20 16:37:44Z

0

you want to use the Join function String.Join(",",array)

answered Dec 20, 2013 at 16:37

user1336827

1,8562 gold badges16 silver badges35 bronze badges

Comments

Victor Zakharov · Accepted Answer · 2013-12-20 16:38:56Z

0

If you are using VB6, try this:

Join(New String() {name, from, company}, ", ")

Join Function (Visual Basic) @ MSDN

EDIT: I know it's a link to VB.NET, but it's the old VB6 function call, it should be compatible with VB6, syntax wise.

answered Dec 20, 2013 at 16:38

Victor Zakharov

26.6k18 gold badges95 silver badges158 bronze badges

1 Comment

Victor Zakharov Over a year ago

@jac: Thanks for a link. I think the signatures are identical.

Collectives™ on Stack Overflow

Imploding an array into a string using VB

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related