Purest Text

Use notepad and save it as plain text

from a computer point of view, 7 bit ASCII is as basic as you can get:

It is binary code used by electronic equipment to handle text using the English alphabet, numbers, and other common symbols. ASCII is an abbreviation for American Standard Code for Information Interchange.[1] ASCII was developed in the 1960s and was based on earlier codes used by telegraph systems.

I have tried that and still had problems uploading the Notepad text into the IOS app.

Many thanks,

M. Cook

Is this what Notepad gives me, 7-bit ASCII?

M.

What program are you using to read it on the Mac?

I'm on Windows.  I am converting a small database into tab separated file to import into an IOS app.  The IOS app is not doing a clean import in the sense that several rows end are under a single heading instead of under their individual heading.

M.

Sorry, my mistake. You really want to create a csv file. You can do that with notepad. See here:
http://www.learningaboutelectronics.com/Articles/How-to-create-a-CSV-file-with-a-plain-text-file.php

What program on iOS are you exporting it to?

perhaps Notepad++ will give you better results:

Notepad++ is a free (as in "free speech" and also as in "free beer") source code editor and Notepad replacement that supports several languages. Running in the MS Windows environment, its use is governed by GPL License.

Also, make sure that you are not using any accented or special characters in your text (refer to the table of ASCII characters at the link https://simple.wikipedia.org/wiki/ASCII)

I have Notepad ++ and the same putting multiple rows under one heading.

I am uploading to the iPhone app "The Vault."

M.

If you've already generated the tab separated valve file you can convert it to csv.
https://www.computerhope.com/issues/ch001776.htm

I suspect the program is interpreting the tab separator as a data field, which is possibly why multiple rows are piling up. See if using the comma instead of the tab works better.

The Vault will accept either a tab or comma separated file.

There's no difference as I have tried both methods.

M.

Odd. I'll continue to ponder this.
Have you asked the software authors support desk?

Yes, The Vault people are responsive, but have no solution.

Just a thought. If you drop the file into Word and select show all characters, that may help to show up what other things the app may be reading. Delete any spaces between values and anything that's not a carriage return.

Will do.

I have always found that using a "DOS" command like TYPE to read a text file and redirect its output to a new text file strips out unrecognised and extraneous characters, for example   TYPE file1.txt>file2.txt.
However, this will not help if you are having an issue with how different operating systems apply the "new line" codes to force new lines.

Most Windows applications use the hexadecimal control codes 0D and 0A most often transcribed as 0x0D and 0x0A (decimal 13 and 10, and with programming escape sequences \r\n).  These codes are referred to as Carriage Return and Line Feed or CR+LF.
Linux based text files only use the Line Feed control code to force a new line.
Old Mac applications use only the Carriage Return code to force a new line.
It is for this reason that a text file created with forced new lines and paragraphs in a Linux or old Mac application will usually open as one continuous block of text in a Windows text reader.  I really have no idea what new line characters are used in IOS applications though, and it is possible that it is the same as Windows and that this possibility therefore has no bearing on your issue at all.

I suppose you may be able to ascertain this by creating a text file in an IOS application, copying it to a Windows PC, and opening it in a hex editor to see whether it contains  0D and 0A at the end of each line or only  0D or 0A.

Reference: https://en.wikipedia.org/wiki/Newline

Thank you.

M. Cook

Try alphabetizer. https://alphabetizer.flap.tv/ and shuffle the settings around. Takes a bit to get use to. Then you can copy the output to notepad ++.