File name

Help Studio
1

I am using an expression to process only specific files form a folder but i want to process only the files which start with PAN_, CHEQUE_, GST_ Can anyone please help me with this?
Below are the screenshots

image
image1366×768 33.5 KB

image
image1366×768 31.4 KB

2

Hi @Seema_Jethe ,

try below code
Directory.GetFiles(@"c:\MyDir", “PAN_", SearchOption.AllDirectories)
Directory.GetFiles(@"c:\MyDir", "CHEQUE_”,SearchOption.AllDirectories)
Directory.GetFiles(@"c:\MyDir", “GST_*”, SearchOption.AllDirectories)

or

Directory.GetFiles("C:\\MyDir", "*.*", SearchOption.AllDirectories)
            .Where(s => s.StartWith("PAN_") || s.StartWith("CHEQUE_") || s.StartWith("GST_"))

Regards,
Arivu

1 Like
3

@arivu96 Can this be used in one expression only?

4

Try this
Directory.GetFiles("C:\\MyDir", "*.*", SearchOption.AllDirectories) .Where(s => s.StartWith("PAN_") || s.StartWith("CHEQUE_") || s.StartWith("GST_"))

Regards,
Arivu

5

@arivu96 i tried using your code but it has some error
below is the ss

image
image1366×768 34.2 KB

6

Hey @Seema_Jethe, Please use that expression in one single line.

7

try this in single line
Directory.GetFiles(“C:\MyDir”, “.”, SearchOption.AllDirectories) .Where(s => s.StartsWith(“PAN_”) || s.StartsWith(“CHEQUE_”) || s.StartsWith(“GST_”))

8

@Seema_Jethe ,

Try this:

Assign Activity:

strArrVariable = Directory.GetFiles(“FolderPath”, “.”, SearchOption.AllDirectories).Where(function(s) path.GetFileName(s).StartsWith(“PAN_”) and path.GetFileName(s).StartsWith(“CHEQUE_”) and path.GetFileName(s).StartsWith(“GST_”) and s.EndsWith(“.pdf”) and s.EndsWith(“.jpg”)).ToArray

Thanks!

9

@arivu96 i have used the expression in single line but it still has error

image
image1366×768 33.1 KB

10

@kadiravan_kalidoss i tried your expression but it does not work i am getting null value in variable using assign activity

11

Hi @Seema_Jethe ,

Can you send the error message.

Regards,
Arivu

12

@arivu96 Below is the ss

image
image1366×768 37.2 KB

13

Hello @arivu96

You used where() function. Is part of a LINQ command ?

Thanks in advance/

14

Try below code
VB.net
Directory.GetFiles("C:MyDir", ".", SearchOption.AllDirectories).Where(Function(s) s.StartsWith("PAN_") OrElse s.StartsWith("CHEQUE_") OrElse s.StartsWith("GST_"))
or
c#
Directory.GetFiles("C:\MyDir", ".", SearchOption.AllDirectories) .Where(s=> s.StartsWith("PAN_") || s.StartsWith("CHEQUE_") || s.StartsWith("GST_"));

Regards,
Arivu

16

@arivu96 I tried your expression but it does not work the variable value is null

18

Hi @Seema_Jethe ,

Try the below expression. it was working at my end. thanks.

Hi,

Try with the below expression. it was working at my end.

image
image1378×156 9.45 KB

Expression.txt (170 Bytes)

2 Likes
19

@kirankumar.mahanthi1 will your expression process the files starting with PAN_ , CHEQUE_, GST_ as i need only the files with names as PAN_xx.pdf or jpg, CHEQUE_xx.pdf or jpg or GST_xx.pdf or jpg and not files like xxx_PAN.pdf or jpg

20

i have tried with few samples only. Could you test with your files in Realtime and let us know. thanks.

21

Hi @Seema_Jethe,

I have modified the condition and tested. Its working as expected. Please try this code below.

StringArrayVariable = Directory.GetFiles(“FolderPath”, “.”, SearchOption.AllDirectories).Where(function(s) (path.GetFileName(s).StartsWith(“PAN_”) or path.GetFileName(s).StartsWith(“CHEQUE_”) or path.GetFileName(s).StartsWith(“GST_”)) and (s.EndsWith(“.pdf”) or s.EndsWith(“.jpg”))).ToArray

Thanks!