Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,204
Community Members
 
Community Events
165
Community Groups

How to get stiltsoft's Table from CSV macro to recognise commas, not hyphens to as the separator?

Edited

I have attached a CSV file to a Confluence page and then used the Table from CSV macro (as described here) to display the file's contents as a table on the page.  The file has 20 lines.  The table on the page has 20 rows.  So far, so good.  Each line in the CSV file has two values separated by a comma.  Each row in the table on the page has not two columns, but three.  The line in the CSV file that says 2020-11-11, 3.145  is rendered in the table as:

| 2020 | 11 | 11, 3.145 |

It looks like the macro has decided that each line in the CSV file is not one of comma-separated values, but rather of hyphen-separated values.

How can I convince the macro otherwise?

1 answer

1 accepted

Hi @Greg ,

It seems that your file is missing headers:

222222.png

11111.pngTry to add them and preview the result. Besides you'll need headers to create your chart.

Yes, that was it.  Thanks.

If, @Katerina Kovriga _Stiltsoft_ , you have any influence on the contents of the documentation page at https://docs.stiltsoft.com/display/public/TFAC/How+to+use+Table+from+CSV+macro, may I suggest that it include mention of the requirement that a CSV file's top-most line must be a line of headers?

Also, for future readers of this thread, I'll mention here that I had to remove the space after each comma.  So, in the header line, I had to change Date, Value to Date,Value.  In the data lines, I had to change, for example, 2020-11-11, 3.145 to 2020-11-11,3.145.

Thanks for the feedback, I'll pass it to the support team.

We've just never had such issues before: our clients often generate and upload CSV files from SQL databases and big Excel/Google spreadsheets tables, so there are no extra spaces between cell values and there are always column headers (their goal is to filter such tables/create pivots right in Confluence).

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

Marketplace Partner Spotlight: AppLiger

This month the spotlight is on AppLiger. We caught up with Pavel Pavlovsky, CEO and Product Manager, to learn how the company started and what fuels the team's creativity.    Atlassian:...

380 views 0 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you