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 Chris Miller 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: PHV
  • Order by date
  1. PHV

    Removing non-ascii from large .txt file

    { gsub(/[^ -~]/,"",$0)[!];print[/!] } Hope This Helps, PH. FAQ219-2884 FAQ181-2886
    • PHV
    • Post #4
    • Forum: AWK
  2. PHV

    Removing non-ascii from large .txt file

    Something like this ? gsub(/[^ -~]/,"",$0) Hope This Helps, PH. FAQ219-2884 FAQ181-2886
    • PHV
    • Post #2
    • Forum: AWK
  3. PHV

    Excel date format changes from userform to worksheet

    Why not change the NumberFormat property of the cell ? Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  4. PHV

    something wrong in the AWK code...

    Anyway this line if ( $1=="FPV" ) is never reached. Hope This Helps, PH. FAQ219-2884 FAQ181-2886
    • PHV
    • Post #3
    • Forum: AWK
  5. PHV

    Create multiple word Documents and email all attachments

    Put WdAppOpen.Quit outside the Loop. Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  6. PHV

    Attachments

    Something like this ? ... StartDate = DateSerial(Year(Now()),Month(Now())-1,2) EndDate = DateSerial(Year(Now()),Month(Now()),2) ... If StartDate <= objFile.DateLastModified and EndDate > objFile.DateLastModified Then ... Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  7. PHV

    Help needed with a tricky UPDATE

    Perhaps this ? UPDATE tblTEST2 SET Val2 = -DLookUp('Val1','tblTEST2','Row=' & Row & ' AND Val2=' & Val1) WHERE Val2 = 0 Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  8. PHV

    Move certain extensions to another folder

    i duno where to start Have a look at FileSystemObject Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  9. PHV

    Help needed with a tricky UPDATE

    Something like this ? UPDATE tblTEST A SET Val2=-(SELECT B.Val1 FROM tblTEST B WHERE B.Row=A.Row AND B.Val1=A.Val2) WHERE Val2=0 Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  10. PHV

    Excel newline formatting to Outlook Email Body and keep format

    I'd replace this: .htmlbody = .htmlbody & "<br/><br/>" & Backgdetail with this: .htmlbody = .htmlbody & "<br/><br/>" & Replace(Backgdetail, vbLF, "<br/>") Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  11. PHV

    VBScript cURL and write to MSSQL

    What have you tried so far and where in your code are you stuck ? Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  12. PHV

    Running Totals

    I tried this, but did not work.. Well, what hapenned exactly ?
  13. PHV

    Insert hyperlink dialog - current folder

    What happens if you use the ChDir instruction in a procedure called before inserting hyperlinks ? Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  14. PHV

    AWK - Sorting

    I would like to learn how to do it What have you tried so far and where in your code are you stuck ? Hope This Helps, PH. FAQ219-2884 FAQ181-2886
    • PHV
    • Post #5
    • Forum: AWK
  15. PHV

    compare lists of comma separated options

    Why using arrays ? #!/bin/ksh IFS=",$IFS" checkshells() { for a in $S1; do if [[ ",$S2," != *",$a,"* ]]; then printf "$a(-)," fi done for a in $S2; do if [[ ",$S1," != *",$a,"* ]]; then printf "$a(+)," fi done } checkshells | awk '{sub(/,$/,"");print}' Hope This Helps, PH...
  16. PHV

    Word07 Macro to Insert Locked Date

    Sorry fot the typo: Set F = Selection.Fields.Add[!]([/!]Range:=Selection.Range, Type:=wdFieldEmpty, Text:= _ "DATE ", PreserveFormatting:=True[!])[/!] Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  17. PHV

    Word07 Macro to Insert Locked Date

    What about this ? Dim F As Field Set F = Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, Text:= _ "DATE ", PreserveFormatting:=True F.Locked = True Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  18. PHV

    Visual Fox Pro 9

    What about this ? qryinssub = "INSERT INTO section_load(sec_id,subj_id) SELECT 'sec01',subj_id FROM subjects WHERE level_id='lvl01'" Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  19. PHV

    Connect to Machine DNS and Link table with Access 2010 VBA

    I'd replace this: & rsLOC & "SERVERNAME with this: & rsLOC & ";SERVERNAME Hope This Helps, PH. FAQ219-2884 FAQ181-2886
  20. PHV

    Working With Imperial - Useful Excel Function Found But Help Needed ...

    Provided that A1 and B1 are strings, you may create this 2 functions: Public Function MY2Y(MY As String) As Long Dim a a = Split(MY, ".") MY2Y = 1760 * a(0) + a(1) End Function Public Function Y2MY(Y As Long) As String Y2MY = Y \ 1760 & "." & Format(Y Mod 1760, "0000") End Function and then in...

Part and Inventory Search

Back
Top