Questions tagged [parsing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
121 views

Is the “.sha256” file format formally defined somewhere? How should it be parsed?

I see a bunch of FOSS projects which have ".sha256" files. They look something like this: dsdfdfdsffdfsdfdsfdsfdsfdsfdsfds23r2ewrefdefdsfdsgfdsgffgfkgdfgg *meow.exe ...
0
votes
1answer
41 views

Split column based on tabs or spaces

Column A has 3 columns worth of information. The data is human readable, but not machine readable, and I want to pivot the data. Is there a way to parse the data by spacing or tabs? In the formula bar,...
0
votes
2answers
113 views

Parsing Command Prompt Output

I am retrieving disk information via JavaScript with the wmic statement, wmic logicaldisk get freespace,name,size,volumename, which produces the following output, but in a single string. "FreeSpace ...
1
vote
1answer
83 views

How do I delete BOTH lines of a duplicate pair in a text file in bash?

I want to delete both lines of a duplicate pair in a text file. There is no way to do this using sort -u file or awk '!a[$0]++' file which both delete duplicated lines. Somehow I would have to ...
0
votes
1answer
40 views

Iterative Find (from list) of parent tag to replace child tag value

I have a xml file with simple tag hierarchy as such: <Parent Numbrt="X1"> <Namedchild>Yes</Namedchild> ....more children... <Parent Number="X2"> <Namedchild>...
0
votes
2answers
74 views

html link error in xml

I am trying this in xml: <a class='mybtn' href='https://www.youtube.com/embed/VIDEOID?autoplay=1&loop=1&playlist=VIDEOID'><i class='myclass'/></a> but I get this error: ...
2
votes
2answers
58 views

Deleting list of files with non-standard file names

I have recently had to rescue files from a bad HDD, and am in the middle of cleaning up the mess. Currently I'm using a duplicate cleaner to delete any restored files that have duplicates on my backup....
0
votes
1answer
31 views

Parsing text translations

Hi I'd like to get this into Excel Columns of Phrase, Translation, %YES <tr> <td>Phrase in a language</td> <td>Translation</td> &...
0
votes
1answer
44 views

Is there an industry standard tool available which parses s3 files and loads them to database tables?

I have text files of multiple content formats on s3 buckets. The simplest format had delimited content as dhwon below: Field1|field2|field3|field4 I would like to parse the above delimited file and ...
1
vote
1answer
43 views

Json Parsing with Jsonpath based on string condition filters [closed]

I am fairly new with Jsonpath and am forced to use due to a project dependency. The sample json loooks like this { "people": { "a": {"First":"James", "last": "d"}, "b": {"First":"Jacob", "...
0
votes
1answer
27 views

Retrieving Formulas within Excel concatenate function

I want to parse an excel concatenate statement to find the result of the enclosed expression. Eg: =CONCAT("=1-2-3+7*8") should return 52, and =CONCAT("=AVERAGE(A1,A2)") should return the average of ...
1
vote
1answer
58 views

couldn't parse date : nxlog

While debugging my log parsing in Nxlog, i got the below error 2019-03-31 01:57:31 DEBUG couldn't parse date: Mar 30, 2019 4:53:56 AM I have used the below command to parse date : Exec $time = ...
-1
votes
1answer
307 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
1k 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
39 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
717 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 ...
1
vote
1answer
93 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
8k 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
5k 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
531 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
134 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
54 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
2k 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
30 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 ...
3
votes
2answers
3k 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
142 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
124 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
1k 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
121 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
692 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
441 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
85 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
43 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
841 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
157 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 ...
5
votes
2answers
10k 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
35 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
102 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
6k 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
421 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
852 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
841 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
147 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
143 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
799 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/...
1
vote
1answer
4k 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
71 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
62 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....