Questions tagged [delimiter]
A delimiter is a sequence of one or more characters used to specify the boundary between separate, independent regions in plain text or other data streams.
delimiter
3,046
questions
0
votes
0
answers
27
views
Windows command using tokens & delimeters works from the command line but not in a batch file. EVEN WHEN the extra % is added
When I have the appropriate window open the following command works from the command line:
FOR /F "tokens=1 delims=," %A in ('tasklist /FI "WINDOWTITLE EQ Backup - C:\Backup.bat\"&...
-3
votes
0
answers
15
views
WHY IS 'DELIMITER' NOT WORKING IN MYSQL WORKBENCH Mac OS [duplicate]
I use a macbook pro(not sure if that's why it's not working) and i am currently learning how to create stored procedures in mysql, my tuutor use the DELIMETER FUNCTION and **it changed colour to green ...
1
vote
1
answer
40
views
Having an issue while working with an delimiter to convert the user_input to list or set
I want to delete the elements from the main_list and the elements are taken from the user as user_input where all the part of the code executed perfectly but the elements are not deleted from the ...
- 13
0
votes
2
answers
52
views
Is there a way to sort out alphanumeric codes in Excel from a string with zero uniformity?
So I have a list of parts that have been ordered for the maintenance crew at my job. There is almost zero uniformity across different records. Some are just a string of 6 numbers, others have letters, ...
- 9
0
votes
1
answer
110
views
CSV file is treating commas in string values as delimiters and shifting data into wrong columns. Is there a way to fix this in R?
I have a large csv file that I pulled from an online database that doesn't seem to read well. It looks like it treats commas in a couple of the columns as delimiters and then parses the data into new ...
- 21
0
votes
0
answers
53
views
Converting many words at once to another language
I'm trying to successfully convert parts of my website from one language to another with an api from aperitum.org, but the conversion is bad.
I begin by having an array of variables representing ...
- 9
-2
votes
1
answer
90
views
How to parse strings in C++ w/Delimiters? [closed]
This has been taking me forever to figure out and i have researched so many different examples, but some seem so convoluted and have extra steps in them for reasons A,B,C..... This is what I need-Let'...
0
votes
1
answer
51
views
VBA, convert cells with several paragraphs of text ->splitting paragraphs down into new cells
I have a spreadsheet with data like this:Spreadsheet Overview Image
In Column "A" I have multiple cells that are multiple paragraphs. Ideally my goal is to break each cell into multiple ...
0
votes
1
answer
44
views
excel VBA: "=" delimiter not functioning upon import
I have a .qtx file type with comma, tab and "=" delimiters. An example string of data is "STD_Gloss=4.08". I want to separate the 4.08 into its own cell, hence the "=" ...
- 1
0
votes
3
answers
75
views
Separating Strings into Dataframe
I have a problem that I've searched for and every solution led to another problem. I have a large unstructured dataset (4000+ rows). There are 24 columns but only the 1st column has all the data in it....
- 19
0
votes
1
answer
88
views
delimiter setting in to_csv pandas
using string of length 3 as seprator in DataFrame.to_csv() pandas
in to_csv() method of DataFrame, I want to set "sep" parameter as '&|$' and tried this code:
df.to_csv(path_or_buf='...
2
votes
2
answers
89
views
Replace all instances of a character, but only within matching strings
I have a data file in weird foramt that I'm trying to import and wrangle into R. The file is like a CSV in that values are comma delimited. However, there are also text strings containing commas that ...
0
votes
1
answer
42
views
Load a csv with comma as separator in hive where one column of unquoted string can have a comma in it
Goal: load a given .csv into hive.
Problem: one unquoted string column from that .csv has commas in it in certain rows. This produces rows where there are more commas than columns, making data wrong ...
- 1
0
votes
1
answer
37
views
In ML How do you keep the delimiter in the output of the String.tokens function?
Here is a basic implementation of the tokens function:
fun f c = c = #" ";
val testStr = "int main(){return 42;}";
val stringL = String.tokens f testStr;
It returns:
val stringL = ...
0
votes
3
answers
99
views
How can I handle extra commas in columns when importing data from a CSV file to DB using SSIS
Using VS2022 SSIS, I am attempting to import data from a notepad csv file with data like this:
CustomerKey, Name, Address, Country
1001, John, 23 Ave,nue, Australia
1002, Jeff, N,23 West St, Norway
...
