Extract file name details

[richard24best]

Hi All,

I have a requirement to extract all the file names (only the numbers to identify the user id.

All the files are saved by various users with their user id and date

Example - ABC_12345678_17062024

                 XYZJKHJKH_87654321_16062024

How do i retrieve only the numbers from the above files name as an example shown below and called it as Createdby

12345678_17062024

87654321_16062024

Appreciate your time and support in advance.

Regards,

Richard

[Lisa_P · Accepted solution]

The Subfield function should work ok.

eg Subfield(ID, '_', 2) as CreatedBy

[richard24best]

Thank you Lisa for your quick help, that worked for me 🙂