is there a way

[ivan]

How about just using a variable substitute? x=xxxxxx_clean.csv.  Then just xlate the variable.

Richard Kreiss <rkreiss at gccconsulting.net> wrote: 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
  


 


_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list
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

-Ivan
       
---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20080111/bee7bc42/attachment.html