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...
nmrao's avatar
nmrao
Community Hero
9 years ago

You should be able to get it from this thread. Only thing is to change the separator and take only what you need:

 

def lines = new File('data.txt').readLines()
lines.eachWithIndex { line, index ->
    if (index) {
    	def data = line.split('\\|')*.trim()
	log.info data[0]            	   
    }	    	
}