I have CSV Files (saved from Excel) in which the date has "helpfully" been formatted:

01-Apr-18

ie

DD-mmm-YY

I can't see an easy way to import these into EDB.

I can write a procedure to REPLACE the values and then convert them into a date ... but is there an easier way?

Adam


I guess you're using IMPORT in which case unless Tim implemented MMM but forgot to document it - no,

A third party tool (eg Scalabium's import component) would work.

The other bad news is that you'll either have to convert the csv file, have an intermediate table in which the date field is a string or write the whole import yourself.

Wouldn't be a bad idea to ask Tim to implement this anyway.

Roy Lambert

Adam,

<< I have CSV Files (saved from Excel) in which the date has "helpfully" been formatted:

01-Apr-18

ie

DD-mmm-YY

I can't see an easy way to import these into EDB. >>

I can't make any promises because 2.29 is starting to get rather "large" in terms of features, but I will see if I can squeeze it into 2.29.

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> I can't make any promises because 2.29 is starting to get rather "large" in terms of features, but I will see if I
> can squeeze it into 2.29.

Hi Tim,
   Care to tease us with any tit bits?  

Ian

Tim

If you could squeeze it in, that would be brilliant.

As the CSV has dates in the form "-Jan-" and these text segments are unique, I have used a Delphi routine to "find & replace all"

"-Jan-" to "-01-", "-Feb-" to "-02-" etc.

It was not too cumbersome, and worked, but obviously is a bit suspect in case those segments of text occurred anywhere else in the file!

Ian,

<< Care to tease us with any tit bits?  >>

Join performance improvements, replication enhancements, and query performance monitoring are the big ones.  There are also some minor improvements to the migrations and some other miscellaneous fixes.

Tim Young
Elevate Software
www.elevatesoft.com