ETL and Data Integration tools - Modern ETL software for everyone

Hi

I'm currently evaluating different ETL tools and I thought I was home when I discovered Visual Importer.

But what I realise is that it lack functionality to extract information out of text fields. The string functions are way to few and the user interface is not helping either.

An example:

I want to extract the creation date in a text field of 255 characters.

First I need to locate the starting position of the tag "Created: "
Then I have to extract the string containing the creation date from the starting point above.
Then finally I have to convert the resulting string into a date field.

In Crystal Reports that's easy:

CDateTime (Mid ({log.comment},InStrRev ({log.comment},'Created: ' )+21,19))

But I do not want to do this in Crystal since this information first has to be merged together with other data before I run the report.

Can you do it in Visual Importer?


Regards,
Christofer
Project Manager

Yes, it can be done.

There is entire chapter in the documentation dedicated to scripting language.

(chapter 16 page 112)

If you are still struggling to achieve what you want let us know here and publish working example for you

John