TRIM function

lloydf

Hi there
Does anyone know if it is possible to TRIM a string from trailing and leading spaces?

Thanks

LLoyd

Revolution1210

You can do this using the C/AL function DELCHR

To delete leading spaces from a string:

String := DELCHR(String,'<',' ');

To delete trailing spaces from a string:

String := DELCHR(String,'>',' ');

To delete both leading and trailing spaces:

String := DELCHR(String,'<>',' ');

lloydf

Thanks Ian, it works a treat!

DenSter

traling spaces will be trimmed automatically from text type table fields if you VALIDATE the value.

Kowa

Revolution1210 wrote:

String := DELCHR(String,'<>',' ');

Since "spaces" is the default for the second parameter,

String := DELCHR(String,'<>');

will also work.