Hi Team,
Hope you are well.
i need help. Please find below and let me know how to go about this.
Thanks
Hey @sriniprad08,
You could do something like this:
But the "start with" part is missing - what do you mean there?
@sriniprad08 Do you want these variants to return 'CXL' as well, or something else? I think everyone here's code will return 'CXL' for all those values.
@sriniprad08 try the attached workflow
Hi @sriniprad08, something like this might help? Not sure if there is any more logic around the 'CXL' part, let me know if it works for you and we can try some other things if not.
@sriniprad08 one way using contains formula
IIF(Contains([input],’-S’,’Sales Contract’,IIF(Contains([input],’-P’,’Purchase Contract’,’cxl’))
Hi @binu_acs ,
thanks for the reply and help. am i missing anything in this error
Hi @FinnCharlton ,
Thank you for the help. Looks great. One question please
there are situation where CXL12334 or CXL-12345 or CXL 12345.
How can i handle these scenarios please?
Cheers,
Sri
Hi @FrederikE ,
thanks. looks great. the start part is if starts with CXL then its CXL.
Hi @FinnCharlton
Thank you for all the help. Please find attached the excel file the input and output. Sorry if there is a miscommunication,
Thanks for the support
@sriniprad08 use the StartsWith() function
IIF(StartsWith(]input],’CZL’),’CZL’,IIF(StartsWith(]input],’CXL’),’CXL‘,’ZZZ Contract’))
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.
@sriniprad08 if the string has -S or -P then can it be considered as ZZZ contract? Or any other pattern should follow
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.
Great. Thank you. Appreciate it.
