Extracting only the Letter RU from the column to another column

[sriniprad08]

Hi Team,

Hope you are well. I have column with text (which ends with RU and which doesn't).

i want a new column with all the text and the last two RU in another column.

Please let me know,

thanks,

Sri

[alexnajm]

Hi @sriniprad08,

Could you clarify the logic for row 7? It does not end with "RU" but still has "RU" in the Test 2 column.

-Alex

[BRRLL99]

Please check this regex expression

^(\w{8,11})(\w{0,2})$

[Zok]

Hello

You can use these formulas

[sriniprad08]

Hi @Zok ,

Thank you so much. this is great. But one issue its also truncating the RU in the middle  of the text. Only it has to truncate the last two letter.

[sriniprad08]

Hi @alexnajm ,

Sorry that was a type. There shouldnt be RU for that text.

Thanks for pointing out.

[ShankerV · Accepted solution]

Hi @sriniprad08 

One way of doing this.

Many thanks

Shanker V

[sriniprad08]

@Zok 

[BS_THE_ANALYST · Accepted solution]

@sriniprad08 one way:

[ShankerV]

Hi @sriniprad08 

Hope you checked the previous response. 

Hope that gave the expected result as you have posted.

Many thanks

Shanker V