Hi All, I am trying to get all first group and would like to remove all data after different character. Field1RequiredChandragupta_TczsfChandraguptaSaoj_ts\dfgfSarojPreeti_Tsf@dfdPreetiAshish_Ts.dffAshish

How to remove all date after multiple character

Hi All,

I am trying to get all first group and would like to remove all data after different character.

Field1	Required
Chandragupta_Tczsf	Chandragupta
Saoj_ts\dfgf	Saroj
Preeti_Tsf@dfd	Preeti
Ashish_Ts.dff	Ashish

Regex

Parse

Accepted answers

grazitti_sapna

Hi @AshishAgarwal , try this

([a-zA-Z0-9 ]+) and use option tokenize.

Thanks!

All comments

grazitti_sapna

Hello @AshishAgarwal , you can use the text to column tool and under delimiter section pass _ to separate the data and get all the data before _ as a required output.

I hope this helps!

Thanks!

AshishAgarwal

Hi Sapna,

Thank you for input.

Small change in my excel which I missed to inform earlier

Field1	Required
Chandragupta_Tczsf	Chandragupta
Saoj_ts\dfgf	Saroj
Preeti.Tsf@dfd	Preeti
Ashish@Ts.dff	Ashish

Its not necessary that first charatcter will be "_".

Can you please help me on this.

I tried searching on community but not able to get any solution.

Regards,

Ashish

grazitti_sapna

Hi @AshishAgarwal , try this

([a-zA-Z0-9 ]+) and use option tokenize.

Thanks!

Qiu

@AshishAgarwal
Can we say you only want the alphabets before any special characters?

0519-AshishAgarwal.yxmd

AshishAgarwal

Hi Qiu,

I require number as well.

I missed to give example of number too.

Hi Sapna,

Your Logic has worked well for me.

Will check further till now.

Thank you so much.

Regards,

Ashish

grazitti_sapna

@AshishAgarwal, if my post works for you kindly mark my post as a solution!

Thanks!

binu_acs

@AshishAgarwal Another option using the RegexReplace formula

Reegex_Replace_19_05.yxmd

Qiu

@AshishAgarwal
If that is the case, @binu_acs solution should work. 😁

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280