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"