Convert a string array 2d into a string

[rafael.assis16]

 Good afternoon. I need to convert a string array 2d into a string separating as per the image in the attachment. Can anybody help me?

String 2DString that I need

[altenbach · Accepted solution]

This might work. (FOR loop, index array concatenate string, array to spreadsheet string, trim whitespace)

[mcduff · Accepted solution]

Without loops

 

FYI CA's solution is probably faster, did not check, but it always is. 🙂

mcduff

[rafael.assis16]

Simple solution, I was trying to do something but did not think that way.

[mcduff · Accepted solution]

One more R-G way.

[altenbach]

Be very careful with the other solutions presented. Some might blow up if e.g. one of the elements in the original string contains spaces, linefeeds, etc.). My solution retains all strings verbatim and is thus probably safer.

[Mark_Yedinak]

---

@mcduff wrote:

Without loops

 

FYI CA's solution is probably faster, did not check, but it always is. 🙂

mcduff

---

Without user defined loops. Under the hood those primitives are still looping.

[mcduff]

Last solution had a bug, should be string length minus 3 NOT 3 minus string length

Some might blow up if e.g. one of the elements in the original string contains spaces, linefeeds, etc.).

Spaces should be okay, carriage returns okay, linefeeds okay, BUT the carriage return line feed combo (\r\n) if contained in the original string then you will have some problems.

mcduff