remove everything after '_' character

[Sshasnk]

Hi,

I have a dataset and I have to remove everything affter '_'

name	last name	code
abc	def	MQ_ALs_234589
KJF	KLJ	ERT_Alte_kjm56
FGH	LKJH	#3_LKJ
MKJH	KL	456_KL_MKL_KL

Output:

name	last name	code
abc	def	MQ
KJF	KLJ	ERT
FGH	LKJH	#3
MKJH	KL	456

[binuacs]

@Sshasnk This can be done with the help of the substring function

[DavidSkaife]

Hi @Sshasnk 

Here is a quick way of doing it, as long as you always want the data prior to the first _

[Emmanuel_G]

@Sshasnk 

Find attached the way of doing this using Replace_first function.

Please do not hesitate to mark this answer as solution if it helped.