Magic ETL - string operations help
If i have an excel spreadsheet that contains the following column called file path: FilePathBUILDING\200303379 Files\Receipt20181213_20200107_133244.pdfBUILDING\200303379 Files\Receipt20181213_20200107_133309.pdfBUILDING\200410340 Files\HIDAWAY AVE 27227 (200410340)_CASE DOCUMENT.pdfBUILDING\29700587…
