Function in Business Objects
While there is no function that I know of would it be possible to create variable/function to display just last part of the string after last \. For example the Path (World\Countries\USA).I would need just USA to display in the report.
Last Comment
ASKER
I am using Webi 3.1 with Universe
Are there always 2 \'s in the string?
Do you always want the last substring?
mlmcc
Do you always want the last substring?
mlmcc
ASKER
No, it can vary.But, I always need substring after last \
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
This is just a shot in the dark.
Replace (YourString;"*/";"")
mlmcc
Replace (YourString;"*/";"")
mlmcc
ASKER
Thanks for the comment , it was very well explained
Govinda2020,
You're welcome. Glad I could help.
mlmcc,
FWIW, as far as I can tell, the BO 6.5 Replace doesn't support wildcards. There's no mention of them in the Help. But since you brought it up, I tried * and %, just for the heck of it. No go. Of course it's possible that later versions support them.
James
You're welcome. Glad I could help.
mlmcc,
FWIW, as far as I can tell, the BO 6.5 Replace doesn't support wildcards. There's no mention of them in the Help. But since you brought it up, I tried * and %, just for the heck of it. No go. Of course it's possible that later versions support them.
James
Thanks James. I didn't have a BO install to test against. I didn't expect it to work but thought if it did it would return exactly what was needed.
If I get time I'll test it in BO XI 4
mlmcc
If I get time I'll test it in BO XI 4
mlmcc
DOesn't work in BO XI 4
mlmcc
mlmcc
It was worth a shot. :-)
James
James
Crystal Reports
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
mlmcc