01-29-2011
CSV file
I am new to script writing. With the help of others I now have a script that reads the files names in a folder and records each file name in a comma delimited file. "import.txt".
I can now import this into Open office Calc as a TextCSV file but it places each file name at the head of a separate column.
What I really want is to be able to import the file such that it shows each file name in a separate row but in the 1 column.
It seems to me I need some how to put a return. line feed or carriage return in where the , is in the script.
How do I do this?
I known one can do an Edit cut and the a special paste in a way that transposes the data base from a single long row of data and to a single column but this is messy for the numbers I have to do. So if it can be done in the generation of the CSV file it would be a lot beter and easier.
I am using OpenOffice 3.3, and Fedora 14 64 bit as the OS
The current script in the area where the comma is is
"$LINE," >> import.txt: done.
This works fine for what I want but it gives the end results as I say with the file name one per column when importing as comma delimited.
Thanks
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
Am new to scripting. So i just need your ideas to help me out. Here goes my requirement.
I have two csv files
1.csv 2.csv
abc,1.24 abc,1
def,2.13 def,1
I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies
2. Shell Programming and Scripting
I have been trying to find a good solution for this seemingly simple task for 2 days, and I'm giving up and posting a thread. I hope someone can help me out!
I'm on HPUX, using sqlplus, mailx, awk, have some other tools available, but can't install stuff that isn't already in place (without a... (6 Replies)
Discussion started by: soldstatic
6 Replies
3. Shell Programming and Scripting
Hi,
I am tryng to read from a csv file and based on some grep command output I will modify one of the column in the same csv.
Example:-
Input CSV:-
20120829001415,noneAA,google.com
20120829001415,dfsafds,google.com
20120829001415,noneAA,google.com
Intermediate Step:- If 2nd column of... (3 Replies)
Discussion started by: kmajumder
3 Replies
4. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
... (1 Reply)
Discussion started by: Naresh101
1 Replies
5. Shell Programming and Scripting
(say) I have 2 csv files - file1.csv & file2.csv as mentioned below:
file1.csv
ID,version,cost
1000,1,30
2000,2,40
3000,3,50
4000,4,60
file2.csv
ID,version,cost
1000,1,30
2000,2,45
3000,4,55
6000,5,70
The... (7 Replies)
Discussion started by: Naresh101
7 Replies
6. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
7. 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.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
8. Shell Programming and Scripting
Hi, all
I want to sort a csv file based on timestamp from oldest to newest and save the output as csv file itself. Here is an example of my csv file.
test.csv
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0739.JPG,2015:02:17 11:32:21
/home/intannf/foto/IMG_0749.JPG,2015:02:17 11:37:28... (10 Replies)
Discussion started by: refrain
10 Replies
9. Shell Programming and Scripting
Hi,
I have another problem. I want to sort another csv file by the first field.
result.csv
SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw
/home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies
LEARN ABOUT DEBIAN
gbp-pq
GBP-PQ(1) git-buildpackage Manual GBP-PQ(1)
NAME
gbp-pq - Manage quilt patches on patch queue branches in git
SYNOPSIS
gbp-pq [ --verbose ] [ --color=[auto|on|off] ] [ --[no-]patch-numbers ] [ --topic=topic ] [ --time-machine=num ] drop | export | import |
rebase | switch
DESCRIPTION
gbp-pq helps one to manage quilt patches in Debian packages that are maintained with git-buildpackage. This is especially useful with pack-
ages using the 3.0 (quilt) source format. With gbp-pq you can maintain the quilt patches that should be applied to a package on a separate
branch called patch-queue branch. So if your Debian package lives on master the associated patch-queue branch will be called patch-
queue/master.
See <URL:https://honk.sigxcpu.org/piki/development/debian_packages_in_git/> for example workflows.
ACTIONS
import Create a patch queue branch from quilt patches in debian/patches/ that are listed in debian/patches/series.
export Export the patches on the patch-queue branch associated to the current branch into a quilt patch series in debian/patches/ and
update the series file.
rebase Switch to the patch-queue branch associated to the current branch and rebase it against the current branch.
drop Drop (delete) the patch queue associated to the current branch. So if you're on branch foo this would drop branch patch-queue/foo.
apply Add a single patch to the patch-queue similar to using git-am. Use --topic if you want the patch to appear in a separate subdir when
exporting the patch queue using export. This can be used to separate upstream pathes from debian specific patches.
switch Switch to the patch-queue branch if on the base branch and switch to base branch if on patch-queue branch.
OPTIONS
--verbose
-v verbose execution
--color=[auto|on|off]
Whether to use colored output.
--[no-]patch-numbers
Whether the patch files should start with a number or not.
--topic=topic
Topic to use when importing a single patch
--time-machine=NUM
When importing a patch queue fails, go back commit by commit on the current branch to check if the patch-queue applies there. Do
this at most NUM times. This can be useful if the patch-queue doesn't apply to the current branch HEAD anymore, e.g. after import-
ing a new upstream version.
TAGS
When exporting patches from a patch-queue branch gbp-pq will look at the patch header for special tags it recognizes. All tags need to
start at the first column and require at least one whitespace after the colon.
Gbp-Pq-Topic: topic
Moves the patch into a subdir called topic when running
gbp-pq
export
. This allows for some structure below debian/patches.
SEE ALSO
git-buildpackage(1), dpkg-source(1), quilt(1), gbp.conf(5)
AUTHOR
Guido Guenther <agx@sigxcpu.org>
01 June 2012 GBP-PQ(1)