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
1 answer

Parsing CSV file with non normalized data and overloaded delimiter in NodeJS

My aim is to parse a CSV-dataset with non normalized data in some rows which is enclosed in "". I cannot split it by ";" because this char is also used inside of the data. I ask myself, if there is an easy way to solve this!? Some rows contain non…
A.T.
  • 127
  • 9
0
votes
1 answer

MDX problem: Source data in columns can contain square brackets ([ ]), how to stop these being interpreted as delimiters?

I am working on a project that is using OLAP cubes, and we have a problem with an MDX statement. The problem is that our source data has square brackets in. For example: Customer [customer code] This is an example query on a specific customer,…
jjk
  • 11
0
votes
0 answers

Delimiter coming in data

I have the below code in a batch file. Here MYDB is the database, Activity_Inc.sql is the script file and ST_Activity- is the csv file generated with the data. | is used as the delimiter. Now, the problem is with few records where the data is also…
Meen
  • 119
  • 3
  • 15
0
votes
1 answer

Any way to find which delimiter might work for excel file using python?

I have 20+ excel files in Japanese language. Most excel files are Microsoft Excel 2007+ and few them are in Microsoft Excel OOXML file type. I would like to convert these files to csv and load in Snowflake, but prior to converting to csv, I was…
biggboss2019
  • 220
  • 3
  • 8
  • 30
0
votes
1 answer

Customizing SQL Server delimiter using query

I am writing a query in SQL Server that its output a table. I want the query result delimiter to be #|#, how can I do that? So if I output it to txt/csv file, it should look like this:
Python Kfir
  • 3
  • 3
0
votes
0 answers

Interpret CSV with equal delimiter values in Python 2.7

I need to create the following solution, I have a CSV file that the delimiter is a comma (,), but in one of the columns this comma can come by error in the user registration. The CSV scenario is this: francisco, 17, fran-mail@gmail,com, blue kai,…
user16252641
0
votes
2 answers

Regex to extract irregular delimiters

I have a column of data containing id numbers that are between 4 and 10 digits in length. However, these id numbers are manually entered and have no systematic delimiters. In some cases, id numbers are delimited by a comment. With the caveat that…
Michael Covell
  • 55
  • 5
0
votes
1 answer

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL

Delimiter$$ create trigger salary_delete before delete on salary for each row begin insert into salary_dele(eid,validfrom,amount) value(old.eid,old.validfrom,old.amount); end if; end$$ delimeter; UNABLE TO FIND THE MISTAKE .PLEASE HELP
Ujwal Waderaa
  • 1
0
votes
1 answer

PostgreSQL - how can I Add separators to an undelimited date column?

I have a date column that is of a string format. The dates appear like, DDMMYYY or DDMYYYY 04032021 0412021 It has been a nightmare trying to split them and add '-' because they aren't all the same length. Not like a standard format of DDMMYYYY. I…
SunManULTO
  • 1
0
votes
0 answers

Escape character for text ";" in csv

I have a script that calls an api and returns a text that I save in a csv. The api sometimes returns a text containing ";". This ";" is the delimiter of the csv so it generates new columns in the file. How can I do to "escape" the semicolon and not…
Jonatan
  • 45
  • 5
0
votes
2 answers

SSIS - fields without the same number of characters causing space delimited file to push data to the next column

I am having a problem with a space delimited file I am uploading to SQL. This works as needed except there is a column which has occasional length differences which is separated by a space delimiter... As you can see from the data viewer the column…
Will
  • 228
  • 1
  • 2
  • 15
0
votes
1 answer

How to remove the '\t' delimiter from the Column in dataframe with mostly float type values

I have in my Dataframe Float type columns with few '\t' while all other values are float type. I cannot remove them without making them the float values 'NaN'. I used following command, then all the float values become NaN. df["col"] =…
SJa
  • 487
  • 4
  • 14
0
votes
3 answers

How can I parse out of the last instance of text after a delimiter (big query)

Ex of value: [{‘test’:’https://‘,’id’,’2521’,’Shipment’}] I would only want to return Shipment as the value returned for that field
Taylor
  • 31
  • 2
0
votes
1 answer

How to read CSV in pyspark with "," delimiter but not ", "

I am using the following code to read the CSV file in PySpark cb_sdf = sqlContext.read.format("csv") \ .options(header='true', multiLine = 'True', …
jf3440
  • 1
  • 1
0
votes
1 answer

awk - understanding how FS works

I know that default FS= " ", then why am i seeing variations in following awk commands. Please help me understand. >echo " ABC DEF XYZ \n abc def,ghi xyz \n" | awk '{printf("nf: %s 1:%s line: %s\n", NF, $1, $0)}' nf: 3 1:ABC line: …
Mohan
  • 141
  • 3
  • 13
1 2 3
…
99
100