akuji_1993

Most beautiful Code ever

Feb 26th, 2013
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.41 KB | None | 0 0
  1.             IF pos(s_alias(pos(s_alias(1,i), ","),i), "Inc.") <= 5 OR pos(s_alias(pos(s_alias(1,i), ","),i), "INC.") <= 5 THEN
  2.                 zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), ".")-1)
  3.                 s_alias(1,i) = s_alias(pos(s_alias(1,i), ".")+1,i;(len(s_alias(1,i))-pos(s_alias(1,i), ".")))
  4.             ELSE
  5.                 IF pos(s_alias(pos(s_alias(1,i), ","),i), "INC") <= 5 THEN
  6.                     zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), "INC")+2)
  7.                     s_alias(1,i) = s_alias(pos(s_alias(1,i), "INC")+4,i;(len(s_alias(1,i))-(pos(s_alias(1,i), "INC"))+3))
  8.                 ELSE
  9.                     IF pos(s_alias(pos(s_alias(1,i), ","),i), "Inc") <= 5 THEN
  10.                         zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), "Inc")+2)
  11.                     s_alias(1,i) = s_alias(pos(s_alias(1,i), "Inc")+4,i;(len(s_alias(1,i))-(pos(s_alias(1,i), "Inc"))+3))
  12.                     ELSE
  13.                
  14.                         IF pos(s_alias(pos(s_alias(1,i), ","),i), "LLC") <= 7 THEN
  15.                             zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), "LLC")+2)
  16.                             s_alias(1,i) = s_alias(pos(s_alias(1,i), "LLC")+4,i;(len(s_alias(1,i))-(pos(s_alias(1,i), "LLC"))+3))                  
  17.                         ELSE
  18.                             zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), ",")-1)
  19.                             |s_alias wird gesetzt ab der Stelle des letzten Kommas + 1 mit der Länge len(s_alias) - den abgeschnittenen Teil
  20.                             s_alias(1,i) = s_alias(pos(s_alias(1,i), ",")+1,i;(len(s_alias(1,i))-pos(s_alias(1,i), ",")))
  21.                         ENDIF
  22.                     ENDIF
  23.                 ENDIF
  24.             ENDIF
Advertisement
Add Comment
Please, Sign In to add comment