Skip to Content

Crystal report identifer space (gap) from right string.

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 22, 2017 at 12:00 PM

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

    I searched researched but not space.

    thanks both, Abhilash and Ian

    ---solved---

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 22, 2017 at 07:48 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 22, 2017 at 09:06 AM

    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

    Add comment
    10|10000 characters needed characters exceeded