Oh, I thought the string was "name .odt", so it's "name " & ".odt".
Jussi On Thu, Apr 4, 2013 at 12:15 AM, rocko <sunblast...@gmail.com> wrote: > I discovered the Trim$ function. :) > So far so good. > > > On 04/03/2013 02:01 PM, rocko wrote: > > Thanks for all you help. > > > > I figured out why it saves as .zip instead of .odt. > > Apparently there a spaces at the end of the names in the database I'm > > using. > > So it looks like this to the Shell: > > name .odt > > with a space before the .odt > > > > So my next question is can I remove the spaces?? > > > > > > > > On 04/03/2013 10:55 AM, Willy Raets wrote: > >> On Wed, 2013-04-03 at 19:36 +0200, Willy Raets wrote: > >>> On Wed, 2013-04-03 at 10:13 -0700, rocko wrote: > >>>> Ok thanks for suggestions. > >>>> > >>>> I'm now having problems with zipping the files. > >>>> I "m naming the files dynamically with the first name of the > >>>> person from my database. > >>>> > >>>> But the zip command sometimes saves the file as a zip not .odt. > >>>> Why it does this I don't know, actually it does this a lot/ > >>>> > >>>> I'm using this as my zip code: > >>>> zip -r " & sFirst & ".odt ." Wait > >>> zip -h2 in a terminal gives you more detailed instructions on use of > >>> zip > >>> > >>> zip -r NameOfZipFile FileOrFolderToAdd > >>> > >>> NameOfZipFile in your case is sFirst & ".odt" > >>> FileOrFolderToAdd is the place you unzipped the original .odt to and > >>> where you replaces some content. > >>> > >>> ------------------ > >>> Dim sCommand, sPath As String > >>> sPath = User.Home & "place you unzipped and modified the content of > >>> odt" > >>> sCommand = "zip -r " & sFirst & ".odt " & sPath > >>> Shell sCommand > >>> ------------------ > >>> > >>> Watch the spaces in the strings as they are important!! > >>> > >> Some hints: > >> 1. For command always try --help 0r -h and study the command before > >> coding. We have to do the same to help you. Bit strange don you think > >> 2. Always try running your planned command in a terminal before coding > >> in Gambas > >> 3. Study Gambas documentation on what to use best for getting the job > >> done. Read every word over and over as every detail is important. > >> 4. When testing in Gambas add a Print sCommand before Shell sCommand so > >> that when running you see the string in the console of IDE. > >> 5. If command doesn't work from Gambas try Copy/paste that string in > >> Gambas IDE console to a terminal and try it there. If it doesn't work > >> there, it will never work in Gambas, so back to terminal testing, > >> adapting your sCommand and test app again. > >> > >> Keep doing this until it works..mind the details!! > >> > >> Good luck.. > > > > > > ------------------------------------------------------------------------------ > Minimize network downtime and maximize team effectiveness. > Reduce network management and security costs.Learn how to hire > the most talented Cisco Certified professionals. Visit the > Employer Resources Portal > http://www.cisco.com/web/learning/employer_resources/index.html > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ Minimize network downtime and maximize team effectiveness. Reduce network management and security costs.Learn how to hire the most talented Cisco Certified professionals. Visit the Employer Resources Portal http://www.cisco.com/web/learning/employer_resources/index.html _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
