Stack Overflow
Stack Overflow

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.

A delimiter (Wikipedia) is a sequence of one or more characters used to specify the boundary between separate, independent regions in plain text or other data streams. An example of a delimiter is the comma character, which acts as a field delimiter in a sequence of comma-separated values.

See also:

3001 questions
0
votes
3 answers

How to split on a delimiter in python preserving the delimiter

so what i wanna do here is basically i have a file with a list of url endpoints, and i wanna split the links in the file on the slash delimter, basically generating sub-endpoints of endpoints, example: https://www.somesite.com/path1/path2/path3 and…
FozenOption
  • 5
  • 5
0
votes
2 answers

Regex Delete Lines with delimiter `<<<<<<< HEAD` and `=======` in Reverted Commit in Git in Notepad++

Using a bad regex I accidentally deleted many lines I shouldn't have. After reverting the changes (a feature of Git Version Control), I have markdown files that look like this now: <<<<<<< HEAD There was a sentence here: There was a third line…
zanodor
  • 137
  • 6
0
votes
0 answers

delimiter in TCP command send sequence

We need to split a data received from TCP , so we use a tcp delimiter # But if already # included in received data. Data split at # , and so the proper splitting of data is not occur. what is the way to split a data and any need to change a…
nadimnadaf
  • 31
  • 6
0
votes
2 answers

How to return values between two different delimiters using SQL?

I have a column bundle_availability_ids in Snowflake that has a value: 6891-HCB-ENG 6433C-MMW-ENG 6433C-MMC-ENG I would like to use SQL to return the middle value in this case to return (MMC,HCB,MMW) To return what's in the middle of what's in…
Catalina Tocasuchil
  • 13
  • 4
0
votes
1 answer

Read space separated text file in pandas

I am trying to read a text file present in this url into a pandas dataframe. https://opendata.dwd.de/climate_environment/CDC/observations_germany/climate/hourly/air_temperature/recent/TU_Stundenwerte_Beschreibung_Stationen.txt It has uneven spacing…
Chhandosee Bhattacharya
  • 79
  • 6
0
votes
1 answer

Parsing a text file with a tab delimiter

I need to parse this text file that has essentially four strings separated by a tab. I've been researching and trying different methods and I can't quite figure out how to do it. For example, I would need to parse this data: Sandwiches (tab) Ham…
VortexX Bolt
  • 15
  • 2
0
votes
1 answer

File fields and columns adjustment with awk [LINUX]

I have an issue with columns delimiters adjustment in a file in linux into a database. I need 14 columns and I use "|" as a delimiter so I applied : awk -F'|' '{missing=14-NF;if(missing==0){print $0}else{printf…
Mina El-Raheb
  • 23
  • 3
0
votes
1 answer

count txt file (pipe delimited special character qualified ±)

I have a requirement to count the number of records in a text file which is 600MB in size and some sample data is below. The data in this flatfile is delimited. The column delimiter used is pipe. And the data is qualified with a special character…
VKS
  • 1
  • 1
0
votes
2 answers

Second-to-last occurrence of delimiter-split string

What is the regex to extract second-to-last substring when the string is to be split by specified delimiter? E.g., the delimiter is comma , - I would only like to match words "matchX". a,b,match1,c a,match2,b match3,a match4, ,,match5,a ,,match6,
ZygD
  • 22,092
  • 39
  • 79
  • 102
0
votes
1 answer

How can I split a column in a table?

I want to use function split to a column in a table, so that each element can be a new column. For example, there is a column in the format of “aa, bb, cc“. How can I obtain new columns “aa“ “bb“ ”cc“?
dbaa9948
  • 189
  • 2
  • 10
0
votes
0 answers

Java Spring Batch with complex data structure

Currently I have a complex DTO which has an array in it like that: public class Dto { private String somethingObject; private List arrayOfObjects; } I need to do a batch work on them, and I have the following…
Bence Ágocsi Kiss
  • 21
  • 5
0
votes
1 answer

Arguments with delimiters, commas for nonconsecutive vals, or hyphens for a range of vals

The output of my script: Ch0 Ch1 Ch2 Ch3 Sample 0: 0x1a03 0x1a03 0x4a03 0x5703 Sample 1: 0x4b03 0x4403 0x1e03 0x0904 Sample 2: 0x1003 0x1903 0x4003 0xae03 Sample 3: 0x1e03 0x2603 0x3303 0xad03 Sample…
puppet_master
  • 65
  • 6
0
votes
1 answer

Different numbers of commas between fields in CSV files, throwing errors with pd.readcsv

I'm using the NOAA weather dataset to build a machine learning model to predict weather data. Python cannot read in this data as there are: a.) commas in the fields, and b.) different numbers of commas between each field. Here are the headers and…
Jenna Rink
  • 1
0
votes
0 answers

Splitting SQL columns by delimiter in SQL Server 12

I have a table called my_table in myDB SQL Server database. my_table contains: foo bar baz-12:1234:bom bim baz-34:5678:bom bim What select statement would return a column containing the third set of values '1234' in row 1 and '5678' in…
cristiandatum
  • 329
  • 2
  • 10
0
votes
1 answer

Delimiter after a quoted field, how to escape quote

I have that kind of file info1;info2;info3";info4;info5 And after parsing I have that error Error: [42636] ETL-2106: Error while parsing row=0 (starting from 0) [CSV Parser found at byte 5 (starting with 0 at the beginning of the row) of 5 a field…
CyclikP
  • 1
  • 2
1 2 3
…
99 100