Split date from one column into 3 separate columns

[#1]

Hello,

I am trying to split data from one column into 3 separate columns. My data is being loaded from an Oracle database. Following is my script example:

SQL SELECT "column" FROM LOG.TABLE

The data in the column are of the following format:

abc/123/textdescription

How can I separate this into 3 different columns in QV?

Please help.

Thank you in advance.

[jonathandienst · Accepted solution]

Hi

This will do it:

LOAD [column],

          SubField([column], '/', 1) As Field1,

          SubField([column], '/', 2) As Field2,

          SubField([column], '/', 3) As Field3

;

SQL SELECT [column] FROM LOG.TABLE

Hope that helps

Jonathan

[#3]

Thank you. It works perfectly.

Can you also, tell me how to just reload only the current changes that I made in the script and not the entire script?

[jonathandienst]

Hi

It is possible, but how depends on the details of your script. Essentially you use a partial load with ADD and REPLACE load qualifiers. Search here for partial load, or check out the manual.

Regards

Jonathan