04-18-2018
Dear RudiC, It works fine but i have too many date rows like 1048576 rows.In this case it's not working when i save file to the new file it remains same.
Last edited by rakibul639; 04-18-2018 at 02:19 AM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a csv file, which is > 2 Gigs. I need to BCP that file to Sybase db , but I cant upload that b'caz first row of the file is failing. ( having some errors probably.) I can manually insert the first line into db & then I can upload the rest of the data in file, if i can delete the first row.
... (2 Replies)
Discussion started by: kedar.mehta
2 Replies
2. Shell Programming and Scripting
Hi ,
I've a perl script to convert .xls to .csv .After conversion I want to delete first 28 and the last row from .csv file.Is there any efficent way to achive this both together.
I'm deleting first 28 rows by using folllowing my perl code:
exec " tail -n+28 infile.csv > outfile.csv
... (7 Replies)
Discussion started by: ajaypatil_am
7 Replies
3. UNIX for Dummies Questions & Answers
hi team,
i have a file txt1 , in that file there r 10 lines . my aim is to cut 2nd and 6th line of the file .
what command we can use for this scenario. (8 Replies)
Discussion started by: natraj005
8 Replies
4. UNIX for Dummies Questions & Answers
Hello. Newbie here....
I basically have a directory with tens of thousands (literally) subdirectories and need to delete those that are older than 2008 (hundreds) with all their contents. I've looked through all the RM parameters and still can't quite figure out how to specify the data range... (7 Replies)
Discussion started by: pqmomba8
7 Replies
5. UNIX for Dummies Questions & Answers
Hello gurus,
I am hoping someone can help me with the required code/script to make this work. I have the following file with records starting at line 4:
NETW~US60~000000000013220694~002~~IT~USD~2.24~20110201~99991231~01~01~20101104~... (4 Replies)
Discussion started by: chumsky
4 Replies
6. Shell Programming and Scripting
Hi,
I have a csv file with old data..i need to have only last 30 days from the current dateof data in the file.The fourth field in the file is a date field.i need to write a script to delete the old data by comparing the the fourth field with the (current date -30).I need to delete the rows in... (2 Replies)
Discussion started by: pals70423
2 Replies
7. Shell Programming and Scripting
Hi All,
I have many of files(.csv) of the format given below.
Date,Name,Location
04/02/2012,A,India
,B,China
,C,USA
Like this I have 1000's of rows and many columns in all my files.
I need a shell script to copy down the Date(in this example column1) to the next 2 rows below(in the... (8 Replies)
Discussion started by: ks_reddy
8 Replies
8. Shell Programming and Scripting
Hi All
I will run the same script every day in corn and output should go to same CSV file but in different row with dates on it. Below is my example in attached format.
Script i am using to collect switch port online
DATE=`date '+%d-%m-%y'`
for f in `cat... (1 Reply)
Discussion started by: ranjancom2000
1 Replies
9. Shell Programming and Scripting
Hi guys,
i have a csv file like:
USERID;COG;DESCR;FIL;OFF
user001;user;test1;001;A01
user002;user;test2;002;A02
user0003;user;test3;003;A03
user004;user;test4;004;A04
user0005;user;test5;005;A05
etc..
I need to read line for line and, if value of first column is > 7 char (in this example... (4 Replies)
Discussion started by: kamose
4 Replies
10. Shell Programming and Scripting
Hi,
I have to find the count of rows starting with "E," in given a.csv file .
Sample Data File.
E,2333AED,A,MC3,25,31-MAY-18
E,2333AED,A,MC3,25,31-MAY-18
CYMC3 25AED 0000
E,2333CZK,A,MC3,25,31-MAY-18
CYMC3 25CZK 0000
E,2333EUR,A,MC3,25,31-MAY-18... (3 Replies)
Discussion started by: Prabhakar Y
3 Replies
LEARN ABOUT SUSE
choptest
CHOPTEST(8C) CHOPTEST(8C)
NAME
choptest - HylaFAX page chopping test program
SYNOPSIS
/usr/sbin/choptest [ options ] input.tif
DESCRIPTION
choptest is a program for testing the page chopping support in the HylaFAX software (specifically, in the faxq(8C) program). choptest ana-
lyzes a TIFF/F (TIFF Class F) file with 1-D MH- or 2-D MR-encoded data and reports what the automatic page chopping logic would do if the
file were submitted for transmission. Options are provided for controlling whether choptest checks the last page or all pages of the docu-
ment, and what whitespace threshold to use in deciding if a page should be chopped.
OPTIONS
-a Chop all pages in the document. This is equivalent to setting the PageChop configuration parameter to ``all''; c.f. hylafax-
config(5F). By default only the last page of the document is considered.
-t inches Set the minimum whitespace threshold that must be present on a page for it to be chopped. This is equivalent to the Page-
ChopThreshold configuration parameter; c.f. hylafax-config(5F). By default choptest requires that at least 3 inches of trailing
whitespace be present.
EXAMPLES
The following shows a multi-page, high-resolution document. Each page has insufficient whitespace for it to be chopped.
hyla% ./choptest -a ~/tiff/pics/faxix.tif
Chop pages with >=3" of white space at the bottom.
Don't chop, found 67 rows, need 588 rows
Don't chop, found 67 rows, need 588 rows
Don't chop, found 67 rows, need 588 rows
Don't chop, found 53 rows, need 588 rows
Don't chop, found 91 rows, need 588 rows
Don't chop, found 99 rows, need 588 rows
Don't chop, found 47 rows, need 588 rows
SEE ALSO
faxq(8C), hylafax-config(5F)
October 3, 1995 CHOPTEST(8C)