Talend community forum / Regex

ZeljkaMom · 2011-05-16 15:17:54

Tags: [regex]

Hi,

I am using one Excel document with three different sheets as input file and I would like to read each of this sheet one by one instead of all in one go.

I have tried to use regex and to make filter but not working. (see image below) and I am getting error "Exception in component tFileInputExcel_3
java.lang.RuntimeException: Special sheets not exist!"

is anyone having idea how this can be done.

Thanks
Zeljka

Uploaded Images

emaxt6 · 2011-05-16 16:59:31

How the sheets are named? example?

ZeljkaMom · 2011-05-16 17:05:35

the sheet one is AABB,
the sheet two is ASAD
the sheet three is ASFE

I have created the File Excel metadata

emaxt6 · 2011-05-16 17:17:02

I don't think that the regex is correct...
"(AACF)*" should mean match the group zero or more times.... like AACFAACFAACF....

try to select the sheet by index or simple name

ZeljkaMom · 2011-05-16 18:15:14

I am not sure if I am clear as when I select sheet by name of course I am getting that sheet , I just thought is posible to read each sheets and to chose which one you want ot read e.g. sheet 1, or 2. or 3

shong · 2011-05-17 08:47:05

Hi

I would like to read each of this sheet one by one instead of all in one go.

Why don't you check the 'All sheets' option? what do you mean instead of all in one go?

Best regards
Shong

Announcement

Unanswered posts

#1 2011-05-16 15:17:54

Regex

#2 2011-05-16 16:59:31

Re: Regex

#3 2011-05-16 17:05:35

Re: Regex

#4 2011-05-16 17:17:02

Re: Regex

#5 2011-05-16 18:15:14

Re: Regex

#6 2011-05-17 08:47:05

Re: Regex

Board footer