90,344 questions
-1
votes
0
answers
20
views
SSIS flat file connection manager - used "Delete" columns now columns out of sync [closed]
The questions are at the bottom.
I am building an SSIS package to process multiple CSVs. One of the CSVs has problematic columns containing URLs, some of which contain the double quote text qualifier ...
-1
votes
1
answer
64
views
How can I specify a variable amount of whitespace as CSV import column separator?
In SQLite:
.separator " " # is one space
.separator , # is a comma
.separator "\t" # is a tab
But how can I specify a variable number of spaces for CSV import? E.g.:
<<...
- 600
5
votes
1
answer
83
views
MariaDB import csv file that doesn't have commas at the end of lines [closed]
I'm trying to import a CSV file to a MariaDB table using this query:
load data local infile 'C:\\Users\\Kevin\\Downloads\\TCGToday.csv'
into table tcgtoday
fields terminated by ','
optionally enclosed ...
- 53
0
votes
1
answer
134
views
Trouble getting R to read data values as numeric [closed]
I am trying to run analysis on salmon aquaculture mortality data to identify events where mortality of >7% of stock was lost, however when I try to get R to read the values in my mortality column I ...
- 11
0
votes
0
answers
27
views
Change Delimiter Type in SPSS so that it can be converted to CSV?
does anybody know how to change delimiter in SPSS settings so that when i convert it to csv, the new delimiter applied automatically? or is there any other easier way?
Advice
1
vote
11
replies
157
views
MS Excel displays garbled characters for Azerbaijani text in CSV file exported with UTF-8 encoding
I'm generating a CSV file with Azerbaijani text using Java and UTF-8 encoding with BOM. The file opens correctly in WPS Office, but when opened in MS Excel, Azerbaijani characters appear as garbled ...
0
votes
1
answer
161
views
How to decode this mojibaked CSV using PHP? [duplicate]
I'm trying to write an importer that processes a third-party CSV and ingests it into a MySQL database.
A lot of the lines in the CSV are fine but there's the occasional entry with what appears to be ...
- 71
1
vote
1
answer
35
views
Chinese CSV Headers Become Garbled When Importing to DolphinDB with loadTextEx
I have a CSV file where only the header row contains Chinese characters, while all the data values are in English. I'm trying to import this file into a DolphinDB distributed database using the ...
- 25
Advice
1
vote
8
replies
78
views
Searching for strings in multiple text files and outputting matched lines to a CSV
I have a folder full of hundreds of text files formatted like so:
holdrod =fl__2183_180325_0045
<bunch of data>
measburn_tot = 189.260915
<bunch of data>
I want to use ...
- 87
Best practices
1
vote
11
replies
6k
views
Reading data more efficiently from a csv file in python
I am programming an neural network to recognise digits trained on the MNIST dataset. At the moment I am reading each line separately using the following code:
file = np.loadtxt(dataLocation, delimiter=...
1
vote
3
answers
118
views
Removing $null or Blanks from CSV Results
I have a CSV that contains this information:
TEST1,TEST2,TEST3,TEST4
100,200,300,400
,,,
,,,
,,,
,,,
,,,
,,,
,,,
101,202,303,404
If I run this script
It returns the following:
It includes the $Null ...
- 37
1
vote
1
answer
67
views
Flutter skipping UI frames only on startup
When I try to start the app for the first time, some frames silently freeze. For example my splash screen doesn't show but my home page comes up. Also some functionalities don't work in other screens.
...
0
votes
1
answer
234
views
Return urls to Excel range
I made and have been using an Excel sheet at work for the last 6 months.
In the last few days some of my macros are no longer functioning as expected.
They stop and require debugging.
Sub Hour_1()
...
Advice
2
votes
5
replies
64
views
Find maximum value per group from CSV file
I have a CSV file with columns like:
student_id,subject,score
S001,Math,85
S001,Physics,92
S001,Chemistry,78
S002,Math,88
What I want to do is:
Filter rows by a given student_id
Find the highest ...
2
votes
2
answers
126
views
PowerShell Strings from headers is this possible?
I'm trying to create a script to make reading a CSV easier for a task I'm carrying out.
E.g. I have a csv with the following headers and values
Value1,Value2,Value3,Value4
10,20,30,40
11,12,13,14
I'...
- 37
