Questions tagged [CSV] (240)

1
answer

How to delete duplicate row from a CSV (PHP)?

There is an array in php array $list = array ( array(", $_POST['subject'], $_POST['time'], $_POST['text'], $_POST['name_html'],"), ); Is the. CSV file. First, I add to the end of this array in array'e and get one new row with data obtained from a POST request. $list = array ( array(", $_POST['subject'], $_POST['time'],...
maxime asked April 19th 20 at 11:52
1
answer

How to remove the forward slash when writing the comma CSVPrinter'Ohm in a cell?

Use the CSVPrinter in this format: CSVFormat csvFormat = CSVFormat.DEFAULT.withEscape('\\').withQuoteMode(QuoteMode.NONE); It enables you to capture quotes. Be written as: csvPrinter.printRecord("TYPE_NAME=SO_OrgCategory_SCH;KEYS=Owner,Idx"); The cell displays this way: How to get rid of the slash?
callie_OKeefe asked April 18th 20 at 12:57
1
answer

How to write in excel file quotes are \ " using CSVPrinter?

When writing a string in the excel file, I use the CSVPrinter, respectively, with the EXCEL. output = new OutputStreamWriter( new FileOutputStream("so_spp_personorg_" + settings.getReplicaIdSpP().toLowerCase() + ".csv", true), "Windows-1251"); writers.add(writerSpPPersonOrg = new CSVPrinter(output, CSVFormat.EXCEL)); Some ...
addie_Botsford68 asked April 18th 20 at 12:13
1
answer

What could be the problem with the unloading of goods in WooCommerce?

Import CSV file in the WC, everything is OK, but in the end all the words are converted into symbols
lauriane.Gorczany asked April 16th 20 at 10:54
2
answers

Export list of users with expired passwords from AD?

Good day! Did not get the script to tame with the export list to a file, users with expired password, the console appears correctly in the file does not work to export , the lower which is available: $filename = Get-Date-Format yyyy.MM.dd $exportcsv=”c:\ps\expired_password_” + $filename + “.csv” $Users = Get-ADUser -Searc...
Johnnie_Conn58 asked April 16th 20 at 10:12
1
answer

How on JS to arrange a search for CSV and results to 20 items per screen with loading at scroll?

The question arose when building a prototype how to JS to organize a search for CSV and results to 20 items per screen with loading at scroll? Use hand script or is there a standard JQuery example?
Bennett.Marquar asked April 9th 20 at 10:29
3
answers

What is the difference between a database in csv and sql?

Don't quite understand the difference between the base in the format of csv tables and full-fledged base in python. Does the use of the database for speed or convenience in comparison with the table. It is planned in the future search for the database or table. The number of records can reach a million
cyrus_Luettg asked April 9th 20 at 09:48
2
answers

How to make search in the table with a connection to Active Directory to obtain the user's email and send him the values that user?

Hello ! Can anyone have idea ? There is a file csv with names and values. Need to do a search by name, connect to AD to get user and send the values unloaded from AD address.
timmy27 asked April 8th 20 at 18:12
0
answer

How to implement composition in OpenCSV?

Hello, there are two Bina public class Person { private long id; private String name; // getter setter } public class Job { private long id; private Person person; // getter setter } In the documentation the example is given in which the nested bean is represented as a list: public class Person { @CsvBindByPosition(p...
alexandrea asked April 8th 20 at 17:57
1
answer

Not written to CSV file python, how to fix?

#!/usr/bin/env python # coding: utf-8 from threading import Thread from googleapiclient.discovery import build import pafy import csv import os import sys youtube = build("youtube", "v3", developerKey="REPLACE ME") # in the original, here's my token DIRNM="videos" QUERY="Horses" PAGES=2 MAXSZ=100 * 1000 ** 2 # 100 megaby...
jalen asked April 8th 20 at 17:34