Skip to main content
  • EN

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

 

 

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


Community Stats

30,179
Posts
114,557
Replies
37,844
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.