Hi, Karen , Thanks for your reply , but there will be only one PAYMENTS....csv file each day, and I would like to get the file name without having the operator choose it. If I could get the name in a var, I could parse the data and capture the date. I did think of the 'loadiflenameplus' option but i'm trying to avoid having operator choose something.. Maybe it's not possible?
Thanks again, Jim On Monday, July 26, 2021, 09:26:23 AM EDT, 'Karen Tellef' via RBASE-L <[email protected]> wrote: Jim: Assuming your user will be selecting the file to process? Use this statement to capture the name of the file into variable vFilename, then parse it like the code in another response. PLUGINS loadfilenameplus.rbl 'vFilename|fullpath on + |TITLE Please selectyour Supplier Invoice Excel file+ |VIEW_MODE Details + |FULLPATH ON + |NO_CHANGE_DIR ON + |INITIAL_DIR x:\docs\supplier recordsand invoices' Karen -----Original Message----- From: 'jim schmitt' via RBASE-L <[email protected]> To: rbase group <[email protected]> Sent: Sun, Jul 25, 2021 9:07 pm Subject: [RBASE-L] - Capture a file Name possible Hello, Group: I have an application where the operator will be receiving a CSV 'payments' file each day and the file has a rather long file name. Sample file name: PAYMENTS_637467300105556434-20210120-030011.csv Notice that the processing date (20210720) is buried inside the file name. Is it possible within RBASE to programmatically capture the file name in a variable so that I can interrogate the variable to obtain the processing date ? Thanks, Jim-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1438844295.721301.1627265246989%40mail.yahoo.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1952665032.1048804.1627305975942%40mail.yahoo.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2127193461.837781.1627314616287%40mail.yahoo.com.
