All Questions
8
questions
-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 ...
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"
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...