[Batch] String Extraction Solved

Question

Hi,

I have a problem with manipulating a string. I have a file (temp2.txt) that contains a string of characters like this:

1:4162

What I want to do is extract the number "4162" to temporarily place it in a variable. I am using the FOR command to achieve this.

Here is the line that should allow me to perform this extraction:

FOR /F "eol=: tokens=1 " %i in temp2.txt do @echo %i

Thank you in advance for your help.

Pool Orion · Accepted Answer

Sorry, I had to look around a bit too. You need to use the variables with the double percentage sign.

-->

pause
@echo off
FOR /F "tokens=1,2 delims:;" %%i in (temp2.txt) do @echo %%i and %%j
pause

gives the result 1 and 4162

--
Pool Orion

Pool Orion · Answer

And what is the problem?  -- Pool Orion

jejeTech · Answer

The problem is that the following line "FOR /F "eol=: tokens=1 " %i in temp2.txt do @echo %i " does not work to extract the number "4162" from the line "1:4162".

The DOS FOR command doesn't work as it is presented; I would like an opinion from someone who knows this command well in order to achieve my objective.

Thank you.

Pool Orion · Answer

I don't understand why you specify that the end of line character is ':' with 'eol'.

You should specify the colon as the delimiter. In addition, you should retrieve two results -> 1 and 4162.

--
Pool Orion

jejeTech · Answer

I found this command while searching on the INTERNET, I tried to adapt it to my script but I don't understand everything about the FOR parameters.

I can't figure out how to extract the number "4162" from my line using the delimiter ":" with FOR.

Can you help me understand this command?

Thank you

Pool Orion · Answer

The FOR function allows you to execute a loop over, for example, the records of a file.
The file to read must be specified after the 'IN'
The parameters you need are tokens -> list of areas to retrieve and delims -> delimiter for your areas.

I think the most appropriate structure in your case is as follows:

FOR /F "tokens=1,2 delims:;" %%i in (temp2.txt) do ...

According to your example, you should then have i -> 1 and j (the next letter) = 4162

PS: on some versions of DOS, it is not possible to call a procedure in the do, you should try if you really need it.

--
Pool Orion

jejeTech · Answer

I tried in my script with this:

FOR /F "tokens=1,2 delims:;" %%i in (temp2.txt) do @echo %i %j
echo %j%

I would like to test with the display but it doesn't work. Maybe I coded my line with echo incorrectly.

In the execution of the batch file, I don't see the display of my variable %j.

??

jejeTech · Answer

Thank you very much, it works.  That's cool. You're a pro!!  See you and goodbye!

mansour79 · Answer

Hello everyone, I am a beginner in PL/SQL, and I have an assignment to submit next week.
The problem is as follows: use PL/SQL and C to extract a string from a .txt file.
For example, read an HTML file where all the authors with their reviews, city, etc., are noted, and it is necessary to call a C function with PL/SQL to read this file and fill the tables: authors, reviews, city, etc.
I hope to find a lead to solve this.
Thank you very much.

alexkidd · Answer

Bonjour, je suis un débutant sur le script unix et je souhaiterais savoir comment se nomme et s'utilise la fonction qui permet d'extraire une sous-chaîne sous linux sachant que la chaîne est dans une variable. J'ai fait :

cat $fichier >>$(echo $fichier | cut -c1-10)||".fic"

mais ça ne marche pas !!
Help me !!!

1223 · Answer

Hello
here

@echo off
for /L %%A IN (1,1,50) do (PING -n 1 -w 5 192.168.1.%%A | find "TTL" | cscript //B convert.vbs)>> text.txt
for /f "tokens=1,2 delims:;" %%a in (text.txt) do (echo %%a >> text1.txt)
for /f "tokens=3" %%a in (text1.txt) do (echo %%a ) >> text2.txt
TYPE text2.txt
I would like to process the results saved in the file text2.txt "IP address", the problem is that these addresses end with a "ÿ" for example 192.168.1.3ÿ and when I ping to test "for /f %%a in (text2.txt) do (ping %%a )", it doesn't return anything "it doesn't recognize the host"
for /f %%a in (text2.txt) do (ping %%a )
and when I display the content of the file text2.txt, it only shows the IP address

if possible have a response

Thank you in advance for your help

batikha · Answer

Hello, I can't solve the following problem:

Write a procedure in PL/SQL that takes a text as a parameter;
And it must determine:
- The double letters (lowercase) that appear in the text (for example: ss, mm, ll, etc.).
- The number of sentences (separated by a period).

Can you help me please?? It's urgent

Thank you, see you soon

allo · Answer

if String = abcdefg  substring(String,3,2) = cd substring(String,2,4) = bcde

sebj9 · Answer

Hello,

I am looking to extract a part of a line from a txt file to replace it in my script afterwards. It's line 5 which is: "Home Directory"="C:\\Program Files\\Symantec AntiVirus\\" and I want to extract "C:\\Program Files\\Symantec AntiVirus".

I know that we can use the FOR command in MS-DOS but I don't know what parameters to enter.

Best regards

SEBJ

CedK · Answer

There is a DOS command to extract a string. You can see it by getting help from the SET command in a command prompt (type set /?). Excerpt from the help:

The environment variable substitution has been enhanced as follows: %PATH:ch1=ch2% expands the PATH environment variable, replacing each occurrence of "ch1" in the expanded result with "ch2". "ch2" can be an empty string to remove all occurrences of "ch1" from the expanded output. "ch1" can start with an asterisk, in which case the command will process the string from the beginning up to the first occurrence of the rest of ch1. You can also specify substrings for an expression. %PATH:~10,5% expands the PATH environment variable and uses only 5 characters from the eleventh (offset of 10) in the expanded result. If the length is not specified, the rest of the variable's value is processed. If either value (offset or length) is negative, then the number used is the length of the environment variable's value plus the specified offset or length. %PATH:~-10% extracts the last 10 characters of the PATH variable. %PATH:~0,-2% extracts all characters except the last two of the PATH variable.

So, let "machaine" be the variable containing "1:4162":

set machaine=1:4162

to obtain 4162 in the variable "resultat", you simply need to write:

set /A resultat=%machaine:~2%

There you go
CedK

[Batch] String Extraction

15 réponses

Canon mb5350 - cartridge replacement impossible

Texture issues in enshrouded

Football manager (club management game)

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.