New field creation based on rules

[Pranee_007]

Hi team,

I am looking to add a new field based on the below conditions. Please help.

1. If the field 'Reference' is Check (case insensitive), a new column 'Code' should be added and assign a value Not-found to that.

2. If it sees the key word app in any case (case insensitive), I want the new field to be populated with the 9 digits after keyword app.

Example:

Reference	Code
Check	Not-found
appv56789Sup	v56789Sup
APPf63889Dsp	f63889Dsp
aPpr67299Luy	r67299Luy
check	Not-found

[LordNeilLord · Accepted solution]

Hey @Pranee_007 

A simple formula should suffice here:

If Contains([Reference], "app") Then Regex_Replace(Reference, "app", "") Else "not found" endif