c How to compare two txt text data and solve

It doesn't have to be that complicated with C, right?

Use linux shell commands, if the 2 files are not big:

grep -v -f

If both files are large, the efficiency will be low.

steamreader rd =new streamreader(“;

string lin=;

string cols='，');

The new dictionary puts every value here.

Read 2 as well, and then split the space again for each value of 2 to see if the previous part is in the dictionary.

Save as a bat file to run.

If the file is not very large, and each line is not repeated, and the number of digits in the part that needs to be sorted in "mcy02" is the same, you can use the following **.

echo off

for /f "tokens=1-3 delims=," %%a in ( do set .%b%%a%%c=%%a,%%b,%%c

for /f "tokens=2 delims==" %%a in ('set .') do echo %%a)>

start "" ""

If the file is large, or the number of digits in the parts that need to be sorted is different, or there are duplicate lines, you can use the following **, and use a temporary file.

for /f "tokens=1-3 delims=," %%a in ( do (

set "var=0000000000000000000000000000000%%b"

echo !var:~-20!=%%a,%%b,%%c

>sort /o

for /f "tokens=2 delims==" %%a in ( do echo %%a)>

start "" ""

You can first read the contents of the file and store it in a string, then use C to connect to the database, and use the insert statement to insert it into the database.

sqlconnection conn=new sqlconnection("Link string*"

string sqlstr="insert into tablename values(content)";

sqlcommand cmd=new sqlcommand(conn,sqlstr);

Just an idea for you to try to see.

The following is the ** to open the text file, after you open it, you can do it according to what I said above.

private void fileopen_click(object sender, eventargs e)

First, change the file name to. CPP format.

Then open the C language interface, and find the file you just opened in the open option in the file bar.

First, read out the contents of the file and put it in memory. The statement is.

insert into table name column name values(..

insert into php_table( `id`, username`, others` )values( 'id', username', others' )

Copy the two text files into Excel, and it should be columns A and B.

Let's say column A is text A and column B is text B. You say, "A has a line that is 123456 and B has a line that is 2345", so do you want to judge the same or the same (inclusive)?

1. Judgment is different:

Enter in C1.

if(countif(b:b,a1)>0,"","different"2. Judgment is the same (inclusive):

Enter in C1.

if(count(find(b1,a1)),"Same",""[If column A is a numeric value, convert it to text format first].

All press enter and fill down (pull down).

Do so:

1.Open the file in Excel.

2.Select all of the first column.

3.Menu Data-Column-Delimited Symbols, Next.

4.Split the symbol by selecting a space and tab, and you're done.

5.Delete column A, save as a txt file, and you're done.

Just type ** directly in MATLAB, ** is as follows::

load **txt;%Import**txt file t=**; Use t to represent the data matrix t(:,1)=; % Delete the first column of the matrix.

1. Copy and paste into Excel.

2. Delete the corresponding column in Excel.

3. Copy and paste back to txt to overwrite the original data.

stmob is the correct solution, but for very small numbers, for example, excel may round off the last two or three, so to get the exact number (without distortion), but also to set the data accuracy, in the eighth step select the scientific count, set the number of digits needed.

, used the wrong one, the project's database, wrote a lot of data into it. Because the projects are related, I am afraid that there will be different individual table structures that will lead to unpredictable consequences, but I am too lazy to do repetitive work. I want to make some changes by comparing the similarities and differences between the two databases.

Export the structure scripts of the two databases, change the SQL file to a txt file, and compare them according to the following method 1. As a result, the structure of the two databases is identical.

Method 1: Use the command ::

After the FC is executed, the result will be saved in it, and you can open it to view the differences Method 2: In Word: Compare documents side by side.

Open the document you want to compare side-by-side.

On the Window menu, click Side-by-Side Compare with File Names.

On the Side-by-Side Compare toolbar, do one of the following:

If you want to scroll the documents at the same time, click Sync Scroll.

If you want to reposition the document window to the position it was in before you started the document comparison, click the Reset Window Position button.

Click Close Side-by-Side Comparison to stop comparing documents.

Note If you have two documents open, the command in the Window menu includes the file name of one of the documents. For example, if you turned on""Then it opened again"", the command Compare with Side-by-Side appears in the Window menu.

Whatever the cause, solving the problem is key.

You copy all the content, paste it into txt or word, press ctrl+h, and enter it in the Find Content box", replace with no input in the box, replace all is OK.