Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Left( to the Nth delimiter

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Left( to the Nth delimiter

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

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

)

3 Replies
fernando_tonial
Valued Contributor

Re: Left( to the Nth delimiter

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

Not applicable

Re: Left( to the Nth delimiter

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

DD

MVP
MVP

Re: Left( to the Nth delimiter

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

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

)

Community Browser