Regular Expressions

  • When creating conditions Cargo Office offers the possibility to use regular expressions.
  • How to use regular expressions you have to find out yourself at the internet.
  • We don't offer courses, but we hereby give a few examples.
  • If you should want to, we can have our consultants (help you) build regular expressions.

Example: how to select multiple customer ID's

  • One customer ID: {customerID} = 1234
  • Two customer ID's: {customerID} REGEXP ^(1234|12345)$
  • Three customer ID's: {customerID} REGEXP ^(1234|12345|12346)$
  • Note: it's better not to use {customerID} REGEXP 1234|12345|12346 ; this will select 1234 (and 12345 and 12346) inside a customerID name.
  • Note2: it is possible to test multiple fields in one condition. This is useful for goodslines. An example of testing all packing fields for the value 'pallet' would then be: {packing1}{packing2}{packing3}{packing4}{packing5} REGEXP pallet.

Also see: regular expressions, more specific perl compatible regular expressions .


-- RutgerRutgers - 20 Aug 2008

Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r3 - 2015-09-09 - HenkRoelofs
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback