I need a formula that will trim the serial numbers that start with UG22 to the following three characters. In the example below the result would go from UG2221511168 to 215
Hey @nicktekippe,
Hard to recommend a one size fits all solution to this but one method is to do the following:
IF Left([Serial#],4)="UG22" THEN Substring([Serial#],4,3) ELSE [Serial#] ENDIF
The formula checks if the text starts with UG22 if it does then starting from the 4th character grab the first 3 characters:
The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20Expressions
Any questions or issues please askIra WattTechnical ConsultantWatt@Bulien.com
