CODEWITHSUNDEEP
openoffice.orgopenoffice-calc
Lona gracia
Lona gracia

Reputation: 125

Selecting a specific row with a condition ? LibreOffice Calc

I have this LibreOffice calc file with raws with full of zero

raw1 raw2 raw3 raw4 raw5 raw6 raw7 raw8 raw9 
 0    0    0    0    C    0    0    0    0
 0    0    0    0    0    0    0    W    0

I want to print only the character inside the row, like this 

Result 
  C
  W

I did try with 'if' condition 

IF(CD2:CR16 = 1, CD2:CR16)

but it's give me an error

Upvotes: 1

Views: 4188

Answers (1)

Jim K
Jim K

Reputation: 13820

Use MATCH to find the column that contains a character, and then INDEX to get the cell's value.

=INDEX(CD2:CR2, MATCH("[A-Z]", CD2:CR2, 0))

For this to work, go to Tools -> Options -> LibreOffice Calc -> Calculate, and choose Enable regular expressions in formulas.

EDIT:

According to https://help.libreoffice.org/Common/List_of_Regular_Expressions, [:print:] represents any printable character, so it grabs the first zero, which is probably why it does not seem to do what you want.

To match one of several words, the regular expression should be like this:

"word1|word2|word3"

Or for any word consisting of one or more letters:

"[:alpha:]+"

EDIT 2:

To grab C and 8 from 0 0 C 0 and 8 0 0 0 respectively, use "[A-Z1-9]".

Upvotes: 2

Related Questions