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 nam…

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…

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?

@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.

@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 .

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

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…

[image] Steve_Simon: I can’t get it to do this without inserting commas. 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 i…

This wrapping solution saved me a lot of agony!

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()?

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.

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

Ander August 24, 2019, 2:20am 2

@Steve_Simon

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

Topic		Replies	Views
Remove commas when copying table to clipboard using formula	6	594	November 1, 2023
Comma separated values into different cells	7	2991	June 30, 2020
New Line in FormulaMap	10	3912	March 1, 2022
Create rows from a comma seperated pack formula result Making Packs	3	2024	September 26, 2019
Help me get rid of his commas please 😅	2	690	September 16, 2022

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

Related topics