Discussion Board for collaboration on QlikView Scripting.
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
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)
Go to Solution.
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.
Title can be trim(Subfield(columnName,'-',2)).
Use the following script at the load time.
Subfield(FieldName,'-',2) as FieldName1
then the FieldName1 will contain the data as you want.