I am using the fileset-FTP protocol to fltp files from a remote server to the engine. I need to save the name of each file (example: ULGI61_NOTE-INF_2050000066_3000.pdf) into a variable and then split the name of the file with “_” to get a list and query after a database with one value of the list (example: 2050000066 wich is a visit number.
Is there any PROC available on Cloverleaf that can help me ?
Thank you