Stack Overflow
Stack Overflow

Questions tagged [delimited]

221 questions
0
votes
1 answer

Stripping Data from Excel Columns (Like Python Strip())

I'm trying to strip (or extract data) from columns in Excel. I'm not a power-user, although have done exactly what I want to do now in Python before but can't do so this time... ""slip""=>""20.0300006866455"" …
user18021
  • 3
  • 2
0
votes
1 answer

Read file and insert delimiter in output file with PowerShell

I've found the following code from @Kieranties that works really well for me except my input file does not contain a date in the first row. The output file does not input the date (that's ok) nor does it input the pipe delimiter in the first row. …
BJTYS
  • 3
  • 1
  • 4
0
votes
2 answers

Perl Combining first 2 lines of Pipe delimited file into one pipe delimited line

Trying to combine first 2 lines of a perl array as shown below: time |cpu |mem| stamp|util|util | to: time_stamp|cpu_util|mem_util| Using perl as this needs to work on both windows and linux
AdamR
  • 1
0
votes
1 answer

sqlite3 is not using end-of-line character when importing data

I have a tab-delimited file which I'm attempting to load into a table. The table has already been created and structured appropriately, the challenge is that SQLite3 is combining the last value on one row with the first value on the next row. So…
Meister1867
  • 1
  • 2
0
votes
1 answer

Split string into set of sub-strings with given length, delimited by separator

Looking for best solution to create a number of sub-strings such that the length of each sub-string does not exceed the length value in parameter. It should converts spaces to specified separator(let's use comma as an example) when enclosed in…
Andrzej Ambroży
  • 13
  • 1
0
votes
1 answer

TSQL Get Numbers as Range or Comma delimited

I'm trying to combine Numbers of Packagings, grouped on a Ordernumber. At the moment i combine this with STUFF as Comma delimited String. So i get now as example: 1-001, 1-002, 1-003 But if the Numbers are 1-001, 1-002, 1-003, 1-004, 1-007 i want…
Osti
  • 43
  • 6
0
votes
2 answers

SQL Server : using a query to generate a list of delimited numbers (with min/max threshold)

I did some searching here on this.. but it was either for PHP, Python or didnt relate. I understand this is somewhat of an odd use for a query.. I have an existing app. As a parameter to a section in this app (which is for name value pairs).. I can…
whispers
  • 962
  • 1
  • 22
  • 48
0
votes
0 answers

Parsing newline-delimited json in c#

I am making a game in Unity C# where request is made to external server every 10 seconds about the player's playing state. The server responses with newline-delimited JSON, for example.…
user3303274
  • 729
  • 2
  • 8
  • 21
0
votes
2 answers

MS SQL + output query as delimited string

I'm not sure if I am not understanding the example found correctly.. or if I'm doing something else wrong here... but I am trying to get a my query results returned as: 1.) One long delimited string 2.) Remove the trailing delimiter at the end of…
whispers
  • 962
  • 1
  • 22
  • 48
0
votes
1 answer

Search field in Excel with delimited text

I am having a data in such format (DELIMITED TEXT) How do I Vlookup "F88" to get 1 dynamic value. Thanks a ton
Sadsamosa
  • 11
  • 1
0
votes
1 answer

Processing CSV data in Python: Wireshark CSV, comma/list issue

So I am trying to break this CSV data down a bit more, and grab a specific comma delimited piece of text. It is a wireshark CSV. import csv with open('wifi.csv', 'rt') as csvfile: reader = csv.reader(csvfile, delimiter='\n', quotechar='\n') …
Kody Evangelist Dibble
  • 77
  • 1
  • 8
0
votes
3 answers

Converting multiple delimited fields into rows in SQL Server

I have a data source which contains data in delimited fields which exist in a staging area in SQL Server. I'd like to transform this data into many rows so it is easier to work with. This differs from the numerous other questions and answers on…
user2323503
  • 59
  • 7
0
votes
1 answer

Java OpenCSV Split by pipe limited

I am having an issue when reading from a file using comma split. I can read the file like this: CSVReader reader = new CSVReader(new FileReader(FileName), '|' , '"' , 0); Then when I want to get the individual values, I can read them like this:…
Jesse Hernandez
  • 307
  • 2
  • 15
0
votes
4 answers

How do I separate a comma delimited variable into multiple variables?

This is probably very elementary, but I'm still learning. I've imported a record from an XML file and have the result : "a,b,c,d,e,f,g,h" I would like to end up with 8 separate variables, one for each comma delimited value. What is the shortest way…
Kirt
  • 2,553
  • 2
  • 17
  • 11
0
votes
1 answer

Split, group, count and display data from delimited strings

I have a list of teachers with properties like: teacher 1 skills = English, Math teacher 1 gender = Male teacher 2 skills = Spanish, Math, Law teacher 1 gender = sex = Female teacher 3 skills = English, Geography teacher 3 gender = Male First of…
Roberto Marras
  • 153
  • 2
  • 11
1 2 3
…
14 15