Hello,
I have a data set that I need to check the number of characters in a specific column, then return a value.
I want to check the Assignment column for 18 digits (including the slash)
Data:
Output:
Create a new column title "Contract type"
In Contract type column add the following values"
1 - If there is not 18 digits or blank, then default to "Fleet" for contract type
2 - If there are 18 digits then check the 5th digit.
3 - If 5th digit is 1 then "Fleet", if 2 then "Machinery", if 3 then "Other", if 4 then "Real Estate"
Solved! Go to Solution.
Hey @tiverson, does this look like what you're expecting?
Quick edit: With the above approach, this assumes that there's only ever 1/2/3/4 as the 5th character. If you need it to handle more possibilities then you can use the below. It's currently set to null() anything not 1-4 so just change that to whatever it needs to be.
Thanks @DataNath