Get all files inside the folder and select the excel file like *cc*.xlsx inside the folder

Get Help & Discuss Process Studio
1

Get all files inside the folder and select the excel file like cc.xlsx inside the folder

  1. Need to check whether folder is present or not - MJS isFolder(InputFolder)
  2. Get all file names inside the folder. - which option need to use
  3. Search and select the file like “Axis CC*.xlsx”. normally avilable “Axis CC 29June2019.xlsx”. next time “Axis CC 30July2019.xlsx” - which option need to use
    How to use regex.
2

Dear Team,

Can you suggest the plugins.

Waiting for your reply…

3

Hi Manikandan,

Please see below reply to your questions:

  1. Get all file names inside the folder. - which option need to use
    Answer- You can use “Get File Names” plugins to get file names inside the folder.

  2. Search and select the file like “Axis CC*.xlsx”. normally available “Axis CC 29June2019.xlsx”. next time “Axis CC 30July2019.xlsx” - which option need to use
    Answer- You can try with a wildcard to select the specific file name from the folder.