10 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
I need some help in converting the below horizontal lines to vertical lines format.
can anyone help me on this.
5,111 (3 Replies)
Discussion started by: Raghuram717
2. UNIX for Beginners Questions & Answers
I'm creating a sh script to generate a csv file. The CSV contains the values from a sql table.
The content looks this:
I have some code that can separate the fields using the comma as delimiter, but some values actually contain commas, such as... (2 Replies)
Discussion started by: preema
3. Shell Programming and Scripting
I have a large CSV file that contains values all on the same column, and in one very long row (e.g. no line breaks till end, with all data values separated by a comma).
The file has two types of data for the values. One begins with the letters rs and some numbers. The other begins... (4 Replies)
Discussion started by: macurdy
4. Shell Programming and Scripting
I am trying to find a way to take a .csv file with 7 columns and a ton of rows (over 600,000) and remove the entire row if the cell in forth column is blank.
Just to give you a little background on why I am doing this (just in case there is an easier way), I am pulling... (3 Replies)
Discussion started by: MrTuxor
5. Shell Programming and Scripting
I have a requirement like my .csv file is generating from a db2 table using export command like below:
2011 4 0 0 N S C C "BHPC
BHPC" 0 0 0
2011 5 0 0 N S C C "BHPC
BHPC" 0 0 0
here BHPC is having new line character and because this when i am trying... (4 Replies)
Discussion started by: RRVARMA
6. UNIX for Dummies Questions & Answers
Hi folks, I have a long string of DNA sequences, and I need to remove several lines, as well as the line directly following them. For example, here is a sample of my starting material:
>548::GY31UMJ02DLYEH rank=0007170 x=1363.5 y=471.0 length=478... (1 Reply)
Discussion started by: kkohl78
7. Shell Programming and Scripting
I have many files all with 1 field per line as in
how do I remove ceratin lines from these files.
Have tried sed but sed wrecks my head!
Many thanks in advance for any help (9 Replies)
Discussion started by: rob171171
8. Shell Programming and Scripting
Does anybody know of a command that will enable me to remove all entries in a file that have the format (name & time)
arlenem 08:15... (5 Replies)
Discussion started by: jamba1
I have an csv file and there are some non printable characters(extended ascii) so I am trying to create a clean copy of the csv file . I am using
tr -cd "" < /opt/informatica/PowerCenter8.6.0/server/infa_shared/SrcFiles/ThirdParty/locations.csv > ... (4 Replies)
Discussion started by: gerkus
10. Shell Programming and Scripting
I've written a script that processes a data file on our system. Basically the script reads a post code from a list file, looks in the data file for the first occurrence (using grep) and reads the line number. It then tails the data file, with the line number just read, and outputs to a... (3 Replies)
Discussion started by: tookers