Remove Trailing Squares from String

Question

Question

Jude Mukkadayil · Aug 12, 2020

Hi,

Can anyone please explain me how to remove trailing squares from the text field (String). Trailing squares is a white space ?

I tried different things like Ltrim, Trim from sql query side and also from object scripting side something below.

If Address1 set Address1 = $ZSTRIP(Address1,"<>P,<>C,<>W")
If Address1 set Address1 = $ZSTRIP(Address1,"$C(9), $C(32), $C(160)")
If Address1 set Address1 = $ZSTRIP(Address1,"*W,*C")

Nothing works for me

Can anyone please help me to solve this

Thanks

Discussion (5)3

Log in or sign up to continue

Jude Mukkadayil · Aug 13, 2020

Thanks to everyone.

It starts working after I tried this code.

Set Address1 = $ZSTRIP(Address1,"*C",,)

0 0

score 1 · Answer 1 · 2020-08-12T10:47:44-04:00

You need to identify what character(s) the trailing squares actually are. Typically an empty box is not whitespace, but something for which your font doesn't have a glyph. Can you post the output of zzdump for one of the strings?

score 1 · Answer 2 · 2020-08-13T13:50:13-04:00

it's important to ZZDUMP the "address" to understand what is going on

if it is a $LB-structure you may also see the squares not id is not whitespace
then $ZSTRIP() will not help at all but just cause confusion

score 0 · Answer 3 · 2020-08-12T15:05:00-04:00

Hi Jude, first identify the character by:

for j = 1: 1 s car = $ e (a, j) q: car = "" w !, car, "=", $ a (car)

to know the square character

score 0 · Answer 4 · 2020-08-13T12:46:54-04:00

While I agree that you need to identify the ascii value of the characters you have at the end, I do want to note that to remove trailing whitespaces, the syntax is $zstrip(x,">W")

Using that removes trailing whitespaces as you can see in the example below. Additionally, to add the stripping of "control characters" you would just add the C, so $zstrip(x,">WC")

>set x = " apple "

>write "/" _ $zstrip(x,">W") _ "/"
/ apple/
>