Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=left('Call P7|Campaign 01|2014|07|(co:Thomas delta)',
Index('Call P7|Campaign 01|2014|07|(co:Thomas delta)', '|', 4)
)
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
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
=left('Call P7|Campaign 01|2014|07|(co:Thomas delta)',
Index('Call P7|Campaign 01|2014|07|(co:Thomas delta)', '|', 4)
)