is there a way

[Richard Kreiss]

A client gets csv files with the name format xxxxx_clean.csv.

Xxxxx can be from 2 or more letters long.  I would love to use xlate(fn,_
clean,"").  But this would remove all instances of those letters.

Short of hashing the field holding this name until getting to _ and then
using file_name=mid(fn,"1","ct-"1") to get just the name portion, is there
an easier way?


Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net