Ask Your Question
0

My version: 6.0.4.2 (x64) libreoffice calc does not recognise .* as a wildcard. How can I enable this?

asked 2018-10-17 20:04:58 +0100

PasteImageJul17 gravatar image

Hallo

My version: 6.0.4.2 (x64) libreoffice calc does not recognise .* as a wildcard. Please tell me, how can I enable this? I need to make a decision based on whether a group of three specific characters is present in a group of six characters.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-10-17 20:17:01 +0100

erAck gravatar image

updated 2018-10-20 13:27:37 +0100

If you're talking of spreadsheet functions of which some can process regular expressions then it is the setting under menu Tools -> Options -> Calc -> Calculate, General Calculations, Enable regular expressions in formulas. If that is not what you wanted then edit your question to explain.

Update 2018-10-20

To pick up your remark from https://ask.libreoffice.org/en/questi... that it doesn't work with IF(L38=".ABC.","YES","NO")

Yes, comparison operators like = do not support regular expressions nor wildcards (your example lacks the * btw and should probably read IF(L38=".*ABC.*","YES","NO") instead). Only a few spreadsheet functions do, you could use SEARCH to achieve this:

=IF(ISERROR(SEARCH(".*ABC.*";L38));"NO";"YES")
edit flag offensive delete link more

Comments

@erAck: not OP, but that is a very elegant solution and one I can find a use for.

Thank you!

BigRAl gravatar imageBigRAl ( 2018-10-20 14:02:07 +0100 )edit
1

Probably a little bit simpler:
=IF(COUNIF(L38;".*ABC.*")>0;"YES;"NO")
(=IF(COUNIF(L38;".*ABC.*");"YES;"NO") would also do.)

Lupp gravatar imageLupp ( 2018-10-20 14:07:50 +0100 )edit

Thanks to you too, @Lupp.

I'm spoilt for choice now!

BigRAl gravatar imageBigRAl ( 2018-10-20 14:14:06 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-17 20:04:58 +0100

Seen: 55 times

Last updated: Oct 20 '18