Jump to content
  • 0

Worksheet - Substring from Class doesn't work (2021, 2022)


Posted (edited)

As you can see in the worksheet in the attached file I tried to extract the substring from a classname in a worksheet.

The result isn't the substring but a number.

The code in the first column of a database-row is "=SUBSTRING(C; '-'; 1)" and doesn't work.


The only way to get the class-substring works with two columns, one with a simple "=C" and the second with =SUBSTRING(B2; '-'; 1) (B2 = the Cell-Name in which I am looking for the class name by "=C")


Looks like a bug to me, isn't it?


(so also the more complicated code "=CONCAT((SUBSTRING(B2; '-'; 1)); ' -|- '; (SUBSTRING(B2; '-'; 2)); ' -|- '; (SUBSTRING(B2; '-'; 3)); ' -|- '; (SUBSTRING(B2; '-'; 4)))" works ^^)


ps. =IF((C='*A*'); 'A'; (IF((C='.*E*'); 'E'; IF((C='*H*'); 'H'; 'Y')))) doesn't work either, i have to use =IF((B2='*A*'); 'A'; (IF((B2='.*E*'); 'E'; IF((B2='*H*'); 'H'; 'Y')))) instead 😞 )




Substring from Class.zip

Edited by matteoluigi
Link to comment

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...