Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
maxgro
MVP
MVP

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

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

)

View solution in original post

3 Replies
fernando_tonial
Partner - Specialist
Partner - Specialist

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

Don't Worry, be Qlik.
Not applicable
Author

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

maxgro
MVP
MVP

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

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

)