Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Your question does not seem clear enough to me.
The only objection I can make without knowing more detail (or writing a long essay) is the question whether you are aware of the fact that SEARCH and MATCH both are capable of working with regular expressions, and that the question mark is a "special character" concerning RegEx. If not, you may also not have checked the related setting in 'Calculate' > 'General Calculations'.
Very much easier the thing will look as soon as you attach an example Calc document demonstrating your isue. I will see for it that you can use the attachment tool of this forum now.

Your question does not seem clear enough to me.
The only objection I can make without knowing more detail (or writing a long essay) is the question whether you are aware of the fact that SEARCH and MATCH both are capable of working with regular expressions, and that the question mark is a "special character" concerning RegEx. If not, you may also not have checked the related setting in 'Calculate' > 'General Calculations'.

If working with Regex is enabled, you must "escape" special caharcters occurring in a string to search for. The search string ab?c will find in UacX (false positive), but will not find in Uab?cX (false negative) if the RegEx engine is active and ? was meant to be a literal. The search string ab\?c will avoid both these errors. (To search for a literal backslash it must also be escaped).

Very much easier the thing clearer your quwestion will look as soon as you attach an example Calc document demonstrating your isue. issue. I will see for it that you can use the attachment tool of this forum now.

Your question does not seem clear enough to me.
The only objection I can make without knowing more detail (or writing a long essay) is the question whether you are aware of the fact that SEARCH and MATCH both are capable of working with regular expressions, and that the question mark is a "special character" concerning RegEx. If not, you may also not have checked the related setting in 'Calculate' > 'General Calculations'.

If working with Regex is enabled, you must "escape" special caharcters occurring in a string to search for. The search string ab?c will find in UacX (false and UabcX ("false" positive), but will not find in Uab?cX (false ("false" negative) if the RegEx engine is active and ? was meant to be a literal. The search string ab\?c will avoid both these errors. (To search for a literal backslash it must also be escaped).

Very much clearer your quwestion will look as soon as you attach an example Calc document demonstrating your issue. I will see for it that you can use the attachment tool of this forum now.

Your question does not seem clear enough to me.
The only objection I can make without knowing more detail (or writing a long essay) is the question whether you are aware of the fact that SEARCH and MATCH both are capable of working with regular expressions, and that the question mark is a "special character" concerning RegEx. If not, you may also not have checked the related setting in 'Calculate' > 'General Calculations'.

If working with Regex is enabled, you must "escape" special caharcters occurring in a string to search for. The search string ab?c will find in UacX and in UabcX ("false" positive), but will not find in Uab?cX ("false" negative) if the RegEx engine is active and ? was meant to be a literal. The search string ab\?c will avoid both these errors. (To search for a literal backslash it must also be escaped).

Very much clearer your quwestion will look as soon as you attach an example Calc document demonstrating your issue. I will see for it that you can use the attachment tool of this forum now.