Search results for query: *

I have a pipe delimited file with 20+ fields per record. What I need to do is match a "portion" of one field against a portion of another field, and where an exception exists write the record out to a file for investigation and correction. The fields are not fixed length, and the key character...

Ladies and Gentlemen, I am struggling to find a way to remove duplicate lines from a pipe delimited file utilzing AWK. I get a file between 2k-5k The file is Sorted by the REF column. SAMPLE INPUT FILE CD|REF|NAME|Month|Year A12345N|123123|GALLAGH T|09|2007 D2345AN|123123|GALLAGH T|09|2007...

Ladies and Gentlemen, I hope someone can possibly provide some direction or help on this. Trying to create a simple file upload with a CFC doing the processing. Simple business rules. 1) Restrict the file type to Word 2) Upload one file (not multiples) 3) Assume the user will have Word...

Stupid User Question.... I have an application that mgt has asked for that from my limited knowledge should be constructed as an OLAP vs OLTP (which all of our apps are on our server right now under SQL Server 2000 on Win2k3). Long ago in an SQL Server Class I have a vague understanding that...

I have a question. One that my meager brain can fathom but cannot resolve. I would like use a regex function to validate whether or not the user has entered the expected @subdomain.domain.org Specifically, I need to make sure the users key in as an example: theirname@core.company.com where...

I am trying to create a function that can be called from a form to ensure only appropriate checkboxes are selected. I can create "hard coded" code for each grouping but with at present 30 groupings with the potential of more, that is neither smart nor prudent. I have checked the books I have...

I have checked the jetsql40.chm, and the web, and Tek-Tips for a reference on whether or not DEFAULT is available in Access 2000. It does not appear as a reserved word in Jet SQL either. I spotted some code that indicated that it would, but my attempts generate an error "MICROSOFT ACCESS -...

Is there any way to embed comments / documentation in an Access Query similar to MS SQL Stored Procedures? Tried // and -- looked at the jetsql40.chm and did a quick search on the web and in the forum faq, and nothing. Suspect it does not have that capability. But thought I would ask here...

I am convinced that this question is so simple it will be very embarrassing. But ask it I will. How or what does one order to get a licensed copy of MS SQL Enterprise Manager. I have access to a Server running MS SQL 2000. I am starting out just learning MS SQL, but clearly one must have a...

I have a need to replace all high bit codes from content gathered via a form, prior to writing it to a database. Server is Windows 2000 Server, and I do most of my server and client side in Javascript/Jscript. What I am shooting for is after running a regex replace all other characters EXCEPT...

I have a question, that may be appropriate for this forum. ============ Is their a length constraint for using Access Stored Procedures/Parameterized Queries where one of the fields is passing in/through a MEMO field? ============ I "found" Access 2000 Stored Procedures/Parameterized queries...

I have the need to send an HTML formatted email due to a table layout, plus attach a number of Word and Excel documents. The script I have created does this, however, what is viewable in the received email is the HTML and the uploaded files starting at the RIGHT of the html content and...

Hope someone may have a suggestion or solution to my problem... Step 1: Initial form Page displayed | v Step 2: User completes Page 1 | v Step 3: User submits Page 1 to db process pg | ====================== Step 4: Transaction Pass => No pop Fail page | v Yes - want to pass PK field and...

Trying to create a script to allow designated users to mock up a customer receipt. User problem is due to state laws, certain wording is required. So up till now, users submit text to our developer, he codes it, and then prints a copy and takes it back to the user. User has no concept of...

I have searched Tek-Tips, MS documentation and the web, and not found an answer a question on how to determine how much free space exists on a tape in the drive. I am forced into using NTBackup due to budgetary reasons. So what I have is a working script that will perform Differential backups...

I am really having a mental block on this. I want to identify the newest file in a specific directory. Specifically, it will be the newest NTBackup log file created during nightly backups. Since Win2k does not permit you to define the log file name, I need some way to identify it so I can...

I am having a problem with scripting a match of a string from a text file. The file is created by redirecting the output to a tmpfile called physmedia.tmp from RSM This is to test to see if there is a backup tape in the tape drive. The file that is created does have the text I am trying to...

I have a need to be able to format long strings for inclusion in an email message. I have one that works but it is VBScript. What I want is a Javascript function. I am looking for a function that can take an string of text and based on the line length, insert \n at the nearest "blank" space...

Having a problem with trying to get a regular expression to successfully and correctly validate a field on an HTML form. Script was sourced from a site that included a test routine, and it successfully worked there. However, it fails to work correctly. Function is called, and gets to just...

If I use an <a> similar to: <a href="http://iweb2.verilux.com:88/ldapOrgChart/ldapOrgChartC1.jsp?uid=uid%3D280649175%2C+ou%3DPeople%2C+o%3Dverilux.com">TEST ME</a> It delivers me to the appropriate page, but this is a one-way trip off my site. However, I want to pop up a window and display...