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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by PHV
-
Removing non-ascii from large .txt file
{ gsub(/[^ -~]/,"",$0)[!];print[/!] } Hope This Helps, PH. FAQ219-2884 FAQ181-2886 -
Removing non-ascii from large .txt file
Something like this ? gsub(/[^ -~]/,"",$0) Hope This Helps, PH. FAQ219-2884 FAQ181-2886 -
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- PHV
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
something wrong in the AWK code...
Anyway this line if ( $1=="FPV" ) is never reached. Hope This Helps, PH. FAQ219-2884 FAQ181-2886 -
Create multiple word Documents and email all attachments
Put WdAppOpen.Quit outside the Loop. Hope This Helps, PH. FAQ219-2884 FAQ181-2886- PHV
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
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 -
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- PHV
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Move certain extensions to another folder
i duno where to start Have a look at FileSystemObject Hope This Helps, PH. FAQ219-2884 FAQ181-2886 -
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- PHV
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
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- PHV
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
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 -
Running Totals
I tried this, but did not work.. Well, what hapenned exactly ?- PHV
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
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- PHV
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
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 -
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...- PHV
- Post #3
- Forum: UNIX Scripting
