I am creating a database of records from notes I originally kept in Evernote. I exported them to HTML files, then converted the HTML files to TXT files. What I want to do is import these into Tap Forms so that each file becomes a record, and each line becomes a field.
I tried to convert the TXT files into tab-separated TSV files (converting lines to tabs using TextWrangler), then merging them all into one file, but the merge method I used in Apple Terminal just gave me one continuous block of tabbed information, without any way to separate each record.
Any suggestions?
Hi Dave,
You need to make sure that each record is separated by a linefeed. The tabs will separate the fields, but the linefeeds will separate the records.
Then you’ll be able to import the file into Tap Forms.
Any ideas on how to convert a folder full of text files to a single CSV file where each file is separated by a linefeed?
A bit of Googling turned up this command you should paste into a Terminal window:
for f in *.txt; do (cat "${f}";) >> finalfile.txt; done
If you’ve got CSV files, replace txt with csv.
I tested it and it turned 3 files I had into one file with a line break in between each file.
Great! I actually found a similar script, but it worked. One more quick question… if I import a field that contains number values from 1 to 10, can I import that data into a Ratings field?
Yes, you can. A Rating field is no different than a regular Number field except in the way it displays the data. The rating values are stored as numbers and not as stars.
.
