create category filed issue

[alec1982]

hi,

I have a filed that has

fieldName

sales\layer 1\abc

sales\layer 1\2 \test

calls\layer 1 testing

prod\layer 3\abc

I need a field that shows

layer 1

layer 1\2

layer 1

layer 3

tried wildmatch but run into issue because of having "1/2"

[sunny_talwar]

May be this:

Pick(WildMatch(FieldName, '*Layer 3*', '*Presentation Layer*', '*Layer 2*', '*Layer 1/2*', '*Layer 1*'), 'Layer 3', 'Presentation Layer', 'Layer 2', 'Layer 1/2', 'Layer 1')