Hi,

Is there a way to split a string to remove the rest of the string once it has the symbol $ in it?

Example:
JOHN$$$$ = JOHN
STEVEN$HH = STEVEN
RICHARD$$$$H = RICHARD

Thanks