If i have an excel spreadsheet that contains the following column called file path:
| FilePath |
| BUILDING\200303379 Files\Receipt20181213_20200107_133244.pdf |
| BUILDING\200303379 Files\Receipt20181213_20200107_133309.pdf |
| BUILDING\200410340 Files\HIDAWAY AVE 27227 (200410340)_CASE DOCUMENT.pdf |
| BUILDING\29700587 Files\Receipt20181213_20200107_133333.pdf |
| BUILDING\29700587 Files\Receipt20181213_20200107_133350.pdf |
| BUILDING\29804878 Files\Receipt_20181213_144740.pdf |
| BUILDING\29804878 Files\Receipt_20181213_144805.pdf |
| BUILDING\29804878 Files\Receipt_20181213_144809.pdf |
| BUILDING\29804878 Files\Receipt_20181213_144810.pdf |
| BUILDING\29903009 Files\Receipt_20181204_090007.pdf |
| BUILDING\BLD05-04079 Files\Receipt20181213_20191223_095745.pdf |
| BUILDING\BLD05-04079 Files\Receipt20181213_20191223_095813.pdf |
| BUILDING\BLD06-02296 Files\Receipt20181213_20190523_101859.pdf |
Is there a way to use magic etl string operations to only give me the file name?
| FileName |
| Receipt20181213_20200107_133244.pdf |
| Receipt20181213_20200107_133309.pdf |
| HIDAWAY AVE 27227 (200410340)_CASE DOCUMENT.pdf |
| Receipt20181213_20200107_133333.pdf |
| Receipt20181213_20200107_133350.pdf |
| Receipt_20181213_144740.pdf |
| Receipt_20181213_144805.pdf |
| Receipt_20181213_144809.pdf |
| Receipt_20181213_144810.pdf |
| Receipt_20181204_090007.pdf |
| Receipt20181213_20191223_095745.pdf |
| Receipt20181213_20191223_095813.pdf |
Any ideas? Thanks.
