basis/xmode/modes/csv.xml

   1 <?xml version="1.0"?>\r
   2 \r
   3 <!DOCTYPE MODE SYSTEM "xmode.dtd">\r
   4 \r
   5 <!--\r
   6 \r
   7 Author: Jaco de Groot\r
   8 Version: 2.2 20070213\r
   9 \r
  10 Comma Separated Values specification used for this mode:\r
  11 \r
  12 A file containing table data where the fields are sperated by commas. Fields\r
  13 containing commas (,) or newlines must be quoted (surrounded by quotes (")).\r
  14 Quotes in quoted fields must be escaped with two quotes.\r
  15 \r
  16 Highlighted are:\r
  17 - Even columns\r
  18 - Commas seperating values\r
  19 - Quotes surrounding values\r
  20 - Escaped quotes are highlighted.\r
  21 \r
  22 It is also possible that semicolons are used instead of commas. Therefor the\r
  23 first rules check if the first separator found is a comma or a semicolon and\r
  24 then switch to the comma or semicolon rules.\r
  25 \r
  26 -->\r
  27 \r
  28 <MODE>\r
  29 \r
  30   <!-- Switch rules -->\r
  31 \r
  32   <RULES>\r
  33     <SEQ TYPE="MARKUP" DELEGATE="ODD_QUOTED" AT_LINE_START="TRUE">"</SEQ>\r
  34     <SEQ TYPE="MARKUP" DELEGATE="COMMA_EVEN_QUOTED">,"</SEQ>\r
  35     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_EVEN_QUOTED">;"</SEQ>\r
  36     <EOL_SPAN_REGEXP TYPE="MARKUP" HASH_CHAR="," DELEGATE="COMMA_LAST_COLUMN">,(?=[^,]*$)</EOL_SPAN_REGEXP>\r
  37     <EOL_SPAN_REGEXP TYPE="MARKUP" HASH_CHAR=";" DELEGATE="SEMICOLON_LAST_COLUMN">;(?=[^;]*$)</EOL_SPAN_REGEXP>\r
  38     <SEQ TYPE="MARKUP" DELEGATE="COMMA_EVEN">,</SEQ>\r
  39     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_EVEN">;</SEQ>\r
  40   </RULES>\r
  41 \r
  42   <RULES SET="ODD_QUOTED">\r
  43     <SEQ TYPE="MARKUP" DELEGATE="ODD_QUOTED">""</SEQ>\r
  44     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;" DELEGATE="COMMA_MAIN">"(?=,[^"][^,]*$)</SEQ_REGEXP>\r
  45     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;" DELEGATE="SEMICOLON_MAIN">"(?=;[^"][^;]*$)</SEQ_REGEXP>\r
  46     <SEQ TYPE="MARKUP" DELEGATE="COMMA_EVEN_QUOTED">","</SEQ>\r
  47     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_EVEN_QUOTED">";"</SEQ>\r
  48     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;," DELEGATE="COMMA_MAIN">",$</SEQ_REGEXP>\r
  49     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;;" DELEGATE="SEMICOLON_MAIN">";$</SEQ_REGEXP>\r
  50     <SEQ TYPE="MARKUP" DELEGATE="COMMA_EVEN">",</SEQ>\r
  51     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_EVEN">";</SEQ>\r
  52     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;" DELEGATE="MAIN">"$</SEQ_REGEXP>\r
  53     <SEQ TYPE="MARKUP" DELEGATE="EVEN">"</SEQ>\r
  54   </RULES>\r
  55 \r
  56   <RULES DEFAULT="COMMENT1" SET="EVEN">\r
  57     <SEQ TYPE="MARKUP" DELEGATE="COMMA_ODD_QUOTED">,"</SEQ>\r
  58     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_ODD_QUOTED">;"</SEQ>\r
  59     <SEQ TYPE="MARKUP" DELEGATE="COMMA_MAIN">,</SEQ>\r
  60     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_MAIN">;</SEQ>\r
  61   </RULES>\r
  62 \r
  63   <RULES DEFAULT="COMMENT1" SET="EVEN_QUOTED">\r
  64     <SEQ TYPE="MARKUP" DELEGATE="EVEN_QUOTED">""</SEQ>\r
  65     <SEQ TYPE="MARKUP" DELEGATE="COMMA_ODD_QUOTED">","</SEQ>\r
  66     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_ODD_QUOTED">";"</SEQ>\r
  67     <SEQ TYPE="MARKUP" DELEGATE="COMMA_MAIN">",</SEQ>\r
  68     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_MAIN">";</SEQ>\r
  69     <SEQ TYPE="MARKUP" DELEGATE="MAIN">"</SEQ>\r
  70   </RULES>\r
  71 \r
  72   <!-- Comma rules -->\r
  73 \r
  74   <RULES SET="COMMA_MAIN">\r
  75     <SEQ TYPE="MARKUP" DELEGATE="COMMA_ODD_QUOTED" AT_LINE_START="TRUE">"</SEQ>\r
  76     <SEQ TYPE="MARKUP" DELEGATE="COMMA_EVEN_QUOTED">,"</SEQ>\r
  77     <EOL_SPAN_REGEXP TYPE="MARKUP" HASH_CHAR="," DELEGATE="COMMA_LAST_COLUMN">,(?=[^,]*$)</EOL_SPAN_REGEXP>\r
  78     <SEQ TYPE="MARKUP" DELEGATE="COMMA_EVEN">,</SEQ>\r
  79   </RULES>\r
  80 \r
  81   <RULES SET="COMMA_ODD_QUOTED">\r
  82     <SEQ TYPE="MARKUP" DELEGATE="COMMA_ODD_QUOTED">""</SEQ>\r
  83     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;" DELEGATE="COMMA_MAIN">"(?=,[^"][^,]*$)</SEQ_REGEXP>\r
  84     <SEQ TYPE="MARKUP" DELEGATE="COMMA_EVEN_QUOTED">","</SEQ>\r
  85     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;," DELEGATE="COMMA_MAIN">",$</SEQ_REGEXP>\r
  86     <SEQ TYPE="MARKUP" DELEGATE="COMMA_EVEN">",</SEQ>\r
  87     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;" DELEGATE="COMMA_MAIN">"$</SEQ_REGEXP>\r
  88     <SEQ TYPE="MARKUP" DELEGATE="COMMA_EVEN">"</SEQ>\r
  89   </RULES>\r
  90 \r
  91   <RULES SET="COMMA_EVEN" DEFAULT="COMMENT1">\r
  92     <SEQ TYPE="MARKUP" DELEGATE="COMMA_ODD_QUOTED">,"</SEQ>\r
  93     <SEQ TYPE="MARKUP" DELEGATE="COMMA_MAIN">,</SEQ>\r
  94   </RULES>\r
  95 \r
  96   <RULES SET="COMMA_EVEN_QUOTED" DEFAULT="COMMENT1">\r
  97     <SEQ TYPE="MARKUP" DELEGATE="COMMA_EVEN_QUOTED">""</SEQ>\r
  98     <SEQ TYPE="MARKUP" DELEGATE="COMMA_ODD_QUOTED">","</SEQ>\r
  99     <SEQ TYPE="MARKUP" DELEGATE="COMMA_MAIN">",</SEQ>\r
 100     <SEQ TYPE="MARKUP" DELEGATE="COMMA_MAIN">"</SEQ>\r
 101   </RULES>\r
 102 \r
 103   <RULES SET="COMMA_LAST_COLUMN" DEFAULT="COMMENT1">\r
 104   </RULES>\r
 105 \r
 106   <!-- Semicolon rules -->\r
 107 \r
 108   <RULES SET="SEMICOLON_MAIN">\r
 109     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_ODD_QUOTED" AT_LINE_START="TRUE">"</SEQ>\r
 110     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_EVEN_QUOTED">;"</SEQ>\r
 111     <EOL_SPAN_REGEXP TYPE="MARKUP" HASH_CHAR=";" DELEGATE="SEMICOLON_LAST_COLUMN">;(?=[^;]*$)</EOL_SPAN_REGEXP>\r
 112     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_EVEN">;</SEQ>\r
 113   </RULES>\r
 114 \r
 115   <RULES SET="SEMICOLON_ODD_QUOTED">\r
 116     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_ODD_QUOTED">""</SEQ>\r
 117     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;" DELEGATE="SEMICOLON_MAIN">"(?=;[^"][^;]*$)</SEQ_REGEXP>\r
 118     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_EVEN_QUOTED">";"</SEQ>\r
 119     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;;" DELEGATE="SEMICOLON_MAIN">";$</SEQ_REGEXP>\r
 120     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_EVEN">";</SEQ>\r
 121     <SEQ_REGEXP TYPE="MARKUP" HASH_CHAR="&quot;" DELEGATE="SEMICOLON_MAIN">"$</SEQ_REGEXP>\r
 122     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_EVEN">"</SEQ>\r
 123   </RULES>\r
 124 \r
 125   <RULES SET="SEMICOLON_EVEN" DEFAULT="COMMENT1">\r
 126     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_ODD_QUOTED">;"</SEQ>\r
 127     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_MAIN">;</SEQ>\r
 128   </RULES>\r
 129 \r
 130   <RULES SET="SEMICOLON_EVEN_QUOTED" DEFAULT="COMMENT1">\r
 131     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_EVEN_QUOTED">""</SEQ>\r
 132     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_ODD_QUOTED">";"</SEQ>\r
 133     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_MAIN">";</SEQ>\r
 134     <SEQ TYPE="MARKUP" DELEGATE="SEMICOLON_MAIN">"</SEQ>\r
 135   </RULES>\r
 136 \r
 137   <RULES SET="SEMICOLON_LAST_COLUMN" DEFAULT="COMMENT1">\r
 138   </RULES>\r
 139 \r
 140 </MODE>\r