How to remove all date after multiple character

[AshishAgarwal]

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

[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 · Accepted solution]

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?

[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!

[binuacs]

@AshishAgarwal Another option using the RegexReplace formula

[Qiu]

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