Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
QSense
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
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
Highlighted
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

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.

Community Browser