topic Re: Left( to the Nth delimiter in QlikView

Left( to the Nth delimiter

Thu, 10 Jul 2014 16:19:34 GMT

I need a scripting solution to pull, from the left, to the 4th Bar and to the left.

Start: Call P7|Campaign 01|2014|07|(co:Thomas delta)

End: Call P7|Campaign 01|2014|07|

Essentially I need to return the text before the 4th | delimiter

Thanks a bunch!

-David

fernando_tonial — Thu, 10 Jul 2014 16:26:15 GMT

Hi, you try this

=Left('Call P7|Campaign 01|2014|07|(co:Thomas delta)',Index('Call P7|Campaign 01|2014|07|(co:Thomas delta)','|',-1))

Best Regards.

Tonial

Thu, 10 Jul 2014 16:37:05 GMT

Hello David.

Also you can try ---> TextBetween('Call P7|Campaign 01|2014|07|(co:Thomas delta)','','(')

if your field contains similar data :

TextBetween(FIELD,'','(') AS Algo;

Regards

maxgro — Thu, 10 Jul 2014 16:37:46 GMT

=left('Call P7|Campaign 01|2014|07|(co:Thomas delta)',

Index('Call P7|Campaign 01|2014|07|(co:Thomas delta)', '|', 4)

)