Script-subfield

[QSense]

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)

[#2]

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

Regards,

Kiran.

[nilesh_gangurde]

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

[jagan · Accepted solution]

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.