Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
Title can be trim(Subfield(columnName,'-',2)).
Regards,
Kiran.
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
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.