Question

Calling a file with FTP caller whose name is partly random


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

 

 


2 replies

Badge +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.

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

Reply