One way is to use the set command to parse the string where each segment is set to one of the command line variables and the total number of variables is $#Warning: I haven't tested it, but you might have a problem if you have 10 or greater variables.Let me know if you have any questions:#!/bin/kshRead more
One way is to use the set command to parse the string where each segment is set to one of the command line variables and the total number of variables is $#
Warning: I haven’t tested it, but you might have a problem if you have 10 or greater variables.
Let me know if you have any questions:
#!/bin/ksh
str="abc_def_ghg_hij"
set $(IFS="_"; echo $str)
###echo $# # number of variables should be 4
nv=$#
# create var1 to var4
i=1
while (($i <= $nv))
do
eval var$i=\$$i
((i+=1))
done
#echo $var1
# display variables var1 to var4
h=1
while (($h <= $nv))
do
eval echo "\$var$h"
((h+=1))
done
You put the CD in the drive & start the comp, if the bios is set to boot from CD first, it will start the recovery.How to use the compaq recovery CD.http://moourl.com/jpkq3
You put the CD in the drive & start the comp, if the bios is set to boot from CD first, it will start the recovery.
You can enter whatever you want without embracing with double quotes (even a sequence of spaces); the issue variable is completed by pressing the Enter key, i.e.This string will be stored into ISSUE - - The above too (- just to mark the beginning and the end).So i can't understand your post and I reRead more
You can enter whatever you want without embracing with double quotes (even a sequence of spaces); the issue variable is completed by pressing the Enter key, i.e.
This string will be stored into ISSUE
- -
The above too (- just to mark the beginning and the end).
So i can’t understand your post and I repeat you MUST use double quotes inside an IF statement to compare strings with blanks.
Well, a tad more information, for one, especially when dealing with a dinosaur like COBOL. (Maybe it has evolved.. my last contact was 30 years ago. I surely did not like it then!) There may be ways to work around whatever error that is ("error 114, signal 11") such as reformatting or reconfiguringRead more
Well, a tad more information, for one, especially when dealing with a dinosaur like COBOL. (Maybe it has evolved.. my last contact was 30 years ago. I surely did not like it then!) There may be ways to work around whatever error that is (“error 114, signal 11”) such as reformatting or reconfiguring data, but the information deficiency of your post leaves any creative solutions sitting on the fence.
If you need files in sub-directories (as you mention "all files from my ftp server", not "all files in a given directory/folder") you need a tool similar to (or exactly) like this http://users.ugent.be/~bpuype/wget/ (which is a windows FTP command line tool that can handle subdirectories easily)Don'Read more
If you need files in sub-directories (as you mention “all files from my ftp server”, not “all files in a given directory/folder”) you need a tool similar to (or exactly) like this http://users.ugent.be/~bpuype/wget/ (which is a windows FTP command line tool that can handle subdirectories easily)
Don’t know about changing permissions, FTP is not aimed at that goal, BUT, by means of using GET and PUT, maybe you can (re)set permissions in a particular way. The CHMOD commands can only be run in TELNET, not FTP … or somebody may have thought about that, and written an FTP tool with that feature …
Entirely off topic, but I find vbindent.com invaluable when reading vb* here.Private Sub Worksheet_SelectionChange(ByVal Target As Range) ' The code below copies any row with column "B" containing the "Completed" ' to the "Completed Tasks" sheet. Set t = Sheets("Tasks") Set c = Sheets("Completed TasRead more
Entirely off topic, but I find vbindent.com invaluable when reading vb* here.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
' The code below copies any row with column "B" containing the "Completed"
' to the "Completed Tasks" sheet.
Set t = Sheets("Tasks")
Set c = Sheets("Completed Tasks")
Dim d
Dim j
d = 1
j = 2
Do Until IsEmpty(t.Range("B" & j))
If t.Range("B" & j) = "Completed" Then
d = d + 1
c.Rows(d).Value = t.Rows(j).Value
Selection.Insert Shift:=xlDown
End If
j = j + 1
Loop
End Sub
re: "=AVERAGE(Sheets(2).Range(C2:C499))"In this case you need to "mix your metaphors" so to speak.Anything you put inside the quotes will be treated by VBA as a text string and, as you have seen, will be placed in the cell letter for letter.If you want VBA to evaluate something and then build an ExcRead more
re: “=AVERAGE(Sheets(2).Range(C2:C499))”
In this case you need to “mix your metaphors” so to speak.
Anything you put inside the quotes will be treated by VBA as a text string and, as you have seen, will be placed in the cell letter for letter.
If you want VBA to evaluate something and then build an Excel formula with the result, you need to remove the “evaluation” from inside the quotes so that VBA can work on it. You have to keep flipping your brain back and forth between the syntax that Excel is going to need and the syntax that VBA needs to perform its work.
In addition, since you are supplying a specific range (C2:C499) you need to use .Formula not .FormulaR1C1 (Try my solution both ways and see what happens)
Finally, rarely do you have to Select an object within VBA to perform an operation on it. Doing that slows the code down and makes it very inefficient. VBA can typically work with an object without it being Selected or Active.
Assuming Excel 2007 or later, try this:1 - Click on the View tab, then chose Page Layout on the left hand side of the ribbon. Do not use the Page Layout tab, use the View tab and then the Page Layout view.2 - Click the little box with the triangle above the row numbers to select all cells.3 - RightRead more
Assuming Excel 2007 or later, try this:
1 – Click on the View tab, then chose Page Layout on the left hand side of the ribbon. Do not use the Page Layout tab, use the View tab and then the Page Layout view.
2 – Click the little box with the triangle above the row numbers to select all cells.
3 – Right click on a Column Letter, choose Column width and enter .5″ in the input field.
4 – Right click on a Row Number, choose Row height and enter .5″ in the input field.
What Office version are you using and is it Microsoft or an alternative?Early versions of Office do not open pptx (compressed) files and there is no way you can stitch up the file to allow this.You could always put the file on an upload website and let us know the URL they give you. Here is one youRead more
What Office version are you using and is it Microsoft or an alternative?
Early versions of Office do not open pptx (compressed) files and there is no way you can stitch up the file to allow this.
You could always put the file on an upload website and let us know the URL they give you. Here is one you don’t have to sign up to: http://www.zippyshare.com/ EDIT: Seems the above has stopped working. You could try this instead, although I’ve not used it myself: http://www.tinyupload.com/
Always pop back and let us know the outcome – thanks
Solved How To Find Character Position In String Using Unix.
One way is to use the set command to parse the string where each segment is set to one of the command line variables and the total number of variables is $#Warning: I haven't tested it, but you might have a problem if you have 10 or greater variables.Let me know if you have any questions:#!/bin/kshRead more
Warning: I haven’t tested it, but you might have a problem if you have 10 or greater variables.
Let me know if you have any questions:
Bypass Compaq Armada Laptop BIOS Password
You put the CD in the drive & start the comp, if the bios is set to boot from CD first, it will start the recovery.How to use the compaq recovery CD.http://moourl.com/jpkq3
You put the CD in the drive & start the comp, if the bios is set to boot from CD first, it will start the recovery.
How to use the compaq recovery CD.
http://moourl.com/jpkq3
How To Have User Input String With Spaces?
You can enter whatever you want without embracing with double quotes (even a sequence of spaces); the issue variable is completed by pressing the Enter key, i.e.This string will be stored into ISSUE - - The above too (- just to mark the beginning and the end).So i can't understand your post and I reRead more
The above too (- just to mark the beginning and the end).
So i can’t understand your post and I repeat you MUST use double quotes inside an IF statement to compare strings with blanks.
Creating VBS With Batch File
the ampersands are ampersanding. You'll need to escapethem:ECHO WshShell.Run chr(34) ^& "C:\sandbox\test.bat" ^& Chr(34), 0 >> vbs.vbs
them:
ECHO WshShell.Run chr(34) ^& “C:\sandbox\test.bat” ^& Chr(34), 0 >> vbs.vbs
COBOL Error 114, Signal 11
Well, a tad more information, for one, especially when dealing with a dinosaur like COBOL. (Maybe it has evolved.. my last contact was 30 years ago. I surely did not like it then!) There may be ways to work around whatever error that is ("error 114, signal 11") such as reformatting or reconfiguringRead more
Batch File To Download From Ftp By File Type
If you need files in sub-directories (as you mention "all files from my ftp server", not "all files in a given directory/folder") you need a tool similar to (or exactly) like this http://users.ugent.be/~bpuype/wget/ (which is a windows FTP command line tool that can handle subdirectories easily)Don'Read more
If you need files in sub-directories (as you mention “all files from my ftp server”, not “all files in a given directory/folder”) you need a tool similar to (or exactly) like this http://users.ugent.be/~bpuype/wget/ (which is a windows FTP command line tool that can handle subdirectories easily)
Don’t know about changing permissions, FTP is not aimed at that goal, BUT, by means of using GET and PUT, maybe you can (re)set permissions in a particular way. The CHMOD commands can only be run in TELNET, not FTP … or somebody may have thought about that, and written an FTP tool with that feature …
Inserting Row Into Another Sheet VBA
Entirely off topic, but I find vbindent.com invaluable when reading vb* here.Private Sub Worksheet_SelectionChange(ByVal Target As Range) ' The code below copies any row with column "B" containing the "Completed" ' to the "Completed Tasks" sheet. Set t = Sheets("Tasks") Set c = Sheets("Completed TasRead more
Private Sub Worksheet_SelectionChange(ByVal Target As Range) ' The code below copies any row with column "B" containing the "Completed" ' to the "Completed Tasks" sheet. Set t = Sheets("Tasks") Set c = Sheets("Completed Tasks") Dim d Dim j d = 1 j = 2 Do Until IsEmpty(t.Range("B" & j)) If t.Range("B" & j) = "Completed" Then d = d + 1 c.Rows(d).Value = t.Rows(j).Value Selection.Insert Shift:=xlDown End If j = j + 1 Loop End SubHow To Ask Questions The Smart Way
EDIT: ↓ ↓ ↓ You’re such an optimist, DerbyDad03. ↓ ↓ ↓
Excel Reference 2nd Sheet Without The Name
re: "=AVERAGE(Sheets(2).Range(C2:C499))"In this case you need to "mix your metaphors" so to speak.Anything you put inside the quotes will be treated by VBA as a text string and, as you have seen, will be placed in the cell letter for letter.If you want VBA to evaluate something and then build an ExcRead more
In this case you need to “mix your metaphors” so to speak.
Anything you put inside the quotes will be treated by VBA as a text string and, as you have seen, will be placed in the cell letter for letter.
If you want VBA to evaluate something and then build an Excel formula with the result, you need to remove the “evaluation” from inside the quotes so that VBA can work on it. You have to keep flipping your brain back and forth between the syntax that Excel is going to need and the syntax that VBA needs to perform its work.
In addition, since you are supplying a specific range (C2:C499) you need to use .Formula not .FormulaR1C1 (Try my solution both ways and see what happens)
Finally, rarely do you have to Select an object within VBA to perform an operation on it. Doing that slows the code down and makes it very inefficient. VBA can typically work with an object without it being Selected or Active.
Try this:
Sheets(1).Range("C5").Formula = "=AVERAGE(" & Sheets(2).Name & "!C2:C499)"Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
Solved Excel Question: How Many Pixels Are There In ½ Square Inch?
Assuming Excel 2007 or later, try this:1 - Click on the View tab, then chose Page Layout on the left hand side of the ribbon. Do not use the Page Layout tab, use the View tab and then the Page Layout view.2 - Click the little box with the triangle above the row numbers to select all cells.3 - RightRead more
1 – Click on the View tab, then chose Page Layout on the left hand side of the ribbon. Do not use the Page Layout tab, use the View tab and then the Page Layout view.
2 – Click the little box with the triangle above the row numbers to select all cells.
3 – Right click on a Column Letter, choose Column width and enter .5″ in the input field.
4 – Right click on a Row Number, choose Row height and enter .5″ in the input field.
Each cell should now be .5″ x .5″.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
message edited by DerbyDad03
Solved Can Anyone Help Me Open This PowerPoint File (Pptx)?
What Office version are you using and is it Microsoft or an alternative?Early versions of Office do not open pptx (compressed) files and there is no way you can stitch up the file to allow this.You could always put the file on an upload website and let us know the URL they give you. Here is one youRead more
Early versions of Office do not open pptx (compressed) files and there is no way you can stitch up the file to allow this.
You could always put the file on an upload website and let us know the URL they give you. Here is one you don’t have to sign up to:
http://www.zippyshare.com/
EDIT:
Seems the above has stopped working. You could try this instead, although I’ve not used it myself:
http://www.tinyupload.com/
Always pop back and let us know the outcome – thanks
message edited by Derek