search

jokedst / CsvQuery

Plugin for Notepad++ that treats CSV files as (read only) SQL tables
153 stars 28 forks source link

How do I stipulate tab separator in Manual Parse Settings? #21

Closed FarrelBuch closed 4 years ago

FarrelBuch commented 4 years ago

I have a TSV file where the headers are on the 5th line of the text file. The plugin is not parsing correctly. I thought I could help by stipulating that the separator was not a comma. I tried typing the tab key but that just pushes me to "Quote inside text prefix". I tried Alt9 or Alt0009 (I am on Windows 10). Nothing worked. Can you help me?

Love what your plugin does.

jokedst commented 4 years ago

Write \t

On Mon, Feb 3, 2020, 17:17 Farrel Buchinsky notifications@github.com wrote:

I have a TSV file where the headers are on the 5th line of the text file. The plugin is not parsing correctly. I thought I could help by stipulating that the separator was not a comma. I tried typing the tab key but that just pushes me to "Quote inside text prefix". I tried Alt9 or Alt0009 (I am on Windows 10). Nothing worked. Can you help me?

Love what your plugin does.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/jokedst/CsvQuery/issues/21?email_source=notifications&email_token=AAGRR3BCPSZ4GM5RF3PRZS3RBA7Q5A5CNFSM4KPH66OKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4IKUQK2A, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAGRR3FDVDB5474WKFEJTUDRBA7Q5ANCNFSM4KPH66OA .

FarrelBuch commented 4 years ago

Ah yes. Never thought of that. There are a few non-printing symbols such as that.\n is for newline. There are a few escape sequences in programming languages (eg Python, R)

FarrelBuch commented 4 years ago

It worked well. Thank you.