7,881 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
1
answer
96
views
Conditional formatting in Excel for product codes with specific prefixes
I need an Excel conditional formatting formula or VBA to identify product names in a column to highlight cells red if the product name contains two or more sub-products (number+letter codes like r600, ...
0
votes
0
answers
54
views
How to extract first n rows of a .tsv.bgz file with gsutil?
How to extract the first n rows of a block compressed tab-separated value text file (.tsv.bgz), which could only be accessed with gsutil, into a text file? The original file is very large, so I wonder ...
1
vote
0
answers
123
views
Extract SAP cell value and copy to cell in excel
I use VBA to show 1 value from SAP (Total in COOIS).
All works well but I have to type the value into Excel because the Total value is every time on another position, and I can't find how to copy into ...
0
votes
0
answers
187
views
How can i get the User-Defined results from Plaxis 2D by python code?
I want to obtain an excel file as well as printed results of the "Ru, max" values (Liquefaction values) of my plaxis model by coding in its python API.
I have modelled a soil column in ...
0
votes
2
answers
94
views
Can't Extract Hashtable/Stringified Custom Values from Powershell
I'm trying to extract info from a JSON file via a ConvertFrom-Json command. Its format is:
{
"Id": "0",
"Name": "John",
"Actions": [
...
0
votes
3
answers
123
views
How to auto extract cbz in subfolders on windows?
I have a directory with a bunch of subfolders and each subfolder contain a cbz file.
Extract each .cbz file.
If the extraction creates a subfolder, move its contents up to the .cbz file's folder.
...
0
votes
1
answer
79
views
Filtering by month name after EXTRACT(MONTH) – best practice or mistake?
I’m writing a query to calculate the total monthly sales per employee and display only the data for April. I’m using PostgreSQL, and while the logic seems fine to me, the output isn’t working as ...
0
votes
1
answer
61
views
python lxml and getting a table from word document
I'm working on pulling some information from word document. I have multiple tables in it and i want to get 1 specific table that does not have any specific location in the document that could be ...
-1
votes
1
answer
64
views
Data extraction from Spring boot classes
I've been trying to get some data from classes instantiated by Spring boot, like controllers and services, to display them in local program, the same on that is supposed to start the whole thing. ...
-1
votes
1
answer
72
views
Seeking to extract certain including "/"n"p" where n is a digit or may not exist
Using Google Sheets: I'm trying to extract the price e.g. 250, 990 and 1760, the currency e.g. CZK, and problematically the text /p, /2p or /3p from some text field. Some example lines are shown ...
3
votes
2
answers
96
views
Extracting a variable part of a string
I have learned that subtracting two dates in Db2 results in a number which is to be interpreted as an interval:
SELECT current_date - '1943-02-25' FROM SYSIBM.DUAL;
-- 820020: 82 years, 0 months, ...
0
votes
1
answer
104
views
Which formula to use in Power Automate to find a number from a txt file?
Good afternoon.
I am working on Power Automate and I would like to create a compose action that extract a specific data from a .txt file (Mail1.txt).
I would like to extract the number which is ...
0
votes
0
answers
43
views
How to extract a specific column information from a pdf using flutter
I have a pdf file which has a table. Inside the table I have multiple columns. I want to extract the data from a specific column for all the entries. The pdf might contain multiple pages.
I am able to ...
0
votes
1
answer
75
views
Extract specific conditional string SQL Redshift
I want to extract only val2 from the below column1 of a table, I'm not sure how to do it with SQL though I've tried with regexp_subtr/instr, the length of column values are dynamic but the contents of ...
1
vote
1
answer
45
views
It is not possible to extract specific columns of data in gnuplot based on a specific heading
In the following Gnuplot script, I want to extract values from a specific table. This works fine for columns that contain numbers but I cannot extract the path from the column "Measure:volume&...