Skip to main content
Snowshoeman13-Aquamarine
13-Aquamarine
Feb 22, 2026 8:59 PM UTC
Solved

remove blank characters in a string

I would write a function to remove blank characters in rename the string.  See attached.

Werner_E
Werner_EAnswer
25-Diamond I
Feb 22, 2026 11:33 PM UTC

We can turn my approach to a function where you can select the character to delete

grafik.png

 

Or we could also create a function to replace one character for another one (empty string means delete)

grafik.png

 

And here is a string trimmer using "search" and "substr" as you had tried to do

grafik.png

Note that this approach will not work OK if ORIGIN is set to a value different from zero AND the calculation option "ORIGIN in  Strings" is set (which is usually is not by default).

 

Prime 11 file attached

View in thread

6 replies

Werner_E
Werner_E25-Diamond I
25-Diamond I
Feb 22, 2026 10:57 PM UTC

I think its easier to convert the string into a vector using "str2vec", trim all occurrences of spaces (ASCII 32) and convert back to a string:

grafik.png

This approach fails in three cases: when the string is an empty string or when it does not contain any spaces (in which case “match” fails), or when the string consists exclusively of spaces (in which case “trim” fails).
For a general helper function, these error cases should therefore be handled. For example:

grafik.png

Or a little bit shorter

grafik.png

 

Translate
Snowshoeman13-AquamarineAuthor
13-Aquamarine
Feb 22, 2026 11:12 PM UTC

Thank you,

 

I was trying another approach, was working a long hand that I was going to put in program form. (see attach).  Your approach is much more superior.

 

 

 

Translate
Werner_E
Werner_E25-Diamond IAnswer
25-Diamond I
Feb 22, 2026 11:33 PM UTC

We can turn my approach to a function where you can select the character to delete

grafik.png

 

Or we could also create a function to replace one character for another one (empty string means delete)

grafik.png

 

And here is a string trimmer using "search" and "substr" as you had tried to do

grafik.png

Note that this approach will not work OK if ORIGIN is set to a value different from zero AND the calculation option "ORIGIN in  Strings" is set (which is usually is not by default).

 

Prime 11 file attached

Translate
    Terms & ConditionsAccessibility statement