Avatar of Govinda2020
Govinda2020
Flag for Ireland asked on

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.
SAPCrystal Reports

Avatar of undefined
Last Comment
James0628

8/22/2022 - Mon
Mike McCracken

WHich BO tool/application are you using?

mlmcc
Govinda2020

ASKER
I am using Webi 3.1 with Universe
Mike McCracken

Are there always 2 \'s in the string?

Do you always want the last substring?

mlmcc
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Govinda2020

ASKER
No, it can vary.But, I always need substring after last \
ASKER CERTIFIED SOLUTION
James0628

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Mike McCracken

This is just a shot in the dark.

Replace (YourString;"*/";"")

mlmcc
Govinda2020

ASKER
Thanks for the comment , it was very well explained
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
James0628

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
Mike McCracken

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
Mike McCracken

DOesn't work in BO XI 4

mlmcc
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
James0628

It was worth a shot.  :-)

 James