Appending a Char to each element in a array

Question

Input in my case is a string with a list of elements separated by Comma

Input:

var input = "123,456,789";

Expected Output (a string):

"'123','456','789'"

I'm looking for a solution in VB.net but i'm not so familiar with it. So, I tried it in c#. Not sure what i'm missing.

My Attempt:

var input = "123,456,789";
var temp = input.Split(new Char[] { ',' });
Array.ForEach(temp, a => a = "'" + a + "'");
Console.WriteLine(String.Join(",",temp));

Actual Output:

"123,456,789"

Any help in funding a solution in vb.net is much appreciated :)

Answer 1

You could use LINQ:

var result = string.Join(",", input.Split(',').Select(x => "'" + x + "'"))

This splits the string at the , delimiter, then adds the quotes around the pieces using Select(), and then reassembles the array using string.Join()

Edit: Here is the equivalent VB.NET solution:

Dim result As String
result = String.Join(",", input.Split(",").Select(Function (x) ("'" & x & "'" )))