How are you getting the data from Excel? Perhaps you could use Excel's own
methods to evaluate the cell contents? You may still need to do something
for literal text values (e.g. 'NULL'), though.
"Kieran Ashley" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,
Apologies if th
[SQL] Parsing a Calculation from a field
Kieran Ashley wrote:
>
> Some of our data comes in in a format which provides us with extra
> information, but which we currently don't need to use; specifically
> we sometimes receive information in the form of calculations, for
>
Kieran Ashley wrote:
Some of our data comes in in a format which provides us with extra
information, but which we currently don't need to use; specifically
we sometimes receive information in the form of calculations, for
example a column which needs to be transformed to an integer is
initially of
Hi,
Apologies if this is the wrong list for this question, I
hope it’s not.
I’m porting an application to PostgreSQL, and
rewriting a number of transforms used to convert incoming Excel data into a
final Postgres table schema for an application. Most of it’s gone
okay, but there’s
