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

[binu_acs]

@sriniprad08 use the StartsWith() function 

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

[sriniprad08]

Thank you @binu_acs  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.

[binu_acs]

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

[sriniprad08]

Thanks @binu_acs  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.

[binu_acs · Accepted solution]

@sriniprad08 try the attached workflow

[sriniprad08]

Hi @binu_acs ,

Great. Thank you. Appreciate it.