LibreOffice 4.3, English, Calc
Windows 8, English
I am using =LEFT($J69;FIND(" “;$J69;1)-1) and =RIGHT($J69;LEN($J69)-FIND(” ";$J69)) to separate first and last name by detecting a space between them but then what would work to strip off the 4 left most characters like this one where the total length is unknown. /f/u/fuji_classic_track_2.jpg
The fourth character from the left is always a “/”.
Thanks for the help.
The MID() function doesn’t worry about missing characters at the end. Thus, if Text is a text expression,
=MID(Text;5;10000) will work for you even if LEN(Text ) is much less than 10000.
=RIGHT(Text;LEN(Text)-4) will work as RIGHT() did in your second piece of code.
The leftmost 4 characters will be deleted.
A third variant:
=REPLACE(Text;1;4;"")
[PS: In your example I saw a “u” on the 4th position.]
Thank you for this answer and pointing out that I can’t count 
It’s the fifth character that is always a /.