Created:
Apr 12, 2023 04:15 PM
| Last Modified: Jun 10, 2023 5:00 PM(1186 views)
I have a column of strings with the full File Path + File Name. I need to isolate specifically the File Name in the next column. Is there a way to do it?
A small clarification - as a pseudo-code I'd need something like that: cut string before the first "\" when scanning the string from the right-to-left. My problem is that I can have Path and File Name of variable lengths, so, cannot use "Left" or "Right" functions with the fixed # of characters to isolate...