Forum Discussion

richie's avatar
richie
Community Hero
9 years ago

Extract Specific Value from nonXML datafile to provide JDBC request with query filter value

Hi,   This is very similar to a previous post I submitted and nmrao and Radford really helped me out, but now instead of XML, my testdata files are | delimited text files.   I need to parse a tes...
groovyguy's avatar
groovyguy
Community Hero
9 years ago

The first thought that comes to mind is a Datasource, if you can customize delimiters for that. Barring that, my next recommendation is writing a custom groovy script to pull in the data. You could likely build a 2D collection for harvesting, and tokenize based off of your delimiter. Hopefully that helps.

richie's avatar
richie
Community Hero
9 years ago

hahaha!

 

groovyguy wrote:

The first thought that comes to mind is a Datasource, if you can customize delimiters for that. Barring that, my next recommendation is writing a custom groovy script to pull in the data. You could likely build a 2D collection for harvesting, and tokenize based off of your delimiter. Hopefully that helps.

 

Erm.....I appreciate your response but I barely understand your answer - never mind put it into practice!

 

Think I need to do some more reading before I come back to your answer,

 

Thanks anyway!

 

richie

  • groovyguy's avatar
    groovyguy
    Community Hero
    9 years ago

    richie: Once I get a chance to get to my desk later today, I can mock up a groovy script that could import the example data file you provided. That might give you somewhere to start.