Extracting varied lengths from middle of string

[Tepzepi]

Hi all,

This is a simple one for the seasoned professionals, I just cannot find the answer in any of the threads.Apologies if it has already been covered.

My report is a file system data report to extract number of log files within a directory. The file name is created by imports from servers across the estate. Severs names are different lengths. Sample file names are:
dbimport_SZARSGROUPIS1.log
dbimport_SAP01.log

All I need is a formula to show the server name for each file, i.e. I need to drop dbimport_ and .log. As you can see, the server names differ in length, with no rules dictating a minimum or maximum length.

Crystal 11

Much obliged in advance

Warren

 

[CR85user]

try: extractstring({Listof.Filenames},'dbimport_','.log')

'J

 

[Tepzepi]

Thanks 'J

Works like a charm of course.

Regards

Warren