1. Define a separate file in SQLite for each campaign, with the three
columns you need:
CAMPAIGN1
Time number (assuming the values are always numbers; use TEXT if they
contain a mix of letters/numbers)
TagA number
TagB number
CAMPAIGN2
Time
TagA
TagB
Etc.
2. Import each of your text files i
Lorenzo Isella writes:
[...]
if you've no idea where a db can help you and if you don't have time to
investigate this and the possibilities a db offers you my suggestion is:
import your 3 or 5 files into a spreadsheet, add a column for your different
campaign and that's it (time: ~ 1min or less
Dear All,
I am quite new to databases in general and sqlite in particular.
I have a number of data files which are nothing else than text files with a
pretty simple simple structure: there are only 3 columns of integer numbers,
something along these lines
123 1000 199
123 1100 188
125 8
3 matches
Mail list logo