Hi,

How can I parse the data in a field that is returned from a query?

Basically,

I have a multi-valued field that contains values such as these that are returned from a query:

          "cpe:/o:freebsd:freebsd:1.1.5.1",
          "cpe:/o:freebsd:freebsd:2.2.3",
          "cpe:/o:freebsd:freebsd:2.2.2",
          "cpe:/o:freebsd:freebsd:2.2.5",
          "cpe:/o:freebsd:freebsd:2.2.4",
          "cpe:/o:freebsd:freebsd:2.0.5",
          "cpe:/o:freebsd:freebsd:2.2.6",
          "cpe:/o:freebsd:freebsd:2.1.6.1",
          "cpe:/o:freebsd:freebsd:2.0.1",
          "cpe:/o:freebsd:freebsd:2.2",
          "cpe:/o:freebsd:freebsd:2.0",
          "cpe:/o:openbsd:openbsd:2.3",
          "cpe:/o:freebsd:freebsd:3.0",
          "cpe:/o:freebsd:freebsd:1.1",
          "cpe:/o:freebsd:freebsd:2.1.6",
          "cpe:/o:openbsd:openbsd:2.4",
          "cpe:/o:bsdi:bsd_os:3.1",
          "cpe:/o:freebsd:freebsd:1.0",
          "cpe:/o:freebsd:freebsd:2.1.7",
          "cpe:/o:freebsd:freebsd:1.2",
          "cpe:/o:freebsd:freebsd:2.1.5",
          "cpe:/o:freebsd:freebsd:2.1.7.1"],

And my problem is that I need to strip the cpe:/o part and I also need to tokenize words using the (:) as a separator so that I can then search for "freebsd 1.1" or "openbsd 2.4" or just "freebsd".

Thanks in advance.

Joe

Reply via email to