substring

[prabhas277]

Hi experts,

I have text like below

\\kcpl1234\M2_ABC_SHARE\QV_PROJECTS\K-folde\qlikview\10_QVD_generator\qvd_Generator_abcd.qvw

based on above text i want only qvd_Generator_abcd.qvw how to get it?

[hector_munoz]

Hi,

Use SubField() function:

SubField('\\kcpl1234\M2_ABC_SHARE\QV_PROJECTS\K-folde\qlikview\10_QVD_generator\qvd_Generator_abcd.qvw', '\', -1) or

SubField(<field_name>, '\', -1).

Learn more about SubField() at: SubField ‒ QlikView

Regards,

H