topic Re: How to cut the string after a SPECIFIC symbol? in Discussions

How to cut the string after a SPECIFIC symbol?

Alex19 — Sun, 11 Jun 2023 00:00:25 GMT

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?

Note: I entered the File Name manually.

Thank you all in advance!

Alex.

Re: How to cut the string after a SPECIFIC symbol?

Alex19 — Wed, 12 Apr 2023 20:29:12 GMT

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...

Re: How to cut the string after a SPECIFIC symbol?

txnelson — Wed, 12 Apr 2023 20:33:26 GMT

word(-1, :File Path, "\/" );

reverse(substr(reverse(:File Path),1,contains(reverse(:File Path), "\") -1 ) );

Re: How to cut the string after a SPECIFIC symbol?

Alex19 — Wed, 12 Apr 2023 20:37:22 GMT

Oh this is beautiful! Thank you so much!