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

To_ask_alteryx1.xlsx

Datasets

Parse

Accepted answers

ShankerV

Hi @sriniprad08

One way of doing this.

Many thanks

Shanker V

Extracting only the Letter RU from the column to another column.yxmd

BS_THE_ANALYST

@sriniprad08 one way:

regex_help.yxmd

All comments

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

Hi @sriniprad08

One way of doing this.

Many thanks

Shanker V

Extracting only the Letter RU from the column to another column.yxmd

sriniprad08

@Zok

BS_THE_ANALYST

@sriniprad08 one way:

regex_help.yxmd

ShankerV

Hi @sriniprad08

Hope you checked the previous response.

Hope that gave the expected result as you have posted.

Many thanks

Shanker V

sriniprad08

Hi @ShankerV @BS_THE_ANALYST ,

Thank you for the solution. Appreciate that.

Cheers,

Sri

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280