Hi I'm reading a text file. In that text file data is like this AB=100 sjdhxajshejhs jasdhrxajsdhx HJ=200 jehxmjehdr djkejhmxdfjhe
And so on. So I want to consider "AB=" as a row separator. But as you can see only "=" is constant and two alpha characters before that are not constant like this AB= and HJ=
Is there any way I could use regex in row separator field like this Regexp("[a-zA-Z]{2}")+"=" I've tried but its not working, Any suggestions please ?
Sure You must look in different direction because Your next question (even if You found solution) - separator will be excluded from data, and You will have - 100, 200 but do not know - what is it
Hi vapukovis I'm using like this http://prnt.sc/d3b862 But getting this error The constructor FileInputDelimited(String, String, String, Pattern, boolean, int, int, int, int, boolean) is undefined
as variant - split to separate files using "=" as filter
do all in loop - split, than process each files in folder as single records
other variant -
replace all \n as "," split row in loop (until not finish) - locate = and take substring up to (index of = -2), cut the string and etc - what more easy depends from feature tasks
