topic Re: Script-subfield in QlikView

Script-subfield

QSense — Mon, 27 Aug 2012 07:17:58 GMT

Hello,

I have one column in my table it is about title

it includes name ,department and title so I want to take only title part

for example

John Deep(Information Tecnology Department) - Chief Information Officer) I want to take bold part (title)

For this example AHMET MENNAN MUFTUOGLU (Paz.& Sat.Bsk.(Yurtici) (Yurtici Ticaret Md./Psyi-Ist) - Uzman)

I want to take bold part (title)

For this example MURAT IRDESEL (Pazarlama ve Satis Bsk.(2.Bolge) (Taskent Md./Ps2) - Sef(Ticaret)(Yd)) I want to take bold part (title)

Re: Script-subfield

Mon, 27 Aug 2012 08:38:13 GMT

Title can be trim(Subfield(columnName,'-',2)).

Regards,

Kiran.

Re: Script-subfield

nilesh_gangurde — Mon, 27 Aug 2012 09:24:28 GMT

Hii,

Use the following script at the load time.

Subfield(FieldName,'-',2) as FieldName1

then the FieldName1 will contain the data as you want.

Regards,

Nilesh Gaqngurde

Re: Script-subfield

jagan — Mon, 27 Aug 2012 09:42:51 GMT

Hi,

Please find attached file for solution.

I think in your scenario, SubField() not works good, because in second string (

AHMET MENNAN MUFTUOGLU (Paz.& Sat.Bsk.(Yurtici) (Yurtici Ticaret Md./Psyi-Ist) - Uzman)) you have '-', so you will not get the expected result. Since SubField() splits by the given character ('-').

Hope this helps you.

Regards,

Jagan.