Hello
I got a blank
Is there a function to remove space at the beginning of a string like trim or Clean in Excel?
Martin
Removing space space in a string
-
TJ
- Posts: 7743
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2222 times
Re: Removing space space in a string
Press [F1] and you will seeHello
I got a blank
Is there a function to remove space at the beginning of a string like trim or Clean in Excel?
Martin
all of the string-related keywords at your disposal:
- Attachments
-
- string.jpg
- (13.36 KiB) Downloaded 446 times
-
TJ
- Posts: 7743
- Joined: 29 Aug 2006
- Location: Global Citizen
- Has thanked: 1033 times
- Been thanked: 2222 times
Re: Removing space space in a string
the logic:
1. find out the string length
2. check to see if the left-most character is a " "
3. remove the " " by copying the right-most number of characters from the string.
Hope this helps.
1. find out the string length
2. check to see if the left-most character is a " "
3. remove the " " by copying the right-most number of characters from the string.
Hope this helps.