Import CSV: How to set delimiter to tabs?

Problems, tips, hints - all about usage.

Import CSV: How to set delimiter to tabs?

Postby mireiner » Sat Apr 22, 2017 4:50 am

Hi,
how to import a csv file with tab separated values?
Couldn't find any option to set the delimiter to tabs.
mireiner
 
Posts: 2
Joined: Sat Apr 22, 2017 4:47 am

Re: Import CSV: How to set delimiter to tabs?

Postby Googie » Tue Apr 25, 2017 2:20 pm

When you pick CSV format for importing you have a choice of field separator:

Image
Googie
Site Admin
 
Posts: 790
Joined: Wed Jul 27, 2011 8:04 pm

Re: Import CSV: How to set delimiter to tabs?

Postby mireiner » Tue Apr 25, 2017 9:34 pm

Oh - I see - thank you!
I didn't find the 'Field separator' option, because this second page of the 'Import data' dialog doesn't open in full size one my system:

Windows 10 64 bit
Screen resulution 1600x1200

As a new SQLiteStudio user I didn't expect that the dialog doesn't show up in full size. So I also overlooked the scrollbar on the right side of the dialog that shows this.

To show this second page of this 'Import data' dialog always in full size would be a good idea for further updates.

Thank you very much for your help.
mireiner
 
Posts: 2
Joined: Sat Apr 22, 2017 4:47 am

Re: Import CSV: How to set delimiter to tabs?

Postby Googie » Fri Apr 28, 2017 1:51 pm

Different plugins may have different size of their configuration controls. Dialog would be larger than monitor. Scrollbar is necessary.
Googie
Site Admin
 
Posts: 790
Joined: Wed Jul 27, 2011 8:04 pm


Return to Usage

Who is online

Users browsing this forum: No registered users and 2 guests