Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qliekview
Contributor II

Script-subfield

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)

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Script-subfield

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.

3 Replies
Not applicable

Re: Script-subfield

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

Regards,

Kiran.

nilesh_gangurde
Valued Contributor

Re: Script-subfield

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

Highlighted
MVP
MVP

Re: Script-subfield

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.