https://community.qlik.com/t5/Data-Quality/tfileInputExcel-reading-all-Sheets-with-certain-word-in-their/m-p/2209359#M1123 <P>Hallo,</P><P>I would like to read (tFileInputExcel) all Sheets with "Bill" in their names. Sheet names looking like this: "Bill 01", "Bill 02",...</P><P>I tried the following:</P><P>tFileInputExcel - Basic Setting</P><P>Sheet list: "Bill (\\d(2))" </P><P>Use Regex (activated)</P><P></P><P></P><P>It doesnt work though. It starts reading from Sheet "Bill 02" and then some other Bill Sheets but not all and I dont know why. Do you have any advice for me please?</P><P>Thank you so much.</P><P>Mara</P> Fri, 15 Nov 2024 22:31:24 GMT Moro 2024-11-15T22:31:24Z https://community.qlik.com/t5/Data-Quality/tfileInputExcel-reading-all-Sheets-with-certain-word-in-their/m-p/2209359#M1123 <P>Hallo,</P><P>I would like to read (tFileInputExcel) all Sheets with "Bill" in their names. Sheet names looking like this: "Bill 01", "Bill 02",...</P><P>I tried the following:</P><P>tFileInputExcel - Basic Setting</P><P>Sheet list: "Bill (\\d(2))" </P><P>Use Regex (activated)</P><P></P><P></P><P>It doesnt work though. It starts reading from Sheet "Bill 02" and then some other Bill Sheets but not all and I dont know why. Do you have any advice for me please?</P><P>Thank you so much.</P><P>Mara</P> Fri, 15 Nov 2024 22:31:24 GMT https://community.qlik.com/t5/Data-Quality/tfileInputExcel-reading-all-Sheets-with-certain-word-in-their/m-p/2209359#M1123 Moro 2024-11-15T22:31:24Z https://community.qlik.com/t5/Data-Quality/tfileInputExcel-reading-all-Sheets-with-certain-word-in-their/m-p/2209360#M1124 <P>Hello,</P><P>Please try the Sheet list : "Bill \\d+" as the below , it should be working</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000WuAwFAAV.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/127865iECDBCACBAB47B326/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000WuAwFAAV.png" alt="0695b00000WuAwFAAV.png" /></span></P> Wed, 28 Sep 2022 02:02:13 GMT https://community.qlik.com/t5/Data-Quality/tfileInputExcel-reading-all-Sheets-with-certain-word-in-their/m-p/2209360#M1124 Anonymous 2022-09-28T02:02:13Z https://community.qlik.com/t5/Data-Quality/tfileInputExcel-reading-all-Sheets-with-certain-word-in-their/m-p/2209361#M1125 <P>perfect! Thank you! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 29 Sep 2022 09:57:53 GMT https://community.qlik.com/t5/Data-Quality/tfileInputExcel-reading-all-Sheets-with-certain-word-in-their/m-p/2209361#M1125 Moro 2022-09-29T09:57:53Z