ProDraw upgrade?
20-Dec-91 15:58:34
Sb: #43963-ProDraw upgrade?
Fm: Malcolm O'Brien 76703,4243
To: Wayne Cole 76370,621
Wayne,
I just checked. On export, all fields are enclosed in quotes and each is
separated by a comma (including one before EOL).
I entered this:
string string
15 +1.00E+15
2.32 0.0008
3.1416 6
the 3.1416 was entered as "=pi()"
..and the exported file looks like this:
"string","string",
"15","+1.00E+15",
"2.32","0.0008",
"3.1416","6",
which is how they appear onscreen. Changing column widths and max decimals
would change the result. (Actually, I still don't have the release version.
These are still referred to as "DBase" in the old copy I'm using.)
On import, no quotes will result in each line being placed into a single
cell on a "Paste CSV" operation. Paste File, OTOH, will start a new cell
for each space or tab (configurable) it encounters. So if you have spaces
in your string fields, you have the choice of delimiting fields by tabs or
ensuring that your strings, at least, are enclosed in quotes.
Paste File ignores quotes (well, they show up as part of the string) in
that it only starts a new cell for a space or tab.
The database functionality is the same sort of list management that's
included in Lotus. There are named criteria ranges, you can AND & OR by
putting things on the same lines or different lines. The database functions
operate on those records which match the specified criteria. And, of
course, you can set a criterion that'll pass all records. And it's all much
faster than Advantage was. It's pretty nifty! And friendly too. Nice for
those jobs that don't require a relational system or files bigger than
available memory.
I think people will really like PCalc and I'm eager to see the reviews. 🙂
Malcolm