Hi,
Part of my process involves me grabbing file data from a folder and adding it to a collection. I'd like to append the collection by adding an additional column to the collection that contains the file name without the extension.
For example, row one would contain just "02" instead of "02.pdf". Any idea how this can be done with an expression? I would just use trim, but the folder may contain 4 letter office extensions like "xlsx".
View attachment file-extensions.png
Part of my process involves me grabbing file data from a folder and adding it to a collection. I'd like to append the collection by adding an additional column to the collection that contains the file name without the extension.
For example, row one would contain just "02" instead of "02.pdf". Any idea how this can be done with an expression? I would just use trim, but the folder may contain 4 letter office extensions like "xlsx".
View attachment file-extensions.png
