Problem with File path in Read Text File

[trung2403 (Trung Nguyen)]

I had several files in a folder (e.g. ABC_012345_XYZ.xml; ABD_234567_DDD.xml; ABE_543210_ZZZ.xml). A variable (strInput) is the defined number (e.g. 012345; 234567; 543210) where I can type in from Input Dialog activity.

I would like to use Read text file activity to load content of a specific file. So, in the Filename, I put: “"+strInput+"”+".xml"

However, it seems UiPath does not get the file.

Anyone can help with the above issue? Thanks

[supermanPunch (Arpan)]

@trung2403 Are you using the filename in this way :
“ABC_”+strInput+"_XYZ"+".xml"

[lakshman (Ganta lakshman)]

@trung2403

It should be like this:

                                    "*"+strInput+"*"

[karthick]

Is your variable strinput hold value as below ?

strinput = “ABC_012345”

FileName
strInput+"_ZZZ"+".xml"

[trung2403 (Trung Nguyen)]

Hi lakshman,

I tried your approach as below, but it still does not work. Dont know how to fix it.

[trung2403 (Trung Nguyen)]

Hi karthick,

my variable strInput hold value of a number (e.g. 012345). In file name, I tried: “" + strInput + ".xml” but still not work.

[lakshman (Ganta lakshman)]

@trung2403

You can’t pass it to here directly.

1. Use Assign activity and try below expression.

               String requiredFile = Directory.GetFiles("FolderPath", "*"+strInput+"*")(0)
   

2. And then use Read Text File activity and pass requiredFile to it.

[karthick]

If StrInput = ABC_0123456_ZZZ

StrInput+".Xml"

[trung2403 (Trung Nguyen)]

Many thanks lakshman, it works now. I do appreciate your kind support.

[lakshman (Ganta lakshman)]

@trung2403

Glad to help you. Happy Automation

Please close this thread by marking above my post as solution.