Task
A table contains a full file URL or path. The result needs file_name with the last path segment and extension.
Short answer
Remove ? and # first, then keep the final name.ext segment with a regular expression.
How to do it in Eofferix
- Upload the table with file URLs or paths.
The file_namecolumn contains only the final path segment. - Create
file_namefromfile_url, clean query string and fragment, then keep the last segment with an extension.
Parameters are removed first, then the regex keeps the file with extension. - Use
[^/\\]+\.[A-Za-z0-9]+$after cleaning parameters. - Save the template and test absolute URLs and relative paths.
Before / after
The data below is a training example and does not belong to real user files.
Before
source data| id | file_url |
|---|---|
| 1001 | https://cdn.example.com/files/catalog/price-list.xlsx?download=1 |
| 1002 | /uploads/manuals/product-guide.PDF#open |
After
result| id | file_name |
|---|---|
| 1001 | price-list.xlsx |
| 1002 | product-guide.PDF |