Skip to main content

All Questions

Tagged with
-2 votes
1 answer
141 views

Extract string and save each in txt

I have a file text with inside : line1 name1 line2 name2 How can I extract as this? Extract & copy line1 to a new file saved as name1 Extract & copy line2 to a new file saved as name2 I used ...
Iztac's user avatar
  • 1
0 votes
1 answer
384 views

Extract MID between characters, but from second instance in Excel

I need to isolate the middle string of text from a line. The number which follows the "Q." "400" When I pull the MID section, it grabs everything from the FIRST "S" to the end of the "Q400" ...
Melissa's user avatar
1 vote
2 answers
6k views

Extract Text from in front of, after, and inside characters

I have a variable (%~1) set to something like: Hello there this is a block: [C]Inside of Block[/C] Did you like it? I want to have it separated into three variables: Front=hello there this is a ...
Mark Deven's user avatar
  • 1,660
0 votes
2 answers
2k views

How to parse multi-line log file in awk and output only single line with last known ip address

I am stuck and looking for assistance. I want to trigger an event which I'd like to process further through a bash script. The data is retrieved from a log file. Before I start to explain I'll show ...
user882786's user avatar
0 votes
2 answers
40 views

I need to extract a 8 characters between known and copy value to clipboard

I am not a superuser but more of a supertinkerer. I would like to take a text file, a CNC program to be exact, and extract an 8 digit string from between the known characters of "TxxxxxxxxM6" where T ...
Jeremy W.'s user avatar
0 votes
1 answer
331 views

How to search and extract part of string in batch script?

I am pretty new to windows batch scripting and am having trouble to search and extract a portion of a string from a text file and display it out. Some samples data are shown below. The keyword for ...
Peter's user avatar
  • 1
1 vote
1 answer
17k views

How do I populate a column with the first x characters of text data in another column

I have a column with 14 characters. There is real information based on the first three characters. I want to have another column with only the first three characters for visibility and group by ...
user234520's user avatar
22 votes
5 answers
193k views

Excel extract substring from string

I am looking for a way to extract a variable length substring from a string. My cells will look something like: ABC - DEF ABCDE - DEF ABCD - ABC I want to split the string at the - character, so ...
Pieter van Niekerk's user avatar