akuji_1993

Monstercode of Monsters

Feb 27th, 2013
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.24 KB | None | 0 0
  1. |***ROUTINE zum Auslesen des Alias***|
  2. |Der letzte Eintrag des letzten Feldes wird immer mit angehängt
  3. |Dieses ist entweder leer oder birgt den ersten Teil eines
  4. |unvollständigen Namens.
  5.  
  6. |Im IF - Fall werden Fälle abgefangen, bei denen sich folgende Situation ergibt:
  7. |SOME Fancy Companyname, Inc.
  8. |Statt nur bis zum Komma, wird der Inc. - Name IN den gleichen Aliasnamen mit
  9. |implementiert und dementsprechend auch aus dem Aliasarray entfernt.
  10. solved = (FALSE)
  11. kommaposition = 0
  12.  
  13. IF TRIM$(s_class) <> "Individual" AND NOT isspace(TRIM$(s_class)) AND pos(s_alias(1,i),",") <> 0 THEN
  14.         kommaposition = pos(s_alias(1,i), ",")
  15.        
  16.         IF pos(s_alias(kommaposition,i), "Inc.") <= 5 AND (pos(s_alias(kommaposition,i), "Inc.") > 0) AND solved = (FALSE) THEN
  17.             zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), "."))
  18.             s_alias(1,i) = s_alias(pos(s_alias(1,i), ".")+2,i)
  19.             solved = (TRUE)
  20.         ENDIF
  21.         IF pos(s_alias(kommaposition,i), "INC.") <= 5 AND (pos(s_alias(kommaposition,i), "INC.") > 0) AND solved = (FALSE) THEN
  22.             zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), ".")-1)
  23.             s_alias(1,i) = s_alias(pos(s_alias(1,i), ".")+2,i)
  24.             solved = (TRUE)
  25.         ENDIF
  26.         IF pos(s_alias(kommaposition,i), "INC") <= 5 AND (pos(s_alias(kommaposition,i), "INC") > 0) AND solved = (FALSE) THEN
  27.             zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), "INC")+2)
  28.             s_alias(1,i) = s_alias(pos(s_alias(1,i), "INC")+4,i)
  29.             solved = (TRUE)
  30.         ENDIF
  31.         IF pos(s_alias(kommaposition,i), "Inc") <= 5 AND (pos(s_alias(kommaposition,i), "Inc") > 0) AND solved = (FALSE) THEN
  32.             zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), "Inc")+2)
  33.             s_alias(1,i) = s_alias(pos(s_alias(1,i), "Inc")+4,i)
  34.             solved = (TRUE)
  35.         ENDIF
  36.         IF pos(s_alias(kommaposition,i), "LLC,") <= 7 AND (pos(s_alias(kommaposition,i), "LLC") > 0) AND solved = (FALSE) THEN
  37.             zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), "LLC")+2)                
  38.             s_alias(1,i) = s_alias(pos(s_alias(1,i), "LLC")+4,i)
  39.             solved = (TRUE)
  40.         ENDIF
  41.         IF pos(s_alias(kommaposition,i), "Co., Ltd.") <= 7 AND (pos(s_alias(kommaposition,i), "Co., Ltd.") > 0) AND solved = (FALSE) THEN
  42.             zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), "Co., Ltd.")+8)
  43.             s_alias(1,i) = s_alias(pos(s_alias(1,i), "Co., Ltd.")+10,i)
  44.             solved = (TRUE)
  45.         ENDIF
  46.         IF pos(s_alias(kommaposition,i), "CO., LTD.") <= 7 AND (pos(s_alias(kommaposition,i), "CO., LTD.") > 0) AND solved = (FALSE) THEN
  47.             zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), "CO., LTD.")+8)
  48.             s_alias(1,i) = s_alias(pos(s_alias(1,i), "CO., LTD.")+10,i)
  49.             solved = (TRUE)
  50.         ENDIF
  51.  
  52.         IF solved = (FALSE) THEN
  53.             zpsam100.cref = lastentry & s_alias(1,i;kommaposition-1)
  54.             |s_alias wird gesetzt ab der Stelle des letzten Kommas + 1 mit der Länge len(s_alias) - den abgeschnittenen Teil
  55.             s_alias(1,i) = s_alias(kommaposition+1,i;(len(s_alias(1,i))-kommaposition))
  56.             solved = (TRUE)
  57.         ENDIF
  58.    
  59. ELSE
  60.     zpsam100.cref = lastentry & s_alias(1,i;pos(s_alias(1,i), ",")-1)
  61.     |s_alias wird gesetzt ab der Stelle des letzten Kommas + 1 mit der Länge len(s_alias) - den abgeschnittenen Teil
  62.     s_alias(1,i) = s_alias(pos(s_alias(1,i), ",")+1,i;(len(s_alias(1,i))-pos(s_alias(1,i), ",")))
  63.     solved = (TRUE)
  64. ENDIF
  65. |***Ende ROUTINE***|
Advertisement
Add Comment
Please, Sign In to add comment