General Discussion

Hello,

I'm creating a csv template that includes a repeatable section with a condition.

It works fine, except that, for those rows where the condition is not met, it also add a blank line (with ;;;) in the csv.

Basically the code is:

COLUMN1;COLUMN2;COLUMN3
{{#each dataRecord.pages.P.sections.S.rows}}
{{#pf:if pages.SP.sections.SS.answers.Q1.values.[0] ">" "0"}}
{{#with pages.SP.sections.SS.answers}
{{Q1.values.[0]}};
{{Q2.values.[0]}};
{{Q3.values.[0]}};
{{/with}}{{/pf:if}}
{{/each}}

But all in 3 rows to get the correct line breaks:

COLUMN1;COLUMN2;COLUMN3
{{#each dataRecord.pages.P.sections.S.rows}}{{#pf:if pages.SP.sections.SS.answers.Q1.values.[0] ">" "0"}}{{#with pages.SP.sections.SS.answers}{{Q1.values.[0]}};{{Q2.values.[0]}};{{Q3.values.[0]}};{{/with}}{{/pf:if}}
{{/each}}

I have also round it with 

{{#pf:outputFormat "DOCUMENTFORMAT"}}...{{/pf:outputFormat}}

But TrueContext shuts down when trying to open the csv after submission.

Also tried | instead of ;

Any idea on how  to avoid this blank line?

Thanks a lot

#Repeatable Sections

#CSV Template

Hello Alicia,

I just used your example and I am not seeing the blank line that you are seeing. I did tweak the template a little bit to the following (replaced the ; to a , and put your 3 value references on the same line. 

COLUMN1,COLUMN2,COLUMN3
{{#each dataRecord.pages.P.sections.S.rows}}
{{#pf:if pages.SP.sections.SS.answers.Q1.values.[0] ">" "0"}}
{{#with pages.SP.sections.SS.answers}}
{{Q1.values.[0]}},{{Q2.values.[0]}},{{Q3.values.[0]}}
{{/with}}{{/pf:if}}
{{/each}}

My Form submission looks like this and the final CSV output, we would expect to see only 2 rows.

My final CSV looks like:

Hello Ian,

thanks for testing. Very helpful.

I've moved these 3 together {{/with}}{{/pf:if}}{{/each}}. If I open the csv with exel, it looks perfect. 

But, if I open it with note pad I see (as per your example):

COLUMN1,COLUMN2,COLUMN3{{#each dataRecord.pages.P.sections.S.rows}}{{#pf:if pages.SP.sections.SS.answers.Q1.values.[0] ">" "0"}}{{#with pages.SP.sections.SS.answers}}{{Q1.values.[0]}},{{Q2.values.[0]}},{{Q3.values.[0]}}{{/with}}{{/pf:if}}{{/each}}