Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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 & Luminary
MVP & Luminary

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

MVP & Luminary
MVP & Luminary

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.