Skip to Content
0
Former Member
Aug 20, 2015 at 12:37 PM

match function

3919 Views

Hi everyone.

I have dimension where I should select by contract numbers.

Purchase contracts begin with P and looks like P00934875

Sale contracts begin with S and looks like S_238098346237

I want to create variable and group all purchase or sale contracts.

I use match function and create different variables like

=If Match([Contractno];"%p%") Then "Purchase" ElseIf

Match([Contractno];"%S%") Then "Sale"

another variable

=if Match ([Contractno];"p*") Then "Purchase" ElseIf

Match([Transrefid];"s*") Then "Sale"

no one of these help me. What is correct syntax for match function? Please help me with this issue.