Skip to main content
Question

Calling a file with FTP caller whose name is partly random


lhuerta

Hello,

I am using FTP Caller to call a file with a name like this:

   A-IPE_810704320_NATH_PM_IPEZMD_V31_@Value(_timestamp)_27.csv

My problem is that the last two digits (here 27) are random...

So I tried to replace the last two characters, like this:

   A-IPE_810704320_NATH_PM_IPEZMD_V31_@Value(_timestamp)_??.csv

   A-IPE_810704320_NATH_PM_IPEZMD_V31_@Value(_timestamp)_*

But it doesn't work and it returns an error.

I know I can list all the FTP files in an attribute and then search for the right file with "String Seracher" but I thought it might be easier!

PS: The @Value(_timestamp) part works correctly and returns the date in the format used in the file naming.

 

Thanks in advance

 

 

chrisatsafe
Contributor
Forum|alt.badge.img+2

Hi @lhuerta​ ,

When you say partly random, is there some sort of pattern to the randomness? While the FTPCaller does not support wildcards, you could try creating an attribute with the "random number" if it is somewhat predictable or even if it's iterative.

 

Otherwise, yes I believe the best option would be to get a list of the files then use the StringSearcher method.


lhuerta

Hello, thank you for your answer.

yes the number is completely random.

 

And since the ftp caller does not support wildcards...

I just have to use lists and variables!

Thanks to you


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings