remove everything after '_' character

Question

Hi,

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

namelast namecodeabcdefMQ_ALs_234589

KJFKLJERT_Alte_kjm56

FGHLKJH#3_LKJMKJHKL456_KL_MKL_KL

Output:

namelast namecodeabcdefMQ

KJFKLJERT

FGHLKJH#3MKJHKL456

Emmanuel_G · Answer

@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.

Split strings.yxmd

davidskaife · Answer

Hi @Sshasnk

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

Strip after _.yxmd

binu_acs · Answer

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

substring_0927.yxmd