Domino 9 und frühere Versionen > Entwicklung

Sortieren von Daten in Profildokument

(1/3) > >>

MartinG:
Hallo,

ich habe in einer Datenbank ein Profildokument wo in einem Textfeld Kategorien eingepflegt werden.

Das ganze funktioniert auch perfekt - nur möchten meine User jetzt gerne das diese Kategorien jetzt auch alphabetisch sortiert werden. Leider komme ich da nicht richtig weiter bzw. befürchte das dies mit Formelsprache nicht mehr machbar ist?

Ich habe mir das so gedacht das ich dort eine Aktion oder Schaltfläche einfüge wo dann auf Knopfdruck dieses Feld sortiert wird...

Vielen Dank schon mal im Vorraus...
Martin G.

Christopher:
Hallo,

im Verzeichnis bei den Gruppen kann man die Mitgliede sortieren lassen. Das ist aber über Script gelöst.

Über die Formelsprache ist das nict möglich.

Gruß Christopher

wflamme:

--- Zitat von: Christopher am 26.11.02 - 17:44:47 ---Über die Formelsprache ist das nict möglich.

--- Ende Zitat ---

Topic:
Sorting a Text List

Subject:
This formula will sort a text list (without numbers or punctuation).  You can adjust the accuracy from 1 to 10 characters.  This formula is designed to work in a field.  Replace Values with your text list, and change the Accuracy variable to meet your needs.  Long lists work faster with lower accuracy numbers.

Syntax:
Accuracy:=10;
X := Accuracy - 1;
List := @Trim(@UpperCase(Values));
List2 := @Trim(@Implode(List + "Ü"; ""));
List3 := @Implode(@Explode(List2; " "); "Ö");
List4 := @Explode(List3; "Ü") + @Repeat("Ö"; X+1);
A := @Middle(List4; X; 1) + "Ü" + List4;
B := @Trim(@Right(A; "ÖÜ") : @Right(A; "AÜ") : @Right(A; "BÜ") : @Right(A; "CÜ") : @Right(A; "DÜ") : @Right(A; "EÜ") : @Right(A; "FÜ") : @Right(A; "GÜ") : @Right(A; "HÜ") : @Right(A; "IÜ") : @Right(A; "JÜ") : @Right(A; "KÜ") : @Right(A; "LÜ") : @Right(A; "MÜ") : @Right(A; "NÜ") : @Right(A; "OÜ") : @Right(A; "PÜ") : @Right(A; "QÜ") : @Right(A; "RÜ") : @Right(A; "SÜ") : @Right(A; "TÜ") : @Right(A; "UÜ") : @Right(A; "VÜ") : @Right(A; "WÜ") : @Right(A; "XÜ") : @Right(A; "YÜ") : @Right(A; "ZÜ"));
@If(X > 0; @Set("X"; X - 1); @Return(@Replace(@Trim(@Explode(@Implode(@Explode(@Trim(@Implode(B + "Ü"; "")); "Ö"); " "); "Ü")); List; Values)));
@Set("A"; @Middle(B; X; 1) + "Ü" + B);
@Set("B"; @Trim(@Right(A; "ÖÜ") : @Right(A; "AÜ") : @Right(A; "BÜ") : @Right(A; "CÜ") : @Right(A; "DÜ") : @Right(A; "EÜ") : @Right(A; "FÜ") : @Right(A; "GÜ") : @Right(A; "HÜ") : @Right(A; "IÜ") : @Right(A; "JÜ") : @Right(A; "KÜ") : @Right(A; "LÜ") : @Right(A; "MÜ") : @Right(A; "NÜ") : @Right(A; "OÜ") : @Right(A; "PÜ") : @Right(A; "QÜ") : @Right(A; "RÜ") : @Right(A; "SÜ") : @Right(A; "TÜ") : @Right(A; "UÜ") : @Right(A; "VÜ") : @Right(A; "WÜ") : @Right(A; "XÜ") : @Right(A; "YÜ") : @Right(A; "ZÜ")));
@If(X > 0; @Set("X"; X - 1); @Return(@Replace(@Trim(@Explode(@Implode(@Explode(@Trim(@Implode(B + "Ü"; "")); "Ö"); " "); "Ü")); List; Values)));
@Set("A"; @Middle(B; X; 1) + "Ü" + B);
@Set("B"; @Trim(@Right(A; "ÖÜ") : @Right(A; "AÜ") : @Right(A; "BÜ") : @Right(A; "CÜ") : @Right(A; "DÜ") : @Right(A; "EÜ") : @Right(A; "FÜ") : @Right(A; "GÜ") : @Right(A; "HÜ") : @Right(A; "IÜ") : @Right(A; "JÜ") : @Right(A; "KÜ") : @Right(A; "LÜ") : @Right(A; "MÜ") : @Right(A; "NÜ") : @Right(A; "OÜ") : @Right(A; "PÜ") : @Right(A; "QÜ") : @Right(A; "RÜ") : @Right(A; "SÜ") : @Right(A; "TÜ") : @Right(A; "UÜ") : @Right(A; "VÜ") : @Right(A; "WÜ") : @Right(A; "XÜ") : @Right(A; "YÜ") : @Right(A; "ZÜ")));
@If(X > 0; @Set("X"; X - 1); @Return(@Replace(@Trim(@Explode(@Implode(@Explode(@Trim(@Implode(B + "Ü"; "")); "Ö"); " "); "Ü")); List; Values)));
@Set("A"; @Middle(B; X; 1) + "Ü" + B);
@Set("B"; @Trim(@Right(A; "ÖÜ") : @Right(A; "AÜ") : @Right(A; "BÜ") : @Right(A; "CÜ") : @Right(A; "DÜ") : @Right(A; "EÜ") : @Right(A; "FÜ") : @Right(A; "GÜ") : @Right(A; "HÜ") : @Right(A; "IÜ") : @Right(A; "JÜ") : @Right(A; "KÜ") : @Right(A; "LÜ") : @Right(A; "MÜ") : @Right(A; "NÜ") : @Right(A; "OÜ") : @Right(A; "PÜ") : @Right(A; "QÜ") : @Right(A; "RÜ") : @Right(A; "SÜ") : @Right(A; "TÜ") : @Right(A; "UÜ") : @Right(A; "VÜ") : @Right(A; "WÜ") : @Right(A; "XÜ") : @Right(A; "YÜ") : @Right(A; "ZÜ")));
@If(X > 0; @Set("X"; X - 1); @Return(@Replace(@Trim(@Explode(@Implode(@Explode(@Trim(@Implode(B + "Ü"; "")); "Ö"); " "); "Ü")); List; Values)));
@Set("A"; @Middle(B; X; 1) + "Ü" + B);
@Set("B"; @Trim(@Right(A; "ÖÜ") : @Right(A; "AÜ") : @Right(A; "BÜ") : @Right(A; "CÜ") : @Right(A; "DÜ") : @Right(A; "EÜ") : @Right(A; "FÜ") : @Right(A; "GÜ") : @Right(A; "HÜ") : @Right(A; "IÜ") : @Right(A; "JÜ") : @Right(A; "KÜ") : @Right(A; "LÜ") : @Right(A; "MÜ") : @Right(A; "NÜ") : @Right(A; "OÜ") : @Right(A; "PÜ") : @Right(A; "QÜ") : @Right(A; "RÜ") : @Right(A; "SÜ") : @Right(A; "TÜ") : @Right(A; "UÜ") : @Right(A; "VÜ") : @Right(A; "WÜ") : @Right(A; "XÜ") : @Right(A; "YÜ") : @Right(A; "ZÜ")));
@If(X > 0; @Set("X"; X - 1); @Return(@Replace(@Trim(@Explode(@Implode(@Explode(@Trim(@Implode(B + "Ü"; "")); "Ö"); " "); "Ü")); List; Values)));
@Set("A"; @Middle(B; X; 1) + "Ü" + B);
@Set("B"; @Trim(@Right(A; "ÖÜ") : @Right(A; "AÜ") : @Right(A; "BÜ") : @Right(A; "CÜ") : @Right(A; "DÜ") : @Right(A; "EÜ") : @Right(A; "FÜ") : @Right(A; "GÜ") : @Right(A; "HÜ") : @Right(A; "IÜ") : @Right(A; "JÜ") : @Right(A; "KÜ") : @Right(A; "LÜ") : @Right(A; "MÜ") : @Right(A; "NÜ") : @Right(A; "OÜ") : @Right(A; "PÜ") : @Right(A; "QÜ") : @Right(A; "RÜ") : @Right(A; "SÜ") : @Right(A; "TÜ") : @Right(A; "UÜ") : @Right(A; "VÜ") : @Right(A; "WÜ") : @Right(A; "XÜ") : @Right(A; "YÜ") : @Right(A; "ZÜ")));
@If(X > 0; @Set("X"; X - 1); @Return(@Replace(@Trim(@Explode(@Implode(@Explode(@Trim(@Implode(B + "Ü"; "")); "Ö"); " "); "Ü")); List; Values)));
@Set("A"; @Middle(B; X; 1) + "Ü" + B);
@Set("B"; @Trim(@Right(A; "ÖÜ") : @Right(A; "AÜ") : @Right(A; "BÜ") : @Right(A; "CÜ") : @Right(A; "DÜ") : @Right(A; "EÜ") : @Right(A; "FÜ") : @Right(A; "GÜ") : @Right(A; "HÜ") : @Right(A; "IÜ") : @Right(A; "JÜ") : @Right(A; "KÜ") : @Right(A; "LÜ") : @Right(A; "MÜ") : @Right(A; "NÜ") : @Right(A; "OÜ") : @Right(A; "PÜ") : @Right(A; "QÜ") : @Right(A; "RÜ") : @Right(A; "SÜ") : @Right(A; "TÜ") : @Right(A; "UÜ") : @Right(A; "VÜ") : @Right(A; "WÜ") : @Right(A; "XÜ") : @Right(A; "YÜ") : @Right(A; "ZÜ")));
@If(X > 0; @Set("X"; X - 1); @Return(@Replace(@Trim(@Explode(@Implode(@Explode(@Trim(@Implode(B + "Ü"; "")); "Ö"); " "); "Ü")); List; Values)));
@Set("A"; @Middle(B; X; 1) + "Ü" + B);
@Set("B"; @Trim(@Right(A; "ÖÜ") : @Right(A; "AÜ") : @Right(A; "BÜ") : @Right(A; "CÜ") : @Right(A; "DÜ") : @Right(A; "EÜ") : @Right(A; "FÜ") : @Right(A; "GÜ") : @Right(A; "HÜ") : @Right(A; "IÜ") : @Right(A; "JÜ") : @Right(A; "KÜ") : @Right(A; "LÜ") : @Right(A; "MÜ") : @Right(A; "NÜ") : @Right(A; "OÜ") : @Right(A; "PÜ") : @Right(A; "QÜ") : @Right(A; "RÜ") : @Right(A; "SÜ") : @Right(A; "TÜ") : @Right(A; "UÜ") : @Right(A; "VÜ") : @Right(A; "WÜ") : @Right(A; "XÜ") : @Right(A; "YÜ") : @Right(A; "ZÜ")));
@If(X > 0; @Set("X"; X - 1); @Return(@Replace(@Trim(@Explode(@Implode(@Explode(@Trim(@Implode(B + "Ü"; "")); "Ö"); " "); "Ü")); List; Values)));
@Set("A"; @Middle(B; X; 1) + "Ü" + B);
@Set("B"; @Trim(@Right(A; "ÖÜ") : @Right(A; "AÜ") : @Right(A; "BÜ") : @Right(A; "CÜ") : @Right(A; "DÜ") : @Right(A; "EÜ") : @Right(A; "FÜ") : @Right(A; "GÜ") : @Right(A; "HÜ") : @Right(A; "IÜ") : @Right(A; "JÜ") : @Right(A; "KÜ") : @Right(A; "LÜ") : @Right(A; "MÜ") : @Right(A; "NÜ") : @Right(A; "OÜ") : @Right(A; "PÜ") : @Right(A; "QÜ") : @Right(A; "RÜ") : @Right(A; "SÜ") : @Right(A; "TÜ") : @Right(A; "UÜ") : @Right(A; "VÜ") : @Right(A; "WÜ") : @Right(A; "XÜ") : @Right(A; "YÜ") : @Right(A; "ZÜ")));
@If(X > 0; @Set("X"; X - 1); @Return(@Replace(@Trim(@Explode(@Implode(@Explode(@Trim(@Implode(B + "Ü"; "")); "Ö"); " "); "Ü")); List; Values)));
@Set("A"; @Middle(B; X; 1) + "Ü" + B);
@Set("B"; @Trim(@Right(A; "ÖÜ") : @Right(A; "AÜ") : @Right(A; "BÜ") : @Right(A; "CÜ") : @Right(A; "DÜ") : @Right(A; "EÜ") : @Right(A; "FÜ") : @Right(A; "GÜ") : @Right(A; "HÜ") : @Right(A; "IÜ") : @Right(A; "JÜ") : @Right(A; "KÜ") : @Right(A; "LÜ") : @Right(A; "MÜ") : @Right(A; "NÜ") : @Right(A; "OÜ") : @Right(A; "PÜ") : @Right(A; "QÜ") : @Right(A; "RÜ") : @Right(A; "SÜ") : @Right(A; "TÜ") : @Right(A; "UÜ") : @Right(A; "VÜ") : @Right(A; "WÜ") : @Right(A; "XÜ") : @Right(A; "YÜ") : @Right(A; "ZÜ")));
@Replace(@Trim(@Explode(@Implode(@Explode(@Trim(@Implode(B + "Ü"; "")); "Ö"); " "); "Ü")); List; Values)


... sagt jedenfalls meine KnowledgeBase  ;D ;D ;D

Rob Green:
alder, was geht da ab...KRASSSSSSSSSSSSSSSSSSSSS

*nö oder?* 8) 8) 8) 8) 8) 8) 8) 8)


aber hey *scanned fachmännisch die 2 Mio Codezeilen und entdeckt in 0.3 ns den Fehler*, das eine Ü ist falsch, das müßte 3 nach oben 2 nach rechts....ok Spaß bei Seite...

man sollte diese Formel "Rubicks Cube" nennen, angesichts der verdrehten Komplexität

Christopher:
O.K. ich nehme alles zurück  >:( Es ist über die Formelsprache möglich  ;D

Navigation

[0] Themen-Index

[#] Nächste Seite