Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [csv]

Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.

1
vote
2answers
32 views

Splitting a xlsx/csv file based on column value

I'm aware this question has been asked previously, but I've had no luck with previous answers. My spreadsheet has around 30000 total lines. My spreadsheet is formatted like this: Name,colour,...
0
votes
0answers
8 views

How do I write to a CSV file with multiple commas? [migrated]

This is my code for the write file: public void CreateCSV(PerfomanceBST[] temp) throws IOException { try (PrintWriter writer = new PrintWriter("InstrumentationCSV.csv", "UTF-8")) { String ...
0
votes
0answers
5 views

how can i export an specified instagram chat and view it in a clear way? [migrated]

how can i export an specified instagram chat and view it in a clear way ? this feature is available in whats app ... the only thing that is available in instagram is a full backup that ...
2
votes
1answer
17 views

Limiting the number of rows imported into Excel from a large CSV file

I have a large CSV file with approximately 70,000,000 rows. I have read how to import it into Excel as a data model and then pivot table here. Is there a way in Excel to just load a certain number of ...
-1
votes
1answer
28 views

Deleting rows in Excel using powershell

I have a csv file which has a series of pin-codes in column A but the first row/cell (A1) is empty and I need to delete the whole row using Powershell, any ideas? I have tried this but it did nothing!...
0
votes
0answers
34 views

CSV file with headers for office 365 migration

I am using the CSV file with headers only template from microsoft to import multiple users in the migration wizard for Office 365 Exchange Online...however once populated and saved. When i verify on ...
0
votes
0answers
21 views

Excel 2019 not opening CSV correctly - not parsing columns

When I open a CSV files in Excel 2019 the file is not being parsed correctly. When I opened the same files in Excel 2016 they would be parsed correctly, with the commas used as delimiters. But I have ...
0
votes
1answer
14 views

Mail Merge with formatting alters data

When I perform a mail merge with no formatting (the Merge Field being "MERGEFIELD Cycle1Subject1StudentPercentage"), the answer that appears is correct "52.33" However, if I do it using a formatting ...
0
votes
0answers
20 views

Extracting Text from HTML Files

In Windows, how would I go about parsing a folder full of HTML files and extracting all the strings between a particular tag pair? Ideally, this would all go into a CSV file, with one field for the ...
0
votes
3answers
48 views

Remove hyperlink text from csv

I have a csv file (created in excel file) whose first 2 lines are somehow like this: "=HYPERLINK(""https://some.url/browse/ISSUE-3146"", ""ISSUE-3146"")","Bug","Related Case : Some description ",0.0,...
0
votes
0answers
58 views

Multiple excel data copy into one excel

I have multiple CSV file data i need to copy all CSV data into one excel based on the cell value Like Source excel sheet1 B2:C2 to till end row data i need to copy Target Excel Sheet3 Column B2:C2 ...
0
votes
0answers
44 views

Can I automatically create a table in mySQL from a csv file with headers as column names?

I would like to import data from a CSV file with column headers into a database. I can do this with the COPY statement, but only if I first manually create a table with a column for each column in the ...
0
votes
1answer
36 views

Why Import-CSV “names.csv” | Where { $_.Id } not working? [closed]

I am working with this CSV file and the Import-CSV "names.csv" | Where { $_.Id } gives nothing. Tell me why? I want to choose from this file those lines in which the value of the name column is more ...
-2
votes
0answers
35 views

How to export clickhouse data table?

I want to export the clickhouse data table with more than 10000 rows plus. How to can I export my clickhouse data table to csv file???
0
votes
0answers
8 views

Crystal Reports US Zip Code Sorting

I am creating address labels in Crystal Reports but they will not sort correctly. My data source is a csv file exported from an online address list. Here is what I have done: Connected to the csv ...

15 30 50 per page