Subscribe Bookmark RSS Feed

Which function could quickly remove the blank in front of string?

judith

Community Trekker

Joined:

Jan 19, 2012

Which function could I use to remove the blank in front of string? Is there any function that works like left() of SAS? Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

There doesn't appear to be an LTRIM function.  Here's one way to do it, using a regular expression.

/*

Function Name: ltrim

Description: Trim any spaces on the left side of a string.

Arguments:

in_string   String to do the left trim on

Sample calls:

   a = "   ddd   eee fff   ";

   print(ltrim(a));

   c = "abcde";

   print(ltrim(c));

*/

ltrim = Function( {in_string},

      {Default Local},

// Use the regular expression "^ *" which means start at the beginning of the string

// and match any number of sequential spaces

      start_nonspace = length(Regex(in_string, "^ *"));

      ltrim_string   = substr(in_string, (start_nonspace+1));

      ltrim_string;

);

5 REPLIES
Solution

There doesn't appear to be an LTRIM function.  Here's one way to do it, using a regular expression.

/*

Function Name: ltrim

Description: Trim any spaces on the left side of a string.

Arguments:

in_string   String to do the left trim on

Sample calls:

   a = "   ddd   eee fff   ";

   print(ltrim(a));

   c = "abcde";

   print(ltrim(c));

*/

ltrim = Function( {in_string},

      {Default Local},

// Use the regular expression "^ *" which means start at the beginning of the string

// and match any number of sequential spaces

      start_nonspace = length(Regex(in_string, "^ *"));

      ltrim_string   = substr(in_string, (start_nonspace+1));

      ltrim_string;

);

judith

Community Trekker

Joined:

Jan 19, 2012

Thanks a lot for your instruction again. Your answer is always helpful.

ms

Super User

Joined:

Jun 23, 2011

Trim() supports an optional "left", "both" or "right" argument. Default is to trim trailing whitespace at both ends.

s = "   Column Name ";

Trim( s, left );


judith

Community Trekker

Joined:

Jan 19, 2012

That was a quick and simple answer. Thanks for your input.

pmroz

Super User

Joined:

Jun 23, 2011

I should have RTFM'd.  Thanks for pointing that out MS!