Wildcards within formulars

Post your questions, bug reports and suggestions here for PlanMaker 2018 for Windows.

Moderator: SoftMaker Team

Post Reply
Babylonia
Posts: 8
Joined: Mon Jul 08, 2019 9:40 am

Wildcards within formulars

Post by Babylonia » Mon Jul 08, 2019 10:16 am

Hello,

I am just trying to make some kind of "IF" / THAN" formula to add in my worksheet.
But don't get the right wildcard functionality.

E.g. a simple comparison.
I have a column with "text" attributes as for telephone numbers:

Within a cell I do want the outcome to be "Mobile" or "Landline" as for the comparison of the first two digits.
(Mobile numbers in Holland always do start with 06 and do have 10 digits without the international number format).
Formulas are translated by me, as I am using a Dutch version of Planmaker, and formulas do have Dutch attributes.

By HELP file the wildcards should be written as "^?" for each character (a strange wildcard interpretation IMO).
or "*" for many numbers.

E.g. used "mobile" numbers:
0612345678
0687654321
0633333333

Formula that should do the trick ?? (C3 = the cell containing the number):

=IF(C3="06^?^?^?^?^?^?^?^?";"Mobile";"Landline")

or a more logical wildcard interpretation
=IF(C3="06????????";"Mobile";"Landline")

or at least
=IF(C3="06*";"Mobile";"Landline")

ALL of these formulas do give "Landline" as outcome.
However if I change e.g. the formula to:

=IF(C3="0612345678";"Mobile";"Landline") ----> the outcome is "Mobile"

So what is the correct wildcard interpretation?

Babylonia
Posts: 8
Joined: Mon Jul 08, 2019 9:40 am

Re: Wildcards within formulars

Post by Babylonia » Sat Jul 13, 2019 12:14 pm

Nobody have an answer or solution??

miguel-c
SoftMaker Team
SoftMaker Team
Posts: 248
Joined: Wed Jun 05, 2019 12:02 pm

Re: Wildcards within formulars

Post by miguel-c » Sat Jul 13, 2019 4:36 pm

Hi, =IF(LEFT(A1;2)="06";"Mobile"; "Landline") will do what you want.

Babylonia
Posts: 8
Joined: Mon Jul 08, 2019 9:40 am

Re: Wildcards within formulars

Post by Babylonia » Sun Jul 14, 2019 9:58 am

Thank you. That did the trick.

Post Reply

Return to “PlanMaker 2018 for Windows”