Difference between Trim() and TrimLeadingTrailing()

[gowrishankar_h]

Hi All,

One basic question what the difference between function Trim() and Trimleadingtrailing()..I hope both do the same job.

Thanks,
Gowri

[priyadarshikunal]

Trim() can do the job of TrimLeadingTrailing() however vice-versa is not true.

TrimLeadingTrailing() will remove leading and trailing spaces. However Trim() without any specifier will remove leading and trailing spaces along with redundant spaces within the string.

The syntax for Trim() is trim(<string>,<trim char>, <trim option>)

Trim has a few options and by default D is used and space is used by default for trim char. If option B is selected then it will remove leading and trailing characters. Please refer the manual for more details.

[ray.wurlod]

In summary, they will behave differently on strings such as

Code: Select all

"     HERMAN      MUNSTER       "

TrimLeadingTrailing() will produce

Code: Select all

"HERMAN      MUNSTER"

Trim() with no other arguments will produce

Code: Select all

"HERMAN MUNSTER"

[chulett]

Or...

Code: Select all

"     1313   Mockingbird     Lane          "

[ray.wurlod]

:D