Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pho01
  • Content: Threads
  • Order by date
  1. pho01

    Excel string extraction

    One column of my spreadsheet, I have this data extracted from a database in this format: Column C1: ["Name","Street Address","City, State Zipcode"] I want to extract Street Address, City, State Zipcode into a different column, N1. How do I do that? Thanks!
  2. pho01

    Sharepoint: How to enable a field when a check box is selected on new item form?

    In Sharepoint, I need modify a new item form of a list to make a field visible/invisible when a check box is selected: For example: There is a checkbox field called "Is XYZ affected?" When a user selects this field, it will make a hidden field visible "Impact details:" If "Is XYZ affected?"...
  3. pho01

    Excel average - calculate average up-to-date, exclude non value fields

    I have data for the whole fiscal year, for example: Nov Dec Jan Feb Mar Apr... 12 Dec, Jan, Feb, Mar and Apr columns have none data, how do i use one formula to calculate the average up to date. For example, average would be 12 for the data above, not 12/12 (whole year) = 1...
  4. pho01

    Excel - Export cells into .txt file

    I have a spreadsheet with thousand of rows. I combine values of all columns of each row into one column K. Now I want to export each row of column K into a text file. For example: Sheet1.Cells(1,"K").value => C:\temp\1.txt Sheet1.Cells(2,"K").value => C:\temp\2.txt Sheet1.Cells(3,"K").value =>...
  5. pho01

    Application-defined or object-defined error

    On my Excel macro, I had: Set r1 = Sheet1.Range(Cells(2, 1), Cells(1000, 3)) Step into the code, it returns error Run-time error '1004': Application-defined or object-defined error Any idea why it is complaining that? FYI: This is regarding to testing the script on the posting...
  6. pho01

    Excel - HLOOKUP on multiple rows. HOW?

    I have a spreadsheet like below. For each month, it has 3 columns, EMEA, NA, and AP. Under those columns, they have several rows as well, like Core Planned, Core Unplanned, Non-core Planned, Non-core Unplanned. We have a whole year data, and i want to create a section that looks up the data...
  7. pho01

    Detect non ascii character

    How do I replace any non ascii characters with a question mark? (?) We have xml interface to submit incidents in, and it doesn't accept any non ascii characters. I want to replace all non ascii chars with a (?) before submitting? Anyone knows the search pattern for non ascii char? or Perl...
    • pho01
    • Thread
    • Replies: 5
    • Forum: Perl
  8. pho01

    Can Businessobject link data from one table to a different table?

    Can Businessobject link data from one table to a different table? just like in Excel? =Sheet2!B9 =B1 etc... Thanks!
  9. pho01

    How to compare dates?

    What is the right format to compare date in BusinessObject, I tried to create a varable, similar to: =If([Currently Open].[Incident Closed Date]>"04/30/2008";"May";"") and =If([Currently Open].[Incident Closed Date >04/30/2008;"May";"") Both failed: The expression/sub-expression at position...
  10. pho01

    Windows command to do 'right click and install'

    Does anybody know a way in Windows to execute this task by using a windows command: right-click on a file and select install. I'm trying to create a bat script to install this driver automatically to multiple machines, if there's a way to perform the install by using a windows command, it...
  11. pho01

    Passing arrayname based on form value selected

    From the codes below, I'm trying to pass the arrayname to the function: if "value1" is selected, then arrvalue1cfgn and arrvalue1cfgv is passed through to the selectChange function: \"arr\" + this.value + \"cfgn\" = arrvalue1cfgn \"arr\" + this.value + \"cfgv\" = arrvalue1cfgv However, this...
  12. pho01

    How to get CPU usage?

    PercentProcessorTime of WMI object can get a CPU usage of a process, however, I need to get the CPU usage of a machine (all processes), how do I alternate the codes below to perform just that? strComputer = "." Set objWMIService = GetObject("winmgmts:" _ &...
  13. pho01

    bat script - remove space in a file

    Does anybody know how to remove space in a file using dos command in a .bat script? Basically the original log file looks like this: 1; 1; 246; 231;master 1; 1; 10; 10;modeldev 1; 1; 180...
  14. pho01

    Modify DBCC SQLPERF (LOGSPACE) to display certain fields

    Running DBCC SQLPERF (LOGSPACE) returns something like Database Name Log Size (MB) Log Space Used (%) Status ----------------------- ------------------------ ------------------------ ----------- Northwind 0.9921875 41.338581 0 msdb 0.7421875 42.763157 0 pubs 0.7421875 51.907894...
  15. pho01

    assign output of a command to a string variable

    How do I assign a multiple line output of a dos command to a string variable? For example: I want to assign the string variable "output" = output of the dos dir command thanks!
  16. pho01

    replace string in dos

    using dos command, how do I replace/delete a character from a string? For example: %strvar%="error found in "prod_4" procedure" how do I remove the " char in the above variable so the variable can become: %strvar%="error found in prod_4 procedure" Thanks, Phuong
  17. pho01

    Calculating Time elapsed

    How to calculate time elapsed in unix shell script assuming I have two variables in time format of yyyymmdd hh:mm:ss for example, i need to calculate the time elapsed of: var1="20061010 12:15:35" var2="20061011 1:15:32" Just want to calculate the time difference betweeb var2 and var1. Thanks!
  18. pho01

    Bat script - how to set a variable = content of the file

    Hi, Does anybody know a way in windows batch script to set a variable = content of a file, or set a variable = output of a command? in unix, i can simply do this: file_content=`cat filename.txt` do you know the equivalent way to do this in windows using the batch script? Thanks!
  19. pho01

    resize the image by selected region

    How do you edit the picture by selecting only certain region for the picture using Adobe photoshop? Thanks!
  20. pho01

    HPUX shell script: how to trim the last character

    in HPUX shell script language, how do I trim the last character of string? For example, i need to capture the value of the string, and at the end it has "^M" (some sort of windows CRLF. I need to trim it out. $ID = "1213234^M" i want to trim it to "1213234" Thanks!

Part and Inventory Search

Back
Top