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 😞 )
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.
Question
matteoluigi
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 matteoluigiLink 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.