Database export unnecessary syntax

Anvil Q&A
1

Hello everyone,

I’m starting recently to manipulate databases and i’m trying to export them in a CVS/Excel format, however, i’m encountering some caracters that are a little bit of an hindrance for my work but I don’t find answers on the wiki.
hindrance

Here’s what it is showing:

(written example if the image isn’t showing: [308479,514055970],“banana”,“apple” )

My goal is to put “banana” in the first column, and next to it the world “apple”, not with number and with brackets

I hope i’m clear enough to be understood,

Thanks in advance!

2

Welcome to the Forum, Adriaan!

By default, a new forum post gives you a framework to fill in. Filling it in gives us the kinds of details we need in order to help you. That is, it helps put your question in context. For example:

We have no idea which “it” you’re referring to. Excel? Some other spreadsheet? Some text editor? Some browser? Some other program? Running where?

Without knowing such circumstances, it is difficult for me to reason about your situation.

If the above display is just a series of lines in a text editor, then you could accomplish that simply by typing in a new line:

banana,apple

So the result would read

ID,"tpr","tps"
[308479,514055970],"qsd","qsd"
[308479,514056834],"conasse","pute"
[308479,514058489],"qsd","qsd"
[308479,514064671],"",""
banana,apple

But then what? Simply having a new line in the text editor’s display doesn’t seem to accomplish much.

I suspect that this is only a step along the way to something bigger. You want to fit this into some bigger picture, but until we know more about that picture, we can only guess as to the methods and constraints that are suitable.

Edit: I’m going to guess that this data was extracted from an Anvil Table, by some method, and that it exists on disk in the form of a CSV-format file. And that you would like to remove the first column (“ID”), in some program, somewhere, before making other changes to the data.

Is my guess correct?

3

Guessing the same. So either delete the column manually of create an export as CSV / df and export that as CSV is probably the right answer, as that way you won’t get the row ids.

EDIT:

This, basically: Exclude "ID" Column from CSV Data Table Export