my fuse blueprint reading csv. trying filter out lines not have text.i.e. line ',' using regex.
code
<choice id="_choice1"> <when id="_when1"> <simple>${body} regex '[a-z].*'</simple> <log id="_log1" message="data --> ${body}"/> </when> <otherwise id="_otherwise1"> <log id="_log2" message="otherwise --> ${body}"/> </otherwise> </choice> data csv below.
textbox1,,,,,,,,,,,,,,,,,,,,,,,,,,, report date 11/05/2016,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,, sitecode,site_description,sitemodulescomplted, ,,,,,,,,,,,,,,,,,,,,,,,,,,, 123,abc,my site, java training, output
info otherwise --> textbox1,,,,,,,,,,,,,,,,,,,,,,,,,,, info otherwise --> report date 11/05/2016,,,,,,,,,,,,,,,,,,,,,,,,,,, info otherwise --> ,,,,,,,,,,,,,,,,,,,,,,,,,,, info otherwise --> sitecode,site_description,sitemodulescomplted, what experiencing lines routed otherwise. not sure have done wrong regex.
if can please help.
your regex [a-z].* means single lowercase character followed characters. none of above matches (because lines text start uppercase characters)
how .*[a-za-z].*?
