10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
OWX(1) General Commands Manual OWX(1)
NAME
owx - utility to program Wouxun dual-band handheld radios
SYNOPSIS
owx-check [ -v | -h ] [ -f ] [ -p <port> ] [ -t <timeout> ]
owx-get [ -v | -h ] [ -f ] [ -p <port> ] [ -t <timeout> ] -o <path>
owx-put [ -v | -h ] [ -f ] [ -p <port> ] [ -t <timeout> ] -i <path> -r <path>
owx-export [ -v | -h ] -i <bin path> -o <csv path>
owx-import [ -v | -h ] -i <csv path> -o <bin path>
DESCRIPTION
This manual page documents briefly the owx commands.
owx is a set of commands that will allow you to fetch and update configuration on your Wouxun handheld radio. It is made of multiple com-
mands.
COMMON OPTIONS
These options are common to all commands.
-h Show summary of options.
-v Show version of program.
-c <command>
Invoke owx-<command>. Makes sense only if called directly as owx.
OPTIONS FOR check, get AND put
-f Force operation even if your radio identifies different from a KG669V. Use this option with extreme caution - it is very possible
that your radio will be rendered unusable after you use this. It was NEVER tested with any radio different from mentoined above.
-p <port>
Use port <port>, defaults to /dev/ttyUSB0. Of course you must have appropriate read and write permissions for this device.
-t <timeout>
Specify the receive timeout for communication with radio. If you disable it (by setting to 0) and the communication fails, the pro-
gram will hang forever. You probably don't need to change the default value (5 seconds).
USAGE
owx-check
This program just checks for the connection and identification string. It can be used to check that your cable and port works.
owx-get
This program downloads memory map from radio to binary file.
Options:
-o <path>: binary file to write to
owx-put
This program uploads memory map from binary file to radio.
Options:
-i <path>: binary file to read from
-r <path>: reference file
Option -r is not mandatory, but recommended. You can specify original, unchanged file (exactly as downloaded using owx-get) and this
will speed up memory uploading, as owx will compare input file to this reference file and upload only changed memory pages. When
using this option, be sure that nothing has changed in the radio (even the currently selected memory channel) between downloading
reference file and using it for upload. This is important as some variables that cross the page boundaries (if there are any in the
memory map) could be corrupted by this.
Example:
owx-get -o file.bin
cp file.bin backup.bin
owx-export -i file.bin -o wouxun.csv
oocalc wouxun.csv
owx-import -i wouxun.csv -o file.bin
owx-put -i file.bin -r backup.bin
Please do yourself a favour and double-check that you upload the correct file. If you try to upload incorrect or corrupted file,
your radio will power down and fail to power up. owx will refuse to upload any file with incorrect size, but this is the only safety
check.
owx-export
This program exports channel data from binary file to CSV file. This file can be later edited using your favourite spreadsheet edi-
tor or even text editor.
Options:
-i <path>: binary file to read from
-o <path>: csv file to write to
owx-import
This program reads the specified, possibly edited by you CSV file, and patches existing binary file with this updated data. The file
is now prepared to be uploaded with owx-put.
Options:
-i <path>: csv file to read from
-o <path>: binary file to write to (must already exist)
SEE ALSO
chirp(1), the README file.
AUTHOR
owx was written by SP5GOF (Adam Wysocki).
This manual page was written by Antoine Beaupre <anarcat@debian.org>, for the Debian project (and may be used by others).
October 26, 2011 OWX(1)