Showing results for 
Search instead for 
Did you mean: 

Crystal report identifer space (gap) from right string.

0 Kudos


please help me. I want to identify last character in string for right side string for example tel. num:

+4412345678 behind 8 is space

And this records I must identifer as True ( true or false)

I try:

right({phone},1) = " "

but this syntax is not correct because all records is False

thanks for solutions

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Abhilash you have true. It's probably not the last space.

I searched researched but not space.

thanks both, Abhilash and Ian


Answers (2)

Answers (2)

Former Member
0 Kudos

It might not be a space.

Copy field into word and switch on show hidden paragraph and hidden formatting symbols.

Probably a line feed or carriage return in which case use replace to remove or search for corresponding ascii code

eg for CR

right(right({phone},1) = chrw(13)


Active Contributor
0 Kudos

Hi Marek,

The formula works fine for me. It returns True when the string has a space at the end.

Are you sure there is a space at the end?