Stack Overflow
Stack Overflow

Questions tagged [delimited]

221 questions
0
votes
2 answers

Update nth element in delimited line [unix scripting]

i have a .temp file that contains comma-delimited lines: abc,1,000,aaa,zzz,2,234,OOO,00001,01,123,214 def,2,003,bbb,yyy,4,345,PPP,00002,02,133,224 ghi,3,011,ccc,xxx,6,456,QQQ,00003,03,143,234 jkl,4,012,ddd,www,8,567,RRR,00004,04,153,244 ... each…
dcdum2018
  • 93
  • 1
  • 9
0
votes
1 answer

Multi-char delimiter while performing CTAS - HIVE

I am trying to create a table (CTAS) and I want it to have a multi-char delimiter to it like let’s say “#$“ or “^|^“. Query: CREATE TABLE IF NOT EXISTS ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH…
Ravi Raj
  • 31
  • 1
  • 5
0
votes
0 answers

how to denote an end of line character in excel so csv file doesn't contain extra delimiters

I am trying to create a CSV file off an excel file. the problem is, whenever I create the CSV file, it treats every cell in the header/trailer as a cell with information in it. What do i do to prevent those extra trailing , (commas) in the…
jimbo10583
  • 1
  • 1
0
votes
1 answer

Seeking more efficient formula for extracting fields from a delimited text string

I am using the following long formula for extracting specific fields from a delimited string. The formula works fine, but is there a more efficient way, noting that it must support very large strings with 100s of delimited…
Katoomba
  • 9
  • 2
0
votes
3 answers

Converting a TXT file with double quotes to a pipe-delimited format using sed

I'm trying to convert TXT files into pipe-delimited text files. Let's say I have a file called sample.csv: aaa",bbb"ccc,"ddd,eee",fff,"ggg,hhh,iii","jjj kkk","lll"" mmm","nnn"ooo,ppp"qqq",rrr" sss,"ttt,""uuu",Z I'd like to convert this into an…
Dino Dinz
  • 13
  • 4
0
votes
2 answers

Explode and transpose nominated comma-separated strings of an associative array

I have an array with comma-separated values like below: array:5 [ "manufacturer" => "BB" "width" => "245,225, ..." "height" => "45,65, ..." "diameter" => "19,17, ..." "type" => "AA" ] There is no limit to how many comma-separated values…
nas
  • 2,289
  • 5
  • 32
  • 67
0
votes
1 answer

How can I strip all quotes and re-add in text-tab delimited file with Notepad++

I have some fairly dirty text tab data that I need to import in SQL Server. It's failing because one of the column delimiters goes out of whack. This is because double quoting is occuring in some of the columns. I'm struggling to put it right, my…
PocketTim
  • 87
  • 10
0
votes
2 answers

How to remove first joined row Talend DI

How to delete first matching row in a file using a second one ? I use Talend DI 7.2 and I need to delete some rows in one delimited file using a second one containing the rows to delete. My first file contains multiple rows matching the second one…
K4tn1x
  • 133
  • 3
  • 14
0
votes
1 answer

how to load data into BigQuery with caret(^) delimiter

I have went through documentation for all the supported file types in BQ. But I came into this issue. Consider, I have a sample compressed file .gz with format as - filetype : col1^col2^col3 d1^d2^d3 Command: bq load --source_format=CSV…
Shivkumar kondi
  • 6,458
  • 9
  • 31
  • 58
0
votes
1 answer

Importing and Delimiting Text File

I am trying to write a code that will allow me to import an external text file and format it by column. I have tried a few different methods and I think delimiting is the best method for what I want to do. Sub Import_TxtFile() Dim TXT As…
ahamhpesh
  • 1
  • 2
0
votes
1 answer

Iterate over Whitespace Delimited Text Line and Retrieve Fields

I'm trying to iterate over a whitespace delimited text record in JavaScript and retrieve the individual fields within that record. Each field is seperated by a fixed amount of spaces that is referenced within a separate JavaScript object. var text…
Nick The Dev
  • 3
  • 2
0
votes
1 answer

I would appreciate comments on parsing a complex tab delimited text file using Python

I wonder if anyone can help? I am a beginner with Python, have been using pandas and sklearn to analyse well formatted csv files, but now I want to extract data for analysis from a tab delimited text file with more complex formatting and I'm not…
Hamish
  • 1
  • 1
0
votes
1 answer

Data Wrangling in R: Malformed input delimited file with records spreading to multiple lines [readr]

I have a delimited file that has errors when it was dumped to a flat file. Multiple records where wrapped and the overflow was saved as a new line. Table A has dimensions n x 25 Every record is enclosed by " Some records split into 3 lines of 8,…
MrPmosh
  • 100
  • 12
0
votes
3 answers

Where to start in PHP for a script that rearranges tab delimited data

This would be one of my first PHP projects. Where to start in PHP for a script that rearranges tab delimited data. I have a tab delimited data text file that needs to be rearranged periodically. Some entire columns would have to move to different…
Brandon
  • 25
  • 7
0
votes
1 answer

How to get count of word occurrence at specific location in delimited file in Unix

I have pipe delimited file, I want to check for value 'America' at 5th position (column) of each record. America word can appear in any other columns as well, so grep -o is not giving correct result. Any other way to check the occurrence of word at…
dnyan
  • 3
  • 2
1 2 3
…
14 15