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

[FrederikE · Accepted solution]

Hey @sriniprad08,

You could do something like this:

But the "start with" part is missing - what do you mean there?

[FinnCharlton]

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.

[binuacs]

@sriniprad08 one way using contains formula

IIF(Contains([input],’-S’,’Sales Contract’,IIF(Contains([input],’-P’,’Purchase Contract’,’cxl’))

[sriniprad08]

Hi @binuacs ,

thanks for the reply and help. am i missing anything in this error

[FinnCharlton]

@sriniprad08 need a ')' after ([Input],'-S'

[sriniprad08]

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

[FinnCharlton · Accepted solution]

@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]

Hi @FrederikE ,

thanks. looks great. the start part is if starts with CXL then its CXL.

Cheers,

Sri

[sriniprad08]

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