Forum Discussion

ShontaySmith's avatar
ShontaySmith
Qrew Assistant Captain
9 years ago

How to create a if statement using the first 4 char of a text field

I need help trying to create an if state using the first 3 or 4 char of a text field For example if  [text field 1] start with 7083 = 083                          [text field 1] start with 083 = 0...
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
To show just the left most characters you can use the formula "Left"

Left([text field], 3)  will return the left 3 characters.

Combine that with your if like this:

If(Left([Text Field], 3)="083", "Result if true", "result if false")

Then to combine both of those to evaluate options you can "daisy chain" them together:

If(Left([Text Field], 3)="083", "083",
If(Left([Text Field], 4)="7083", "083", "result if neither is true"))