ignore a symbol in a name

[#1]

i have a field called name witch contains the symbol ' ; ' e.g "Tom Herman; "

i need only the name without the symbol.

thanks

[alexandros17 · Accepted solution]

purgechar ('Tom Herman;',';')

let me know

[tamilarasu]

Or tyr

Replace('Tom Herman; ',';','')

[florentina_doga]

left('Tom Herman;',len('Tom Herman;')-1)