Questions tagged [parsing]
The parsing tag has no usage guidance.
107
questions
0
votes
1
answer
83
views
Convert duration in XXm, YYs format to time value
In Microsot Excel, I have string data that represents duration of an event:
duration
40s
5m, 40s
59m, 59s
I need to convert the values to time (in adjacent column) so that I can format and sort ...
1
vote
0
answers
137
views
How to prevent VS Code from treating the tab-key input as textual-input/tab-stop-insertion, but instead solely as auto-completion-/navigation-trigger?
Preamble:
I would like to use VS Code whenever i can, if i could (mainly for the reason that it is cross-platform and the only completely customizable/hackable GUI editor on all major platforms).
One ...
0
votes
0
answers
77
views
Paste formatted SQL queries from text file into Excel (one Excel row for each query)
I have a .TXT text file that has formatted SQL queries in it.
--The corresponding Excel row ID is: 2
select
main.active_transportation.objectid,
main.active_transportation.type,
main....
0
votes
2
answers
50
views
How to get value of a cell based on key on neighboring cell in Excel?
Input:
I have the following data;
C
D
1
$1
ABC
2
$2
ABC
3
$3
DEF
4
$4
ABC
I want to create another table in the same sheet where I want to add the values in Column C based on the keys in Column ...
0
votes
0
answers
355
views
Extracting data from filename with spaces in Batch file
I have a batch file that moves a list of files around by grabbing the first 6 characters from the filename and moving it to the folder containing the extracted characters. I need to take this one step ...
1
vote
1
answer
37
views
Is it theoretically possible to create a log parser/analyzer with the quality of manual parsing without use of an AI? [closed]
I am trying to setup a good log analyzer for our tomcat application. I was able to create a basic parser and analyzer with python regex and panda stats feature.
The parser basically parses the ...
0
votes
1
answer
431
views
How to copy files that match elements on a list?
Imagine I have many files whose names are of the form file#.tex
9that is, file1.tex, file2.tex, ..., file100.tex). I need to copy only those files whose number # is in another file named chosen.txt ...
0
votes
2
answers
629
views
Removing empty spaces from columns in VBA
I am trying to parse data in 2 columns, so that spaces no longer exist. I found this piece of code which removes the trailing and leading spaces, but not the spaces contained within. What changes ...
0
votes
1
answer
2k
views
Docx file from an XML file of docx
I was just wondering if there's any way to generate a docx file with a given XML file of a docx.I have been able to perform the reverse process i.e. getting the XML of a docx file as they are zipped ...
34
votes
10
answers
15k
views
How can I parse extremely large (70+ GB) .txt files?
I have several .txt files with >30 million lines each, and anywhere from 20 to 40 "columns" (some comma-separated, some space-separated, all ASCII with lines separated by a new-line). I ...
7
votes
1
answer
8k
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
1
answer
709
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
2
answers
1k
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 ...
4
votes
1
answer
2k
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
1
answer
338
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
2
answers
664
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
2
answers
198
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
1
answer
43
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
1
answer
60
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
1
answer
578
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
1
answer
39
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
1
answer
174
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
1
answer
872
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....
2
votes
1
answer
4k
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
0
answers
50
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
2
answers
985
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
1
answer
238
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
1
answer
11k
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
1
answer
8k
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
0
answers
610
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
1
answer
157
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
0
answers
59
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
3
answers
3k
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
0
answers
40
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
2
answers
4k
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
1
answer
215
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
2
answers
261
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 ...
3
votes
1
answer
4k
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
1
answer
142
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
3
answers
1k
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
0
answers
976
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
2
answers
283
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
0
answers
51
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
0
answers
2k
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
1
answer
2k
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
3
answers
219
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 ...
7
votes
4
answers
23k
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
1
answer
41
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
1
answer
106
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
3
answers
9k
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....