Re: compare text files



<sgcanning@xxxxxxxxx> wrote in message
news:1179438981.323315.127350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I am trying to compare two pipe-delimited text files which have been
exported from an Access database.
Thing is that I need to compare each record by the primary key
(CodeNumber) and if there are differences then I need to put the
different record into another text file.
Can anyone help me with this? I keep getting told that this would be
easy, but I have very limited experience with coding.
Thank you in advance for your attention and any help that you can
give me.

Will these files ALWAYS have the same structure? Specifically, will they
always have the same number of fields with the same data types, and will
both be in the same format? (For example, will one ever have Primary
Key|First Name|Phone while the other has Primary Key|Phone|First Name?)

You need to explain a bit more about what you're trying to do, hopefully
with some sample data. I have a couple of ideas but I need to understand the
problem better.


.



Relevant Pages

  • Re: Newbie Normalization Question
    ... Data types was an obvious and very stupid mistake - long day and late night makes for simpleton code. ... Could not create constraint. ... > (game_nbr INTEGER NOT NULL PRIMARY KEY, ... > Please post DDL, so that people do not have to guess what the keys, ...
    (microsoft.public.sqlserver.programming)
  • Re: Newbie Normalization Question
    ... let's get the right data types and fix the wrong names. ... "fk_" is a horrible violation of ISO-11179 rules and a good way to ... (game_nbr INTEGER NOT NULL PRIMARY KEY, ... Please post DDL, so that people do not have to guess what the keys, ...
    (microsoft.public.sqlserver.programming)
  • Re: Collecting data via an input form
    ... what's your table structure - as in, tablename, fieldnames and data types, ... primary key and foreign keys? ... I am inputing surveys on classes. ...
    (microsoft.public.access.forms)
  • Re: DDL-Adding Autonumber limit
    ... the column names are, the data types, and the column sizes. ... added the ID column as the primary key. ... Seehttp://www.QBuilt.comfor all your database needs. ...
    (microsoft.public.access.formscoding)
  • Re: Converting a number to Text
    ... I'm having a tough time with my SQL statement when I try to join two ... your text is not very long, if all you expect to do with it is to compare it ... comparing different data types (and in particular, ...
    (comp.databases.informix)