Crystal report identifer space (gap) from right string.

[marek_moravcik]

Hallo

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

[marek_moravcik · Accepted solution]

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

I searched researched but not space.

thanks both, Abhilash and Ian

---solved---

[Former Member]

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)

Ian

[abhilash_kumar]

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?

-Abhilash