Actually, since I can capture each file name, there is no need to load a table, LOL.
Claudine From: karentellef via RBASE-L [mailto:[email protected]] Sent: Wednesday, August 01, 2018 3:00 PM To: [email protected] Subject: Re: [RBASE-L] - Picking and Renaming Windows Files Sweet! Karen -----Original Message----- From: Claudine Robbins <[email protected]> To: rbase-l <[email protected]> Sent: Wed, Aug 1, 2018 2:45 pm Subject: RE: [RBASE-L] - Picking and Renaming Windows Files Like a charm. Thank you Karen! [cid:[email protected]] From: karentellef via RBASE-L [mailto:[email protected]<mailto:[email protected]?>] Sent: Wednesday, August 01, 2018 2:12 PM To: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - Picking and Renaming Windows Files Ahh I think I see what you're trying to do. Because you have multiple filenames I think you'd have to strip each one. I haven't tested this code, just winging it, but something like this might work. This would load each filename into the table. The only problem you might have is if the filenames contain spaces. set var vloop int = 1 while 1 = 1 then set var vtext = (ssub(.vfilename,.vloop)) if vtext is null then break endif insert into tfilename (filen) values (.vtext) set var vloop = (.vloop + 1) endwhile Karen -----Original Message----- From: Claudine Robbins <[email protected]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[email protected]>> Sent: Wed, Aug 1, 2018 2:04 pm Subject: RE: [RBASE-L] - Picking and Renaming Windows Files Karen, I tried at least half a dozen combinations including: R>INSERT INTO tfilename SELECT ALL FROM &vfilename -ERROR- Syntax error (2367) And get syntax errors… Claudine From: karentellef via RBASE-L [mailto:[email protected]<mailto:[email protected]?>] Sent: Wednesday, August 01, 2018 1:10 PM To: [email protected]<mailto:[email protected]> Subject: Re: [RBASE-L] - Picking and Renaming Windows Files Claudine: This syntax doesn't look right. Either you would use VALUES or SELECT, but not both INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM &vfilename Karen -----Original Message----- From: Buddy Walker <[email protected]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[email protected]>> Sent: Wed, Aug 1, 2018 1:03 pm Subject: RE: [RBASE-L] - Picking and Renaming Windows Files Claudine Since you have commas in the file I would think you have to load the table instead of insert. Buddy From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Claudine Robbins Sent: Wednesday, August 1, 2018 1:21 PM To: [email protected]<mailto:[email protected]> Subject: [RBASE-L] - Picking and Renaming Windows Files Hi all, I’m trying to capture multiple file names to rename them. The following code gives me the error: “ERROR-Incorrect number of values for this table (118)”. It appears I may need quotes around each value. Any easy way to do this? TIA, Claudine PLUGINS LoadFileNamePlus vFileName + |INITIAL_DIR C:\iex_x\CHRISPREP + |TITLE 'Select file' + |FULLPATH ON + |NO_CHANGE_DIR ON + |FILTER PDF Files (*.PDF)#*.PDF + |HIDE_READ_ONLY ON + |MULTISELECT ON + |SHOW_HIDDEN OFF + |ENABLE_SIZING ON + |VIEW_MODE LIST SET VAR vfilename = ( '('+.vfilename+')' ) SET ERROR MESSAGE 2058 OFF DROP TABLE `tFileName` NOCHECK SET ERROR MESSAGE 2058 ON CREATE TEMP TABLE `tFileName` (`FILEN` TEXT (40)) R>INSERT INTO tfilename (FILEN) VALUES (FILEN) SELECT ALL FROM &vfilename -ERROR- Incorrect number of values for this table ( 118) R>sho v vfilename (C:\IEX_X\CHRISPREP\ACME-54572 05-BU-0702181107AU.pdf,C:\IEX_ X\CHRISPREP\ACME-5457205-07021 81107AU.pdf,C:\IEX_X\CHRISPREP \ACME-5457205-INV-0702181107AU .pdf) -- 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 rbase-<mailto:[email protected]>[email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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 rbase-<mailto:[email protected]>[email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- 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]. For more options, visit https://groups.google.com/d/optout.
