Report Builder Formating

Yahoo Archive
1
Something like:

IIF(Length(X) > 5, Substring(String(X),(Length(X) - 5, Length(X)),X)


Patrick Winter



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Monday, November 13, 2006 7:47 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report Builder Formating



Hello everybody,

How would I create a calculated formula that would take a text field and
give me only the last 5 characters?

Any ideas?

Thanks,
Jasper


[Non-text portions of this message have been removed]






This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

[Non-text portions of this message have been removed]
2
Hello everybody,

How would I create a calculated formula that would take a text field and give me only the last 5 characters?

Any ideas?

Thanks,
Jasper



[Non-text portions of this message have been removed]
3
There may be shorter but...

SUBSTRING(StringX,LENGTH(Stringx) - 5,5)

...should work.
-Todd C.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Jasper Recto
Sent: Monday, November 13, 2006 7:47 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Report Builder Formating



Hello everybody,

How would I create a calculated formula that would take a text field and give me only the last 5 characters?

Any ideas?

Thanks,
Jasper


[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]