If expression checking if the field starts with some letters

[#1]

Hey everyone,

I would like to know how to write a expression that will check if a particular expression start with the given letters.

For example i would like to check if my [Project Name] field starts with "CPM_" .

I don't know how to express this.

Thank you for your help

[MayilVahanan · Accepted solution]

Hi

Try like this

= Count({<ProjectName = {'CPM_*'}>}Sales)

Or

If(WildMatch(ProjectName,'CPM_*'), ProjectName)

Hope that helps

[Anonymous]

Arnaud

Use the WILDMATCH function.

Best Regards,     Bill

[CELAMBARASAN]

Use WildMatch

WildMatch([Project Name], 'CPM_*')

[#5]

Thank all of you for you help.

I used this expression : sum(If(WildMatch([Project Name],'CPM_*'),1,0))  to know the number of projects starting with CPM_.