Csv Related Problems & Solutions

63 tags
Refine Tags
Search Tags:

Start a discussion

Results 1 - 30 of 63
Reorder(Sort) rows in CSV using python based on other column
Summary: I am trying to reorder rows in csv where I want to have "All" as the last row, in csv. I have tried using sort_index and sort_Values but I have not be...

[Solved] how to echo variables into .csv file with colors?
Summary: Hi all, I have the following line in my batch file: echo.%%a;%%b;%%c>>D:\output.csv which will import my variables into a...

[Solved] how to devision and rounding in strings?
Summary: Hi all, I'm working with a tool which is exactly like windows cmd. my input text file is : age=min;age_1D_param_min_64;meas_time = My batch file r...

mysql databases, purge and importing a csv via cron
Summary: hi, i am a complete noob when it comes to mysql databases. what i want to achieve - is this - i have a sap b1 database and i am going to be exporting ...

Sending attachments to a list of Email addresses in CSV
Summary: Hi, I have a directory - which is updated on a daily basis with CSV files. I then will have another CSV file (can be in another directory) which will ...

[Solved] powershell, compare 2 csv, replace if there is a match
Summary: Hello, I have 2 csv files, 1.csv is with all data, 2.csv is with a parth of that data (fewer columns). The headers are the same. I want to compare bot...

Export certain columns from a csv to a new csv using batch
Summary: I have the following CSV file with 30+ columns in a csv called thirtycol.csv. 597156,1,"XDTEST","925598024","INVOIC","<none>","",5,1,1453910813,0,0...

[Solved] Rename .csv Files based on its content
Summary: Hi community! is it possible to rename all *.csv files in a directory with content from the file itself? Here is an example of one File: TKNR;Zst;Land...

Read from CSV file using batch script
Summary: I have csv files with 4 rows: john,16,male,9898989898 tom,19,male,8787878787 tia,22,female,6767676767 if i used below command: @echo off cls setlocal...

[Solved] Bat To Strip Lines From A Csv File
Summary: Hi there, I have a large csv file (8GB) called input.csv, I am in need to create a bat file to export every 4th lines of the csv file. The filtered f...

[Solved] Need help with a batch file to edit a csv
Summary: I have a regularly created csv file that always has the same file name, but we have changed the data requirements it needs to have in it. It would be...

[Solved] Output of Shell script to XL File
Summary: I am having a Shell script with multiple select statement with 2 columns , i need that output to be displayed in MS-XL file or .csv file Please help ...

[Solved] Batch file to delete lines in many large CSV file
Summary: I found here a solution to delete the first lines (here 27) in the csv file: ======================================= @echo off & setLocal enableDELAYe...

[Solved] Batch Files - Tokens and Delimiters issue.
Summary: I have a simple string "ICJCL78SERIAL_yyyymmddhhmmss.CSV" that I am trying to parse to get "yyyymmddhhmmss". I use the following: "FOR /f "tokens=2 de...

[Solved] Amending a CSV file via a batch file
Summary: I need to amend a csv file that could contain 1 line or 100 lines. The file will be sent thus: 123456789,01/08/14,12,08:00,28/04/14 Each line has to b...

[Solved] Extract from text file not delimiting properly
Summary: Hello all, This question is similar to one I posted a few days ago. Please forgive my noobishness. I'm a hardware guy. I have created a text file that...

[Solved] Output columns from csv
Summary: All, I'm new to batch programming. I have created a for loop to take 2 columns out of a .csv file and export them to a new .csv file. See code: @echo ...

[Solved] Tried to send email, was (mis)identified as Spam
Summary: The email was sent to a recipient I've sent email to many times without a problem. There was a large .csv attachment, however. ...

[Solved] Delete First Row & Column of CSV
Summary: Hello i i would like a batch file to delete the first column and first row of multiple csv files saved in a folder leaving the file format unchanged. ...

Split txt inputfile into n output files based on content
Summary: Hi, I am trying to create a bat file that would pick up input file if.csv and split it into 0-n output files named of_<groupid>.csv. I say 0-n beca...

[Solved] Adding Header & trailer for existing csv file through batch
Summary: I need to add Header as current UTC time format as "MM-DD-YYYYHH:MM:SS" & trailer as number record found on existing csv through Batch scripting. I ne...

[Solved] how to import csv from excel 2007 to outlook 2007
Summary: 1) do I save excel as CSV (MS-DOS) or simply CSV (which i presume is "windows" version 2) when following steps to import file into outlook, I select t...

[Solved] open a csv file, add two lines and sane the file
Summary: I need to add lines in my batch code to open a csv file add two lines on the start of the csv and save the csv file. ...

[Solved] batch file to update multiple csv files
Summary: I am working with a few csv files that I need to output to another file using a Windows Batch file. The csv files are named input1.csv, input2.csv, i...

Batch file to edit column type in a CSV
Summary: I have a folder full of csv files. Two of the columns are "general" but I need to convert them to Number in order for Arcmap to recognize them as X,Y...

[Solved] create csv based on existing file name batch file
Summary: I need a batch file that will go through a folder of csv files, create a new csv file (to add a header) naming the new file by a designated portion of...

bat to strip lines from a csv file
Summary: I am needing to create a bat file to read a csv file and strip anything that doesn't start with a "O" as first field. or read a file and output ever...

How copy file from subfolder to another, dir struct unknown
Summary: Okay here we go. Usually it is not that hard to move a csv file from one subfolder to another subfolder in the same directory, BUT here's my challenge...

export CSV or LOG file to excel using powershell
Summary: Hello to all, I would simply export the data column in my csv or log and create a chart , but I can not figure out how to export some help? I have tr...

merge two .csv files on common column using dos
Summary: HI, I have two .csv files. for e.g. file1.csv ID,Value1 1,100 3, 150 4, 200 file2.csv ID,Value2 1,180 2, 40 4, 60 Required output(order does not mat...

123


Ask Question