Re: get a substring after the last "\" of a string
You need to find the string position using STRSTR.. Joe From: Wagner, Christoph Sent: Wednesday, May 25, 2011 9:59 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: get a substring after the last "\" of a string ** Dear listers, I have a question: How can I get a substring after the last „\“ of a string? Example: What I have: C:\folder1\folder2\folder3\folder4\file1.txt C:\folder1\folder2\folder3\file2.txt C:\folder1\folder2\file3.txt What I want: file1.txt file2.txt file3.txt Anybody an idea? Thanks a lot for your help Regards Christoph _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
AW: get a substring after the last "\" of a string
Hey,
did it :)
thanks a lot
regards
Christoph
-Ursprüngliche Nachricht-
Von: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] Im Auftrag von Misi Mladoniczky
Gesendet: Mittwoch, 25. Mai 2011 16:15
An: arslist@ARSLIST.ORG
Betreff: Re: get a substring after the last "\" of a string
Hi,
I would probably create a guide, but you can loop via execution order just as
well.
Filter execution order 123:
Run If: ('field' LIKE "%\%")
Action 1:
Set-Fields: CURRENT TRANS
field = SUBSTRC($field$, STRSTRC($field$, "\") + 1) Action 2:
Goto 123
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Dear listers,
>
>
>
> I have a question:
>
>
>
> How can I get a substring after the last "\" of a string?
>
>
>
> Example:
>
>
>
> What I have:
>
> C:\folder1\folder2\folder3\folder4\file1.txt
>
> C:\folder1\folder2\folder3\file2.txt
>
> C:\folder1\folder2\file3.txt
>
>
>
> What I want:
>
> file1.txt
>
> file2.txt
>
> file3.txt
>
>
>
> Anybody an idea?
>
>
>
> Thanks a lot for your help
>
>
>
> Regards
>
>
>
> Christoph
>
>
>
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11
www.wwrug.com ARSList: "Where the Answers Are"
Re: get a substring after the last "\" of a string
Hi,
I would probably create a guide, but you can loop via execution order just
as well.
Filter execution order 123:
Run If: ('field' LIKE "%\%")
Action 1:
Set-Fields: CURRENT TRANS
field = SUBSTRC($field$, STRSTRC($field$, "\") + 1)
Action 2:
Goto 123
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Dear listers,
>
>
>
> I have a question:
>
>
>
> How can I get a substring after the last "\" of a string?
>
>
>
> Example:
>
>
>
> What I have:
>
> C:\folder1\folder2\folder3\folder4\file1.txt
>
> C:\folder1\folder2\folder3\file2.txt
>
> C:\folder1\folder2\file3.txt
>
>
>
> What I want:
>
> file1.txt
>
> file2.txt
>
> file3.txt
>
>
>
> Anybody an idea?
>
>
>
> Thanks a lot for your help
>
>
>
> Regards
>
>
>
> Christoph
>
>
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
get a substring after the last "\" of a string
Dear listers, I have a question: How can I get a substring after the last "\" of a string? Example: What I have: C:\folder1\folder2\folder3\folder4\file1.txt C:\folder1\folder2\folder3\file2.txt C:\folder1\folder2\file3.txt What I want: file1.txt file2.txt file3.txt Anybody an idea? Thanks a lot for your help Regards Christoph ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
