User part of filename as field

[hopkinsc]

Hi all,

I loop through a load of files in the script and need the beginning of the filename to be a new field so i know which file it has come from.

i.e.

the files i read in are :

BOB125_date

CWSL_date

PLDE22_Date

so what i want is to use everything before the _ as a new field.

Can anyone help?

[marcus_sommer · Accepted solution]

You could use something like this: subfield(filebasename(), '_', 1) as Source.

- Marcus