Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [parsing]

The tag has no usage guidance.

0
votes
0answers
46 views

Windows 10 - Word Delimiters (boundaries) in Explorer

In brief: Anyone know if there's a way in Windows to define a list of characters to be considered as delimiters in Windows Explorer, for the purposes of double-clicking to select a word in a filename ...
-1
votes
1answer
150 views

Parsing JSON with BusyBox tools

I have a POSIX-compatible install script which determines the latest version of some software by grepping info from a json blob retrieved from a software registry: meta=$(wget -qO - https://registry....
1
vote
1answer
184 views

How to properly unescape strace output

How do I unescape strings outputted by strace? I see some advices to use printf '%b' for that, but that doesn't work correctly for me in some cases. Consider echo -ne '\037\061': $ strace -e write ...
0
votes
0answers
36 views

Extracting minor version number from C# source using MSDOS batch file

I need to extract the version number from this C# source line using MSDOS batch file: public const int major_version = 2; My attempt: :: Extract the number-token from the major version string. ::...
1
vote
2answers
446 views

Parsing the result of a command in a Linux bash script

I am writing a small bash script in Linux to control Pulseaudio inputs/outputs. What I want to do is to route all sink-inputs, except one, into one or another sink. The sink-input I don't want to ...
0
votes
0answers
242 views

How to split workbook with multiple sheets into multiple workbooks

I have a single file, which has 3 sheets. In column A of all 3 sheets is the same unique ID. I would want to create multiple workbooks based off the unique ID and pull in all 3 sheets to the new ...
1
vote
1answer
59 views

Parsing errors due to special characters in dns txt records

I have trouble parsing dns txt records retrieved by a script I wrote. The script takes a records, ns records and txt records and writes them to a .csv file. I am using semicolon to separate entries ...
2
votes
1answer
3k views

Parsing and reformatting date string using PowerShell

Given a CSV-file containing the following line: HEAD;1;49999;8-10-2017;;; .. I need to reformat the date given as d-m-yyyy into fixed length dd.mm.yyyy and/or yyyy-mm-dd (fixed, naturally implying ...
0
votes
1answer
2k views

Replacing special characters in text file using PowerShell

I would normally use Perl and regex for this, but to simplify portability between Windows computers, I am hoping to accomplish the following using PowerShell instead: A CSV file containing ...
1
vote
0answers
394 views

How to parse JSON array data from GMail to Google Spreadsheet?

OK, I hope to be clear while explaining what I would like to do... I've setup a personal ADSB station (helping me with other tasks, too) putting antenna for 1090, Raspberry Pi 3B, filter and amplifier ...
0
votes
1answer
106 views

Write URL's to a text file that match a pattern

I'm trying to parse the nickjr.com site, specifically "http://www.nickjr.com/paw-patrol/videos/" URL for full episodes only. nickjr.com has their site laid out by show title, then by games or videos,...
1
vote
0answers
51 views

how to parse a xml which might have zero to N number of nodes using perl

How to handle a xml which might have one or more occurance of node in the file in perl. In the current solution provided below, foreach $FileContainerRec (@{$XmlFile->{FileContainer}}) { $...
0
votes
3answers
959 views

Excel | How to split string text between two different characters?

This is my first time posting here, so bear with me. I have the following string of characters in Cell A1: C.CompanyName_E.234500_Y.Boston_S.Massachusetts_S.800x600_ I want to parse CompanyName (...
0
votes
0answers
23 views

translate a webpage and declutter at the same time? how?

Translate: google translate, either with bookmarklet or chrome extension declutter: Instapaper text bookmarklet. They used to work together sequentially, but recently Instapaper changed their ...
4
votes
2answers
2k views

Excel Does Not Parse Quoted String containing comma in CSV File Correctly

I have a CSV file that with quoted string that contains comma. When I open it in excel it still uses the comma inside the strings and parse it in different columns. Can someone help? T7, 7, "331-8463 ...
1
vote
1answer
72 views

How to find all websites matching the pattern website.edu/~<some_string>?

It's common among university lecturers to have their own web pages on the university domain and share resources there. If the name of a professor is John Smith then he his website may be harvard.edu/~...
0
votes
2answers
81 views

Return specific matched (sub) value with grep in linux

I'm running a Zabbix agent (logging software) on Ubuntu and wish to ping an internal IPIP/GRE Tunnel to constantly measure the quality of the connection. Now a Zabbix agent does not by default allow ...
2
votes
1answer
617 views

Machine readable list of files in rar archive

I need a way to get a parsable list of all files in a .rar archive without extracting them, in bash or python. What I've tried: rar l *.rar 7z l -slt *.rar I've also looked at patool in python, but ...
0
votes
1answer
53 views

Scribus file opening error

I have been editing a document and saving it with same file name a few times. My latest attempt to reopen generate a parsing error: namely lline 141, column 52. The file did not open. Is there a way ...
0
votes
3answers
452 views

Parse a complex string into into separate Cells

I need to parse a string with varying field lengths into separate columns. I have the following series of data. Using Formulas I would like to Populate columns F, G, H and I the the various field ...
0
votes
0answers
116 views

Getting Excel to Conditionally Copy Data to Another Sheet

I have a spread sheet that will have new data entries on each row. I need to get excel to automatically check for a specific column's value, and if that value is a 1, it needs to go to the sheet with ...
2
votes
2answers
71 views

Get first two strings of each filename in a directory as a txt file

I need to clean up strings like this (where I read in a group of image names), where I only want the first two strings (currently I'm using, in Windows 7 cmd line - dir /a/b/p > textfile.txt): Acaena ...
1
vote
0answers
35 views

Parsing (or Converting) Buffered Output

If a dynamic, text-based, CLI application doesn't include an option for producing unbuffered text output; what options do I have for parsing said output? Can it be converted to a more appropriate ...
1
vote
0answers
534 views

How to extract text from websites

I am looking for a way to automate extracting text from multiple websites to a word document. When pasted into the word doc I need it to paste using "merge formatting". This is how I would like the ...
2
votes
1answer
1k views

Is it possible to fetch and parse email using mailutils+shell scripting only in Ubuntu server headless 15.10?

In my hoping to minimize the number of packages each needing their own configurations, I'm wondering if there is a way for me to retrieve email for parsing by script without installing any more email ...
1
vote
3answers
137 views

Extract multiple sections of pages from a pdf

I have a ton of pdf files (past exams), of which only two sections of pages (about 8 pages each) are relevant to me. I'd like to extract the two sections into a separate file for each of them. I used ...
4
votes
2answers
5k views

Extracting a list of values from JSON file to Excel or a text file

I want to extract usernames from a JSON data file. [{"username": "Cobra", "user_id": 146231486, "event_type": 2, "title": null, "class_id": 4211, "war_state" : null, "superpower_expire_date": ...
1
vote
1answer
30 views

How can I disable dates in the Calc?

I see that all spreadsheets are urgent to recognize your 13.12 as a date. Particularly, I am struggling with Calc, who is said to use English language to import dots as decimal separators. But, ...
1
vote
1answer
95 views

Pulling dollar amounts from DoD Contract Awards

I'm going through Department of Defense press releases (here) looking for dollar amounts greater than $500 million. Each document is between 1,000 and 15,000 words, with dollar amounts inline with ...
2
votes
3answers
5k views

Parse string using batch script

How can I parse string using batch script? Goal is to save in a array everything under Import: and strip out #head for example --> //MPackages/Project/config/abc.txt and //Packages/Project/config/cde....
2
votes
0answers
402 views

seach for a word in .txt files and write few line into new .txt file

Please help me to create a script to perform task as per described below. i have 2 files. A.txt and B.txt Content of A.txt as per below ITEM name TICKY title nice coffe drink type DRINK ITEM ...
7
votes
8answers
1k views

Remove linux file named with set of shell responsive characters

I've created a file named \;:$"\' to test a software of mine. I ended up with an error, because I cannot delete the file property. I'm trying to find a precise character combination to remove it via ...
0
votes
1answer
603 views

Parse variables from URL with formula after pasting in Excel

I often have long URL's that have ampersand delimited variables at the end, and I would like to be able to simply paste the whole URL and have all the variables populate the fields below in the same ...
0
votes
2answers
715 views

How can I determine the IP of a remote host in a shell script?

I have an IP alias that switches between two hosts depending on the host's availability. (This is a very large network and the switch is done externally of local control.) I need to determine when ...
0
votes
1answer
127 views

Dig command: Is the output guaranteed to be sorted?

Let's say I'm trying to lookup the IPs mail.yahoo.com, gmail.com and mail.google.com If I execute: dig @8.8.8.8 +nocomments +noquestion \ +noauthority +noadditional +nostats +nocmd \ gmail....
1
vote
1answer
118 views

How to xml to xml parse

I am trying to automate this process. I have link to this xml file. it has many parameters, but I am only interested in 3 of it's parameters. I want to use those 3 parameter and create new xml file ...
2
votes
3answers
677 views

Extracting links from a numeric range of web pages

I would like to extract links from a numerical sequence of pages like this: http://example.com/page001.html http://example.com/page002.html http://example.com/page003.html ... http://example.com/...
0
votes
1answer
3k views

Get variable values from config file

I have one config file with some variables eg below but my command only read some variable value, I cant read all values in config file. Seems only read values with numbers. what is better way to read ...
1
vote
2answers
69 views

How to retrieve a name from another file with a Bash script?

I would like to grab a name out of another predefined file and use it within my shell script. The file being read would be in ./docs/description.org and the format (a table in .org format) is: ......
0
votes
1answer
59 views

Remove symbols while appending in excel

I'm having some parsing issues here. I have a column of Twitter handles, with '@' in front of them, and I'm trying to auto-append them in a URL on the next column. Example: | @Bob | https://twitter....
0
votes
1answer
95 views

mIRC parsing a name

Asked originally: https://stackoverflow.com/questions/23419961/mirc-parsing-for-a-name So I've been getting a bothersome someone who keeps using my nickname. What I want to be able to do is perform ...
1
vote
3answers
4k views

Fast extraction of key-value pairs in Linux command-line

I have a large (tens of GBs) text file with data in key=value;foo=bar;baz=quo format. The number and order of keys can change from line to line. I need to process this file and extract values for ...
1
vote
1answer
109 views

error in /usr/share/perl5/iCal/Parser/HTML.pm on debian

how to fix this? when i type perl /usr/share/perl5/iCal/Parser/HTML.pm i get syntax error at /usr/share/perl5/iCal/Parser/HTML.pm line 64, near "$t qw(week month year)" Global symbol "$t" ...
0
votes
1answer
804 views

To convert Powerpoint into outline of Tex-file effectively

I have lectures as powerpoints. I want to convert text and lists to tex-file. If there is a picture, a mark can be left to a file. I can individually add pictures. I tried to save the ppt document ...
5
votes
3answers
23k views

How append a string at the end of all lines?

I'm trying to add a string at the end of all lines in a text file, but I have a mistake somewhere. Example: I've this in a text file: begin--fr.a2dfp.net begin--m.fr.a2dfp.net begin--mfr.a2dfp.net ...
1
vote
1answer
33k views

Batch to extract a word from a string inside a text file

I have a database.txt file with this content: 40001 16 DATAMAN Jimbo WS2 I want to extract the third word, as delimited by whitespace ("DATAMAN" in ...
1
vote
1answer
593 views

How do I quickly parse large ASCII files for matching records?

I have lots of files containing data records, stored as space-delimited ASCII files. Each record is a row containing numeric data, with some columns integer and others floating-point eg. 1 1 5711 4 ...
1
vote
2answers
376 views

How can I parse out the dimensions for this string in Excel?

I am trying to parse out the individual dimensions (length, height, width) for a string in Excel but am having problems determining which text formulas to use. Details below. Data example (in one ...
0
votes
0answers
31 views

When an image on an editing program is rendered on Windows, is the program parsing it, or is the kernel doing it?

so I know this question is confusing, but luckily I am a computer programmer and can make it more clear if you would help me out by reading on. A simple program, liek MS-Paint, will "know" how to ...
4
votes
5answers
27k views

sed: extracting value of a key-value pair in a URL query string

I am trying to use sed to extract the value part of one of the many key-value pairs in a URL's query string This is what I am trying: echo 'http://www.youtube.com/watch?v=abc&g=xyz' | sed 's@^...