Stack Overflow
Stack Overflow

Questions tagged [delimited]

221 questions
1
vote
2 answers

Parsing string with multiple delimiters into columns

I want to split strings into columns. My columns should be: account_id, resource_type, resource_name I have a JSON file source that I have been trying to parse via ADF data flow. That hasn't worked for me, hence I flattened the data and brought it…
newbie
  • 53
  • 10
1
vote
1 answer

Powershell Performance tuning for aggregation operation on big delimited files

I have a delimited file with 350 columns. The delimiter is \034(Field separator). I have to extract a particular column value and find out the count of each distinct value of that column in the file. If the count of distinct value is greater or…
TomG
  • 281
  • 1
  • 2
  • 20
1
vote
1 answer

Delimited Vertical Bar in SQL Table to another colum table

I have table data textstring using separator '|' I've tried using SSIS to export to excel file and import again using SSIS to remove "|" and add to each column. like this But I was just wondering if any clue how to delimit to each column without…
kucluk
  • 540
  • 2
  • 9
  • 29
1
vote
2 answers

Python code to replace a pattern 'abc' with '*' in pipe delimted file

I am new to Python, I have a pipe delimited file and I want to to replace characters enclosed in single quotes with '*' which are present in the last column/4th column. abc|123|xyz|456|select * from table emp where custname='John' …
Afz Abd
  • 423
  • 3
  • 19
1
vote
2 answers

Convert txt file to mixed delimited output using python

I have quite a messy txt file which I need to convert to a dataframe to use as reference data. An Excerpt is shown below: http://amdc.in2p3.fr/nubase/nubase2016.txt I've cleaned it up the best I can but to cut a long story short I would like to…
KennyMcK
  • 35
  • 4
1
vote
2 answers

Using awk sed et al. to parse fields from a file having no end tags

My desired output is a comma-delimited file. If all else fails, I know that I can write a script with for/each logic or something, but I am hoping for an elegant solution using awk and sed, which have served me well so many times before. I'm just…
Jason908
  • 53
  • 5
1
vote
1 answer

How to return comma delimited string from array, in React Native

I have an array and I want to extract a specific column's values and return the items in a comma-delimited string. What is the best way to go about this? For the below array I would like to get the values of name and return "John,Tim,Mike" Thanks…
John Alexander
  • 45
  • 1
  • 8
1
vote
3 answers

Input Until Non-Word Character in C, Like Java's \W

I want to input words from a file which are delimited by anything that isn't a letter. Is there an easy way to do this in C similar to using the \W predefined character classes in Java? How should I approach this? Thanks.
Bob Winchester
  • 13
  • 2
1
vote
2 answers

MySQL select delimited data

I have inherited a table with information about some groups of people in which one field which contains delimited data, with the results matched to another table. id_group Name ----------------------- 1 2|4|5 2 3|4|6 3 …
Commsman
  • 23
  • 4
1
vote
1 answer

Split Embedded CSV Text Into Separate Rows

I'm trying to split comma-separated data into separate columns (using SQL Server 2008). I've seen similar questions on here, but in my case, the data contained in each row is BOTH comma-delimited and carriage-return-delimited. EXAMPLE: Date …
dhughes
  • 295
  • 5
  • 10
1
vote
3 answers

Php str_replace not working

i've got a long string which is space delimited (read in from a txt file) Input String: $value = "TestNumber1 X Chan 1 Wrap Hi (5.0 V) (UNC) 9.860 V GELE (>= <=) 9.750 10.250 Passed" What I want to do, and…
Dan Twining
  • 640
  • 4
  • 17
  • 30
1
vote
2 answers

Collect unique values from a 1d array of comma-separated values

Array ( [0] => Array ( [0] => abc@test.com [1] => qwrt@sometest.com [2] => haritha@elitesin.com ) [1] => Array ( [0] => Kanishka.Kumarasiri@elitesin.com [1] => Haritha@elitesin.com ) [2] =>…
kanishka
  • 89
  • 2
  • 9
1
vote
0 answers

Bulk Insert with text stream

After generating an SQL table using powershell with column names from the header of a delimited text file, I have successfully imported the tab-delimited file with some long fields into the SQL table using the SQL data import wizard by manually…
Ron Abbott
  • 11
  • 3
1
vote
0 answers

Using tab separation in linux/vim

I am having trouble with the cut command in linux. So say the original data looks something like this: 4567 Harrison Joel Accountant Mitchell Barbara Admin 3589 Olson Timothy Supervisor 4591 Moore Sarah Dept Note that in row 2, it is missing the…
CaroV1x3n
  • 135
  • 2
  • 2
  • 10
1
vote
0 answers

Spark Csv specify new line character

I am writing a data frame using spark csv library. I am using spark 1.6. I was wondering if there is a way to specify the new line character. Usually, I think it is \n. Or if not, is there a good solution to changing the new line character?…
Defcon
  • 807
  • 3
  • 15
  • 36
1 2 3
…
14 15