My problem with char(30)

Hi to all!

I don´t understand at all the role of char(30) in the formula

=RIGHT(F2;LEN(F2)-FIND(CHAR(30);SUBSTITUTE(F2;".";CHAR(30);LEN(F2)-LEN(SUBSTITUTE(F2;".";"")))))

Char(30) is record separator, but in a string (e.g. 1 Prelude.mp3) ????
What does it mean?

It's a placeholder that is presumably not likely to be found in the
string in F2.

The outside SUBSTITUTE() function replaces the last "." character in F2
with CHAR(30). That character is then used by FIND() to locate where the
last "." is.

One could save a function call using

=MID(F2; FIND(CHAR(30); SUBSTITUTE(F2;".";CHAR(30);
LEN(F2)-LEN(SUBSTITUTE(F2;".";""))))+1;255)



In article <omikron123.21n2am_1137265802.6216@excelforum-nospam.com>,
omikron123 <omikron123.21n2am_1137265802.6216@excelforum-nospam.com>
wrote:

> I don´t understand at all the role of char(30) in the formula
>
> =RIGHT(F2;LEN(F2)-FIND(CHAR(30);SUBSTITUTE(F2;".";CHAR(30);LEN(F2)-LEN(SUBSTIT
> UTE(F2;".";"")))))
>
> Char(30) is record separator, but in a string (e.g. 1 Prelude.mp3)
> ????
> What does it mean?

Thank you very much.

Originally Posted by JE McGimpsey

It's a placeholder that is presumably not likely to be found in the
string in F2.

The outside SUBSTITUTE() function replaces the last "." character in F2
with CHAR(30). That character is then used by FIND() to locate where the
last "." is.

One could save a function call using

=MID(F2; FIND(CHAR(30); SUBSTITUTE(F2;".";CHAR(30);
LEN(F2)-LEN(SUBSTITUTE(F2;".";""))))+1;255)



In article <omikron123.21n2am_1137265802.6216@excelforum-nospam.com>,
omikron123 <omikron123.21n2am_1137265802.6216@excelforum-nospam.com>
wrote:

> I don´t understand at all the role of char(30) in the formula
>
> =RIGHT(F2;LEN(F2)-FIND(CHAR(30);SUBSTITUTE(F2;".";CHAR(30);LEN(F2)-LEN(SUBSTIT
> UTE(F2;".";"")))))
>
> Char(30) is record separator, but in a string (e.g. 1 Prelude.mp3)
> ????
> What does it mean?