Stack Overflow
Stack Overflow

Questions tagged [delimited]

221 questions
0
votes
1 answer

How to include a beginning AND end in an audio file in html?

I'm trying to add several audio files with very precise beginnings and ends. I'm not an html expert, but so far the best and simplest formula I've found is #t=262,302 That works fine (with Chrome) for the beginning mark (262), but not the end (302).…
J.J. Surbeck
  • 1
0
votes
1 answer

Google Sheets: Filtering based on split strings

I'm trying to create a filtering sheet where I can enter multiple words in a single cell, delimited with a comma, and return any row that contains any of those terms. I've created an example spreadsheet. The problem I'm having is that I need to…
RJoshField
  • 3
  • 1
0
votes
2 answers

REGEXP_SUBSTR with pipe delimiter giving unexpected results

For this data in a packed field: ONE|TWO|THREE|FOUR|FIVE|SIX|SEVEN|EIGHT|NINE|TEN|ELEVENTHEBAND|TWELVE I have this regexp: REGEXP_SUBSTR(the_packed_field_column , '((|)([[:alpha:] ]*)(|))' , 1 , 1) <--gives the expected result of TWO but this…
mojave
  • 21
  • 4
0
votes
1 answer

Group 1d array of filenames by their leading text and join filenames in each group with a delimiter

I have a flat array containing filenames. I need to group the filenames by their leading substring and form pipe-delimited elements. Sample input: $j = [ 'ma_1_49812_5318.jpg', 'ma_1_49812_5319.jpg', 'ma_1_49813_5320.jpg', …
Assaf Schwartz
  • 119
  • 1
  • 7
0
votes
1 answer

Is it possible to Load Data directly from Multiple Excel Sheets Into Pipe Delimited TXT File using SSIS..?

Can we load the data from a multiple excel sheets into txt file using SSIS without a temp table in between..? I Tried it by loading the data of the multiple excel sheets into a table. After I loaded the data from the table into a TXT file. Is it…
Thiruna
  • 1
0
votes
0 answers

Hive Table and Ascii Delimited File structure mapping

what if ascii delimited file and hive table structure not match if still can we load data? Like I have hive table in that one column present in hive table structure but ascii file do not have that column, then How can identity or cast that…
dev.nv
  • 1
0
votes
1 answer

Finding the average of values that are part of a delimited string

I have an Excel file that contains hundreds of rows and columns of delimited data. Every cell looks like these two sample cells, and it used alphas and symbols to represent a specific…
Lauren Quantrell
  • 2,647
  • 6
  • 36
  • 49
0
votes
0 answers

R read.delim is skipping first column of txt

I have a delimited text file that looks like this: df1 <- data.frame( ID = c(111, 121, 113, 211), NAME = c('Jim', 'Jon', 'Jan', 'Jack'), CAT = c('A', 'A', 'B','A')) After reading into R with read.delim it looks like this: df2 <- data.frame( ID …
Jorge
  • 336
  • 1
  • 4
  • 15
0
votes
1 answer

how do i get an array into a comma delimited string with single quotes in powershell

I have tried all the main PowerShell websites and have not found anything yet can someone please provide a code snippet that takes an array like this: and wree test the and converts it to: 'and','wree','test','the' . here is some sample…
andrewmcg
  • 1
0
votes
2 answers

Regex to find two strings within a pipe delimited string

I need to find a match within the delimited string if the following two words appear between the pipes: apple and red Example string 1 (should give a match): |big blueberries blue|awesome lemon yellow|apple nice delicious red| Example string 2…
apples-oranges
  • 959
  • 2
  • 9
  • 21
0
votes
1 answer

Remove specific roles from delimited list of users (Discord/Python)

I'm trying to make a little bot that will remove specific roles from a list of users I specify. I have all of the id's and usernames of the users I need to remove roles from, but I don't know how to code it to allow for a long delimited list as a…
user3108489
  • 363
  • 1
  • 4
  • 15
0
votes
1 answer

MySQL Fishbowl Custom Field Deliminated and Numbered

I have single Column entry "Custom Field" and it's contents can grow and shrink. The structure of said column is: {"10": {"name": "", "type": "Text", "value": ""}, "11": {"name": "", "type": "Text", "value": ""}, "12": {"name": "", "type": "Date",…
Eric
  • 1
  • 1
0
votes
1 answer

Get multiple sensor values with http.GET()

I have a php file in my website which returns sensor reading. I had been fetching this reading and displaying in my Serial monitor using the below code http.begin("http:///fetch_sensor.php"); int httpCode = http.GET(); …
Intelli
  • 1
  • 5
0
votes
1 answer

Most Pythonic way to eliminate duplicate entries in a delimited string (not a list) and returning the sorted result

I have a need to do some processing on many thousands of strings (each string being an element in a list, imported from records in a SQL table). Each string comprises a number of phrases delimited by a consistent delimiter. I need to 1) eliminate…
evand
  • 97
  • 8
0
votes
1 answer

Sort string values delimited by commas in a column using pandas

I have this dataframe, and I'm looking a pythonic way using Pandas to sort these values. Column 2 is a string. C1 C2 0 b,g,f 1 a,f,c 2 f,e,a,c The Output should look like: C1 C2 0 b,f,g 1 a,c,f 2 a,c,e,f
Luis Alejandro Vargas Ramos
  • 990
  • 2
  • 8
  • 18
1 2 3
…
14 15