Sorry I took it as a file because of the name. š Sent from my iPhone
> On Aug 1, 2018, at 2:42 PM, Claudine Robbins <[email protected]> wrote: > > I havenāt tried based on the input being in a variable and not a file. > > Iāll try and report back. > > Thanks Buddy! > > Sent from my iPhone > > On Aug 1, 2018, at 1:03 PM, Buddy Walker <[email protected]> wrote: > > Claudine > Since you have commas in the file I would think you have to load the table > instead of insert. > > Buddy > > > From: [email protected] <[email protected]> On Behalf Of > Claudine Robbins > Sent: Wednesday, August 1, 2018 1:21 PM > To: [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 [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. > -- > 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. -- 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.
