topic use regex in row seperator field in Talend Studio

use regex in row seperator field

Anonymous — Fri, 04 Nov 2016 12:30:41 GMT

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 ?

Thanks in advance

Re: use regex in row seperator field

vapukov — Fri, 04 Nov 2016 23:15:28 GMT

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

Re: use regex in row seperator field

Anonymous — Sat, 05 Nov 2016 04:40:49 GMT

Any other suggestion ?

Re: use regex in row seperator field

Anonymous — Sat, 05 Nov 2016 07:52:07 GMT

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

Any idea ?

Re: use regex in row seperator field

vapukov — Sun, 06 Nov 2016 09:47:37 GMT

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