China DOS Union

There is a text a.txt

435241|Yangxin|District 8
435250|BaiSha|District 8
****

How to get the values separated by "|"?

对于 /f "tokens=1,2,3 delims=|" %%i in (t.txt) do (...)

Thank you for your reply.

What does %%i refer to, the first value, the second value, or the third value?

%%i The first one
%%j The second one
%%k The third one

The landlord first, take a look at /?

Originally posted by pip at 2006-9-27 04:37:
%%i first
%%j second
%%k third

Are the variables i, j, k in %%i, %%j, %%k arbitrary? Are they arbitrary? Or are they in a fixed order?

I'm a newbie, asking for help humbly

I wrote it here, but execution always fails:

for /f "tokens=1,2,3 delims=|" %%i in (txip.txt)

do ( echo 'update dzhd_t_txfjxx set v_ip=%%k where c_jgbh=%%i and c_txdm=%%j ;')

The content of txip.txt is:
31001402|07|10.138.9.165
31001402|05|10.238.60.81
31001402|06|10.138.9.164
31002001|05|10.138.9.37
31002001|06|10.138.9.38
31002801|01|10.138.13.10
31000903|01|10.138.20.68
31000903|03|10.138.20.74

The error message is:
E:\ftp>sql.bat
The syntax of the command is incorrect.

E:\ftp>for /f "tokens=1,2,3 delims=|" %i in (txip.txt)

%%i, %%j, %%k are an order issue; if the initial variable is defined as %%a, then the sorting will be %%a, %%b, %%c, %%d...; similarly, if the initial variable is %%0, the sorting is %%0, %%1, %%2...

This is related to the base of the characters or strings extracted by the FOR statement. Each time a character or string is extracted, it is assigned to the next variable. And so on.

Of course, there are also quantity limits. If the variables are defined by letters, their number cannot exceed 26 (a-z).

The maximum number of variables defined by Arabic numerals cannot exceed 10 (0-9).

Originally posted by pengfei at 2006-9-27 09:07:
There are of course also number limits. If it is a variable defined by letters, their number cannot exceed 26 (a-z).

The statement that there are number limits is correct, but the claim that the number of letter variables cannot exceed 26 is incorrect because the letter variables in the for statement are case-sensitive, so the number of letter variables should not exceed 52.

Yes, then the assignment rule for 52 variables is that the lowercase is assigned first and then assigned to the uppercase?

The help also mentioned that a line specifies a maximum of 26 characters, and the mention of not being able to use more than 52 at the same time, since I didn't study it deeply, I didn't mention it.

[ Last edited by pengfei on 2006-9-27 at 10:17 ]

Originally posted by pengfei at 2006-9-27 10:10:
Yes, then the assignment pattern for 52 variables is to first complete the assignment in lowercase and then assign to uppercase?

The help also mentioned that a line specifies a maximum of 26 characters, and it mentioned that more than 52 cannot be used at the same time, by 䠮..

　　This question hasn't been deeply thought about. It is speculated like this: If you start using lowercase letters to define variable names, then the variables after for on the same level should at most only go to z. If it is uppercase, it can at most only go to Z. That is to say, the case of variable names should be consistent from start to finish, and cannot be mixed. Otherwise, there wouldn't be the statement in the help that a line specifies a maximum of 26 characters, and it mentioned that more than 52 cannot be used at the same time. It's just a speculation. Those who understand, please analyze it more deeply.

Originally posted by namejm at 2006-9-27 10:28:

　　This problem hasn't been deeply thought about. It is speculated like this: if lowercase letters are used to define variable names from the beginning, then the maximum number of variables after for on the same level should be up to z. If it is uppercase...

I think it is like this. The number of letters used as variables in a loop cannot be more than 52. Variable names can only be single letters, case-sensitive. So the number of letter variables that the system can handle normally cannot be more than 52.

If numbers are added, the maximum number of variables that can be used globally is 62, and the number of variables assigned by FOR to extract text lines cannot be more than 26 (a-z) or (A-Z).

Everyone, help me see where I made a mistake.

for /f "tokens=2,3* delims=|" %%i in (txip1.txt)

do ( echo 'update dzhd_t_txfjxx set v_ip=%%k where c_jgbh=%%i and c_txdm=%%j ;') >a.sql

The prompt is "E:\ftp>rem for /f "tokens=1,2,3 delims=|" %0 in (txip1.txt)
The command syntax is incorrect.

E:\ftp>for /f "tokens=2,3* delims=|" %i in (txip1.txt)

The parentheses in that line were mistyped. `>a.sql` should be together with ECHO.

The code you just wrote. Hehe. Interested to take a look
Function splitfile(strFile)
Const ForReading = 1,ForWriting=2
Dim i, retstring
Set fso = CreateObject("Scripting.FileSystemObject")
Set theFile = fso.OpenTextFile(strFile, ForReading, False)
Do While theFile.AtEndOfStream <> True
retstring=Split(theFile.ReadLine,"|",-1,1)
For i=0 to UBound(retstring)
wscript.echo retstring(i)
Next
loop
theFile.Close
End Function