977 questions
1 vote
1 answer
151 views
Line Separator Python \r\n
We have an English-Latin dictionary in our hands, that is, a list of words in English and their translations into Latin (there may be several translations) in the form of a file with the following ...
0 votes
1 answer
104 views
How do the meta variables in the following macro expansion work?
I am learning rust macros. In the part on repetition, the following macro is used to demonstrate how repetitions work: macro_rules! repeat_two { ($($i:ident)*, $($i2:ident)*) => { $( ...
-2 votes
2 answers
234 views
How to split columns in a CSV in Power Automate
enter image description here Hello everyone, you will find in my image a Power Automate flow with the creation of a CSV from a Power BI dataset. Everything works very well except for one small detail. ...
0 votes
1 answer
80 views
csv to dataframe with several delimiters and software bug
I would like to read in a csv-file. Sadly this is created by a buggy software: My header row contains multiple separators ";" and ",". Which wouldn't be a problem if my dataset ...
0 votes
0 answers
119 views
string format a Decimal instance using an underscore as a thousands separator?
I can easily do this for floats using an f-string like this: x = float(123456789.123456) print(f"{x:_f}") prints 123_456_789.123456 exactly as expected. But if try the same technique for a ...
0 votes
0 answers
45 views
Sqlite3 import csv with CRLF (2 chars) as row separator
I want to import a csv file with TAB column separator and CRLF (2 chars) as row separator. I use: .mode ascii .separator "\t" "\r\n" to which sqlite3 complains: Error: multi-...
0 votes
1 answer
71 views
Unexpected Decimal Separator Behavior with CultureInfo in .NET
In the attached images, you can observe that I am explicitly using both InvariantCulture and a new instance of CultureInfo("en-US") when converting a Double to a String: value.ToString(...
3 votes
3 answers
163 views
R: how to split strings into three columns using tidyr
Here is how one column in my data looks like: dat <- data.frame( A = c("M24656811 M24677722 GREEN,SMITH34/M/B", "M24654999 DOE,JANE V37/F/W", "M24333107 DOE,JOHN24/M/B"...
0 votes
0 answers
12 views
How I can split a cell which contains a text to different rows whithout loosing whole sheet format?
enter image description here image from a part of my spread sheet. how can I divide rows number 35-37 to a single row like 34. In the image for example names and numbers are in wrapped text format but ...
0 votes
1 answer
89 views
Unable to Change Comma to a Dot in Decimals in R [closed]
I have a .csv file that I’m having trouble processing because the numbers use commas for decimals, which causes issues when reading the file in R. Excel interprets commas for decimals, while R uses ...
2 votes
1 answer
115 views
Control {fmt} formatting of nested containers/ranges
If I have a range I can print it with the fmt library, in this way: https://fmt.dev/8.1.0/api.html#ranges-api #include <fmt/ranges.h> std::vector<int> t = {1, 2, 3}; // Prints "[1, 2,...
0 votes
1 answer
37 views
Concatenate values with "/" separator in XSLT 1.0
I have XML with product's parameters like colors. <parameter name='color'> <value>black</value> <value>white</value> </parameter> I want to output a value ...
2 votes
1 answer
74 views
Django - change form prefix separator
I'm using form prefix to render the same django form twice in the same template and avoid identical fields id's. When you do so, the separator between the prefix and the field name is '-', I would ...
0 votes
1 answer
62 views
Splitting R string based on multiple criteria (data does not have a simple delineation like spaces or comma to separate by)
I have a dataset where each row is a character string like this (and this is all under one column): Jacoby BrissettO 206.5-115U 206.5-115Joe BurrowO 243.5-115U 243.5-155. I want to split this into ...
1 vote
0 answers
165 views
Display a list comma separated taxonomy terms with "and" as final separator in Wordpress
I'm trying to output a list of custom taxonomies on Wordpress where the final separator is an &. I have three potential taxonomies a post could be in: Category 1, Category 2, and Category 3. Some ...