Read Text File ,File Name + Dynamic Date

[RajeshT (Rajesh)]

Hi Team,

I want to read text file,and path of text file is File Name+any date,if path of file name matches consider that as file .
Example as below:
***AGENT_DETAILS_***20190914.txt

If it matches AGENT_DETAILS_,then consider this is path of file.

[RajeshT (Rajesh)]

Team,can any one can help here
Tried with above code,still getting error in Read Text File activity

[kalyanDev]

When you are using the Directory.getfiles you will list of .txt files available in that folder once you got that you for each to loop all and then check the condition in that .txt file contains AGENT_DETAILS this or if yes then read.

[lakshman (Ganta lakshman)]

@RajeshT

Do you mean you want to read all text files from particular folder whose name starts with AGENT_DETAILS_ right ?

If yes then try below expression.

  txtFiles [] = Directory.GetFiles("FolderPath","AGENT_DETAILS_*")

[RajeshT (Rajesh)]

Hi @lakshman,

Yes, I want to read text file from particular folder name starts with AGENT_DETAILS_
May i know which variable type we need to give for txtFiles

[lakshman (Ganta lakshman)]

@RajeshT

It should be of type Array of string

[RajeshT (Rajesh)]

I have changed to array of string ,and Read Text File only allows string how we need to convert string of array to string

[RajeshT (Rajesh)]

Hi @lakshman ,

Please help here this will be my last step to read text file

[lakshman (Ganta lakshman)]

@RajeshT

After that assign activity, you have to use ForEach loop to iterate that array if string and inside this loop use Read Text file activity.

         ForEach item in txtFiles
             Pass item to Read Text file activity

[RajeshT (Rajesh)]

Hi @lakshman ,

I hope this is correct

[lakshman (Ganta lakshman)]

@RajeshT

In Read Text file activity, just specify item only and no need to convert it to string.

Change Type argument from object to string in ForEach loop activity properties.

[RajeshT (Rajesh)]

Thank you @lakshman. Made the changes !