Need to split the value and pick the same file from folder

[Rajnish_Arora]

Hello Team,

I have some words which i need to split
"B.Com Certificate / NIIT Limited Experience Letter / NIIT Limited Offer Letter / INTER MarkList "
also i have to pick the same file from folder is anyone help me…

Thanks
Rajnish

[muhammedyuzuak]

Hi @Rajnish_Arora,

First of all, you can split your data with split. You can check for files for each directory using for.

fileArray [str][str] = yourValue.Split(“/“c)
Directory.GetFiles(filePath,item.ToString+”*”)(0)

[Rajnish_Arora]

Hi @muhammedyuzuak
Thanks you for the help but its giving error "Path Exists: Index was outside the bounds of the array’'…

[muhammedyuzuak]

Can you update the fields like this.

yourValue.Split(“/”.ToArray,StringSplitOptions.RemoveEmptyEntries)
Directory.GetFiles(filePath,item.TrimStart.TrimEnd+”*")(0)

Regards,
MY

[supermanPunch (Arpan)]

@Rajnish_Arora

"B.Com Certificate / NIIT Limited Experience Letter / NIIT Limited Offer Letter / INTER MarkList "

Hi @Rajnish_Arora ,

Assuming we have the string data in a string variable like below :

InputStr = "B.Com Certificate / NIIT Limited Experience Letter / NIIT Limited Offer Letter / INTER MarkList "

Maybe we could try with the Below Steps and Check :

1. Using an Assign Activity, Split the String/Text data based on / assuming that is the delimiter.

fileNamesArray = Split(InputStr,"/").ToArray

Here fileNamesArray is a variable of Type Array of String.

2. Next, we find the files from the Folder specified which contains this list of words in their file names like below :

fileList = Directory.GetFiles("YourFolderPath").Where(Function(x)fileNamesArray.Any(Function(y)y.Trim.ToLower.Contains(Path.GetFileNameWithoutExtension(x).ToString.ToLower.Trim))).ToArray

Here, fileList is a variable of Type Array of String. It contains list of file paths matching the Input String Data provided.

Let us know if this doesn’t work.

[Rajnish_Arora]

Hi @muhammedyuzuak

Its working fine but we are facing one issue sometime we are getting pdf and jpg files so how we can make it dynamic so it can take any extension. On attached snip its taking jpg file.

[muhammedyuzuak]

This way you can update.

Directory.GetFiles(filePath,item.TrimStart.TrimEnd+”*")

Regards,
MY