Discussions
remove the last two spaces from a string
If the length of my string is 30. I got to remove the last 2 spaces from the string .
If the length of my string is 29.I got to remove the last space from the string.
Eg. COADC Cathy & Ralph Ward Jr 73
should be COADC Cathy & Ralph WardJr73
and not COADCCathy&RalphWardJr73
Tried trim() ,instr, substr and replace() spaces but did not work out. is there any other function?