Finding Patterns and Creating column

[sriniprad08]

Hi Team,

Hope you are well.

i need help. Please find below and let me know how to go about this.

Thanks

[binuacs]

@sriniprad08 use the StartsWith() function 

IIF(StartsWith(]input],’CZL’),’CZL’,IIF(StartsWith(]input],’CXL’),’CXL‘,’ZZZ Contract’))

[sriniprad08]

Thank you @binuacs  This is great. But one challenge there are many other values inside that column other than what i listed.

so ideally it will classify everything else apart from cxl as zzz contract. 

ideally it has identify the pattern of the zzz contract and tag them. Remaining as others.

[binuacs]

@sriniprad08 if the string has -S or -P then can it be considered as ZZZ contract? Or any other pattern should follow

[sriniprad08]

Thanks @binuacs  Please find below

The marked in Red has no -S or -P but still its a zzz contract.

the one marked in yellow has shorter length than the black one. it will be zzz contract.

[binuacs · Accepted solution]

@sriniprad08 try the attached workflow

[sriniprad08]

Hi @binuacs ,

Great. Thank you. Appreciate it.