BookmarkSubscribeSubscribe to RSS Feed
judith

Community Trekker

Joined:

Jan 19, 2012

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

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
pmroz

Super User

Joined:

Jun 23, 2011

Solution

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

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
pmroz

Super User

Joined:

Jun 23, 2011

Solution

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

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

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

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

ms

Super User

Joined:

Jun 23, 2011

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

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

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

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

pmroz

Super User

Joined:

Jun 23, 2011

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

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