10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
2. Shell Programming and Scripting
I want to convert an csv file on unix (which is generated by a ETL application) to a formatted excel sheet like .I have roughly like 28 columns
1)All numbers need to be stored as numbers with leading zeros-like format as text for this column to preserve leading zeroes e.g... (6 Replies)
Discussion started by: etldev
3. Shell Programming and Scripting
Dear friends, please your help. I got a .csv (comma separated values) file with 61 columns I need to make a script to change the original file into a new one with this actions:
Delete Columns: 1,13-20
Change the format of the following columns:
2: '2013-11-07 00:00:00' to '07/11/2013 0:00'... (5 Replies)
Discussion started by: lestatyela
4. Shell Programming and Scripting
I was wondering how I can convert each line in an input file where fields are separated by variable width spaces into a CSV file. Below is the scenario what I am looking for.
My Input data in inputfile.txt
19 15657 15685 Sr2dReader 107.88 105.51... (4 Replies)
Discussion started by: vharsha
5. Shell Programming and Scripting
Hello I wrote a perl script to output a text file filled with ip addresses and ports that i scanned into microsoft excel. Now that the data is in excel my boss wants me to organize the file in csv format such as
Can... (0 Replies)
Discussion started by: kingbp
6. Shell Programming and Scripting
Am using the following command to create a csv file
paste File_1.csv File_4.csv File_7.csv >Out1.csv
paste File_2.csv File_5.csv File_8.csv >>Out1.csv
paste File_3.csv File_4.csv File_9.csv >>Out1.csv
Column 1 Column 2 ... (2 Replies)
Discussion started by: meva
7. Shell Programming and Scripting
I am getting a no of fields from a SQL session (e.g. select a,b,c from table). How do I convert the output values into CSV format .
The output should be like this 'a','b','c', (4 Replies)
Discussion started by: mady135
8. Shell Programming and Scripting
Please help me with csv file formatting which needs to be done in horizontal fashion.
I have data coming in separate files every hour. What I need to do is extract three values into csv file. In the next hour, I need to extract the new values beside the three values which were... (1 Reply)
Discussion started by: vharsha
9. Shell Programming and Scripting
Hi I have a very large csv file with some hundreds of thousands of rows of data.
The data is in the following format:
Up to four alpha numeric characters for the first word. This is either set as 2 characters followed by 2 spaces, or as a single 4character word. This is then followed by an 8... (7 Replies)
Discussion started by: meself
10. Shell Programming and Scripting
Can anyone help me format a csv file. My csv file have 6 columns. the last 2 columns were put on the second row.
Here is the sample output:
4200059000,'DIXIE BOWLS HEAVY DUTY DISPOSABLE 10 OZ
1. How can I put the last 2 columns in the first row,... (1 Reply)
Discussion started by: softwood