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!

  • Congratulations TouchToneTommy 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: *

  1. areotree

    Column into single row comma delimited.

    SantaMufasa, Thank you for the great support.
  2. areotree

    Column into single row comma delimited.

    Yes, so if I understnd it by using the concat we are are lumping all the columns data into one string so if I wanted to use a alias I would just use one alias for the whole concated info.
  3. areotree

    Column into single row comma delimited.

    You are the greatest !!! So it was the aliases that was killing me. Why can't you use aliases with the concat ? Thanks. output: select ft.serial_number||','||ft.state||','||ft.fap_version ||','||sum(case when rf_params_.id = ft.params_1x_fk then channel end) ||','||sum(case when...
  4. areotree

    Column into single row comma delimited.

    I am currently using the query below to pull data from two tables and multiple fields based on a primary key from the first table and two foreign keys in the second and output it to a single row. This working great but the output is spaced out based on column size. I have tried to comma delimit...
  5. areotree

    Display progress in VBS login script

    Give GooeyScript a look see. It lets you create custom forms for VBS scripts. I uploaded the IDE version that allows you to build the code for the form by point, click and drag. You can do custom process bars, buttons, listboxs...ect. Original version...
  6. areotree

    Nortel Passport 15K Data Parser

    '############################################################################ '# PPKParser '# '# ! NO TECHNICAL SUPPORT IMPLIED ! '# '# This stand alone VBS script will parse and ";" delimit a file with the output from '# a Nortel Passport 7K/15K/20K that has been dumped by raw...
  7. areotree

    Question about VBS and RegExp

    Also I changed the code a little bit in the function. It now loads all the files in a dedicated dir. for the capture files. It is posted below is case someone wants it. I put it together from multipliable post on this forum. Thanks Everybody. ==================================== Function...
  8. areotree

    Question about VBS and RegExp

    I tried the "^" at the first of the pattern but for some reason it failed to match any line until I removed it. The "(Len(Trim(varLine)) > 5)" is because I don't want lines with less then 5 char. Is there a way to put that in the RegExp pattern so I don't have to do the "(Len(Trim(varLine)) >...
  9. areotree

    Question about VBS and RegExp

    Hello everybody. I am new to VBS and to using RegExp. I have a collection script that grabs data from a Passport switch into multipliable files. I need to parse the data in the files. I put together a function to do this based on what I have found in this forum and the following link...
  10. areotree

    Script to get and display uptime on Passport 7k & 15K

    Below is a script to display the uptime on a Nortel Passport 7 & 15K Passport. You must be in the OS level before running the script. Enjoy !!!! ;*********************************************************************** ;* *...
  11. areotree

    Revised NORTEL 1XEVDO RNC MONITOR SCRIPT

    I have rewritten the RNC monitor script to give you more control over what you want to collect and monitor. You now get a dialogbox with multiple choices. Some of the choices have alarms, I have placed a "*" beside those. Below are the choices: Display Node Info *** --> Alarms...
  12. areotree

    NORTEL 1XEVDO RNC MONITOR SCRIPT

    RF101, I have modified the script so that now you can choice what data you want to collect and monitor. Below is the list of things you can choose now. I will post the new version as a tip. ================================= I have rewritten the RNC monitor script to give you more control...
  13. areotree

    NORTEL 1XEVDO RNC MONITOR SCRIPT

    ;*********************************************************************** ;* * ;* THIS SCRIPT IS FOR COLLECTING AND MONITORING 1XEVDO RNC DATA. * ;* ! NO TECHNICAL SUPPORT IMPLIED ! * ;*...
  14. areotree

    NORTEL 1XEVDO RNC MONITOR SCRIPT

    No question, Just posted it in case anyone need it.
  15. areotree

    Is there a way to minimize ProComm without minimizing the dialogbox.

    I have posted the full "RNC MONITOR" script in another thread. Below is what I did, luckly the dlgupdate doesn't trigger the when statement. If you could look at the whole script and give me some pointers on what to do better or different. The script runs great but I know it could be better...
  16. areotree

    NORTEL 1XEVDO RNC MONITOR SCRIPT

    ;*********************************************************************** ;* * ;* THIS SCRIPT IS FOR COLLECTING AND MONITORING 1XEVDO RNC DATA. * ;* ! NO TECHNICAL SUPPORT IMPLIED ! * ;*...
  17. areotree

    Is there a way to minimize ProComm without minimizing the dialogbox.

    Hey Knob, I found a way to hide the main window and leave the dialogbox visible using "winhide $PWMAINWIN" and a "when" statement that does a "winshow $PWMAINWIN" when the dialogbox is closed. Thought you might be interested. Thanks for all the great post, You have provide me with a ton of info.
  18. areotree

    Need to have script look at the length of time connected

    Here is one I use, very simple: proc main while 1 waitquiet 18 forever transmit "^M" endwhile endproc
  19. areotree

    Is there a way to minimize ProComm without minimizing the dialogbox.

    Is there a mode or way to minimize the main ProComm window and still keep a dialogbox visible ? I am using a dialogbox as a monitor GUI that is continually being updated and would like to minimize the main window. Thanks.
  20. areotree

    Logging time (timestamp) without transmitting it

    You could do something like the following, this only sends to the terminal window not the remote device and will be captured in the log file. string DateString,TimeString,timestmp proc main ltimestrs $LTIME DateString TimeString ; Now concatenate the capture filename together...

Part and Inventory Search

Back
Top