Thank you Set J
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Montag, 7. Dezember 2015 20:59
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] string difficulty
Den 07.12.2015 13:55, skrev 'checkmail' check_mail@satron.de
[firebird-support]:
> .. and if the ID has the length of 15 chars and only the las * is for
filling out to 16, i get a wrong result too.
>
> Can I compact my code?
>
> if(char_length(str)>16) then
> begin
> str = left(:str,16);
> while (k = 1) do
> begin
> if(right(str, 1) = '*') then
> begin
> str = left(str,char_length(str)-1);
> end
> else
> begin
> teil = str;
> k = 0;
> end
> end
> end
>
> (exept the one begin-end (only one command can be without..)
>
http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-trim.html
Hence, I think your 16 lines above can be replaced by one simple line
(if you use Fb 2.5):
str = trim (trailing '*' from left(:str, 16));
HTH,
Set
Posted by: "checkmail" <check_mail@satron.de>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (14) |
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment