hiteksoftware.com

[PHF]

Hi,

from a FTP server, I receive files named :

PS_485_CANCAD.csv
or
PT_245_TRANSD.csv

I need to copy the first file in a subfolder named "485"
and the second in a subfolder "245"
(these two subfolders always exist before copying and present in the same main folder).

Can someone help me ?

Thx

(I'm using Automize Pro 7.32)

[melvin]

can you hardcode in 485 or 245 into a file monitor task?

if yes, then use one file monitor task and check for the '485' in the filename. if it passes this check, run a copy task to move it into the 485 subfolder.

similarly for the 245 filename.


However, if the filename is PS_AAA_CANCAD.csv where AAA continuously varies, then you have to use a Script task to detect AAA and transfer the file to the appropriate AAA folder. is this the case?

[PHF]

Melvin,

This is the case, AAA varies every week.
Can you tell me where I can find samples of script task to do that ?

Thx

[Robert]

there are script examples via the script task interface. We will write a simple script out here to trim the variable next week. remind us if we forget.

[PHF]

Hi all,


I've found what i needed.
I created a VBScript using a split command to separate different part of filename (with "_" character). then, I build the destination path with all parts extracted.

thanx