How about just using a variable substitute? x=xxxxxx_clean.csv. Then just xlate the variable.<br><br><b><i>Richard Kreiss <rkreiss@gccconsulting.net></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> A client gets csv files with the name format xxxxx_clean.csv.<br><br>Xxxxx can be from 2 or more letters long. I would love to use xlate(fn,_<br>clean,""). But this would remove all instances of those letters.<br><br>Short of hashing the field holding this name until getting to _ and then<br>using file_name=mid(fn,"1","ct-"1") to get just the name portion, is there<br>an easier way?<br><br><br>Richard Kreiss<br>GCC Consulting<br>rkreiss@gccconsulting.net<br> <br><br><br> <br><br><br>_______________________________________________<br>Filepro-list mailing list<br>Filepro-list@lists.celestial.com<br>http://mailman.celestial.com/mailman/listinfo/filepro-list<br></blockquote>How about
just using a variable substitute? x=entire file name(xxxxxx_clean.csv). Then just xlate the variable the way you described above. That should just leave you with the name<br><br>-Ivan<p> 
<hr size=1>Looking for last minute shopping deals? <a href="http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping">
Find them fast with Yahoo! Search.</a>