How can I take every cell from a column in a table, and output it to text, without commas inserted

1

I’ve got a table, where each row is a new line of text. I want to output a block of text below the table that puts each row of that table on a new line.

So the following table:
Annotation%202019-08-23%20155701

Has a block of text below that automatically generates and looks like:
Hello
My name is Steve
Goodbye

I can’t get it to do this without inserting commas. I’ve been trying something along the lines of:
(=FormulaMap([Table1],concatenate(Column 1,character(10)))

2

@Steve_Simon

Read through this thread (all the way to the end): New Line in FormulaMap

3

Could you be a bit more specific about what solution you’re pointing to? All the solutions still seem to have commas inserted.

Is it possible to do what I’m asking?

4

@Steve_Simon

I suppose I could have been more clear about that! :crazy_face:

I think it’s still not possible to do what you’re asking. That forum thread covers the issues involved, and mentions some workarounds.

5

@Steve_Simon maybe I am simplyfying this or not getting what are you looking for but would this work?

ListCombine([Table 1].[Column 1]).RegexReplace(",",Character(10) )

It won’t work if you have commas in the text in your rows .

6

Yeah, unfortunately I do have commas in the text in the rows… thanks for the potential solution though!

7

FormulaMap([Table 2].[Column 1], List(CurrentValue, “88”)).ListCombine().RegexReplace(", 88,",Character(10) ).RegexReplace(", 88","" )

First insert a random identifier then replace it :slight_smile:

I am sure there is a nicer way to do this but I am on my first cup of coffee…

8

I had the same problem. I found that wrapping my entire formula within Concatenate() did the trick!

So something like:

Concatenate(

       the().rest().of.my.formula()

)

gives me a flattened string without commas in Coda.

Then if I want to have linebreaks between each value in my formula, I had to get a bit hackier with the formula, combining FormulaMap with Concatenate

Concatenate(

    the().rest().of.my.formula()

        ## using FormulaMap + Concatenate to add a new line after each element in the list
        .FormulaMap(
            Concatenate(
                CurrentValue.ToText(),  
                LineBreak()
            )
        )

)
9

This wrapping solution saved me a lot of agony!

10

I just ran into this old thread, but I am sure (new) users run into this type of situation. And about getting rid of the commas, you want to loose the commas that are inserted by Coda, but keep the commas that might be in a single row-field.

The formula is really straightforward:

concatenate(Table.Name.join(" ")) for a solution without linebreaks, or
concatenate(Table.Name.join(linebreak()) with a linebreak

11

Great pickup, coming back to this thread and posting the solution.

I have found that omitting the concatenate() appears to give the same result.

Are there reason/s where one would want to (or need to) wrap in concatenate()?

12

It is a habit to wrap things in concatenate to ‘flatten’ coda ‘objects’ to text. Frequently, you are not using just this result by itself, but it’s combined with other data.

In this sample the concatenate() was indeed not necessary. And join() already flattens objects to text too.