Search results for query: *

The task at hand is to compare the data in two tables and write the mismatches to a table. There are hundreds of fields and millions of records. The process is currently opening the the "master table" and capture each field names (SelectedField) when plug the SelectedField name into the SQL...

The issue: would like to populate specific data in Excel directly from Access. Currently, the process is data is transfered from Access to create a new worksheet "B" in the existing spreadsheet containing worksheet "A", run VB code that loops through all the data to match Name in worksheet "A"...

Problem: I need to export data from Access that is created on the fly. This is to be written to a text file. I can create a file but I need to append successive data to the file as it runs through the loop. Current Code: The data set is generated with select criteria and creates a list...

I have code that creates a Relationship from VBA ; however, what I want is to Include ALL records from 'A' and only those records from 'B' where the joined fields are equal. Currently code creates an join where both tables are equal. Can anyone help me??? Dim db As Database, rel As Relation...

This is probably very simple but I can'f figure it out. Problem Table A -with a field "shortname" is used as a pass through query with Table B to create a new table. I have shortname entries like Table A GV GVW To make the pass through work properly, I need a hard space at the end of GV and...

New to VBA excuse my ignorance - I've tried to solve the problem with DCount; however, this may not be correct solution - I'm open to suggestions: Problem: I have a form that Queries from table DATA_PERMIT sorting by WELLNAME, Agency etc. The current form only selects Agency = "ST". For...

Data is imported into Excel with copy paste as HTML. HTML is used because color line formating contains information desired. The problem is that when data is imported as HTML the checkboxes imported as part of the process. HOW DO I DELETE ALL THESE BOXES WITHOUT clicking on each individual...

I have a script that reads a file and one of 20 steps should search for a "D" and replace the "D" with a carriage return. What would be the command to do this subsitution. Right now I'm getting to this point and take the file into VI run a macro then start the next script...

Simple question: I want to do a simple sed edit on multiple files with one script. This can be done with the * command for input file names. sed -e 's/STOP/ /g' *.lst How do I output to a string of file names? I would like to output old file name with new added to the filename. ie input file...

Within a macro, I need to insert a new field name in a existing table. For this part of the macro I am using commands: Action OpenTable (TableName, View Design, Add) Action RunCommand InsertRows Here's my problem: I want to go to the bottom of the table to insert the row And I want to call the...

Ok you wizards, how do i create a loop that repeats the awk part of this script. I have a process that needs to be repeated between 80 and 100 times for each file, depending on the number of names in row 1. Here's a sample of the input. Row one contains the date and names (comma delimited)...

How do I find the minumum and maximum of $5 (x) and $6 (y) Then round xmin, ymin down to the next lowest 1000 {newxmin, newymin} And round xmax, ymax up to the next 1000 {newxmax, newymax} write newxmin newxmax newymin newymax then write the rest of the file (already scripted). open new file...

I can't seem to hurtle creating a file with variable number of joins (line concatenation) - I can do this in a macro in vi but haven't mastered joining in an awk script with more than one line joining at a time. the script needs to: search for ^STARTRECORD and append each line following that...

I have a table which has the following fields: lastname, firstname, visitdate, and remark(text field). lastname firstname visitdate remark Johnson Len 5/17/61 Patient is feeling sluggish. Johnson Len 5/17/61 Has difficulty breathing. Temperature Johnson...

I have two questions: Question 1 From the following I want to print from $5 to the end of the line. The script searched for/ Remarks on/ but then I only want to print from FRAC....SI /15. The length of this field will change each time as will the 001 that preceeds the statement. input...

I want to search for the "Remarks on" and print that line. test 1 - if the next line (line 2) has a record number = 1, then I want to search again for "Remarks on" test 2 - if next line (line 2) has $2 == "PD" then I want to search again for "Remarks on&quot...

Can this be done using awk? find a text string 1st search text string is: Plugback once found - drop down two lines then write to a file all the lines that occur between that point and one line above new search string 2nd search string is: ----- (5 dashes) repeat until end of file. I used to...

I'm new with Awk -- my files is structured like this: >,T1N,R1E,S0,M15 108.533020,39.106216 108.533065,39.120697 108.478057,39.106170 108.496017,39.106155 108.514495,39.106155 >,T1N,R1E,S1,M15 108.440109,39.178619 108.421585,39.193130 108.421615,39.179992 108.421615,39.178649 >,T1N,R1E,S2,M15...