05-02-2012
hi Scrutinizer,
some backround information. we send a newsletter from our company. so many mails are running back, while the person changed the company, or the email was not correct. we have a receivers.csv where those people are listed right or wrong with subscribed or unsubscribed. the receivers.csv is a copy of the life receivers.csv on the webserver, so if we correct the things in the copy, the live csv would be filled up or changed.
now on the first column is the email address right or wrong, on the second column i want to write the right email address if its wrong. so when all the email addresses are corrected, i want to change with that script the life receivers.csv.
if there is an entry on the second column with an correted address so write it on the live .csv on the first column. the filds are separeted with this ; , i don`t know the name of it.
molker
Last edited by Scrutinizer; 05-02-2012 at 04:20 AM..
Reason: icode highlight of semicolon
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I need to find one string in all files and replace tht string with blank space and need to redirect all the files into the same directory again.
now i am using
find ./ -name "*.dmp" | xargs perl -pi -e 's/\\N//g' | sed 's/.$//g'
but now its not redirrecting properly .
its taking... (21 Replies)
Discussion started by: dbsurf
21 Replies
2. Shell Programming and Scripting
Hi all-
I've got 2 files: One is the final results and one is a result set from a query.
In the final results files I have placeholder strings in there that need to be replaced by the corresponding strings from the query file.
So File#1 (FINAL RESULTS)
LINEID CLIENT ID REP ... (1 Reply)
Discussion started by: Cailet
1 Replies
3. Shell Programming and Scripting
I have a directory full of files. Most of the code in the files is the same accept for a few parameter values. I want to remove hard coded values and replace it with a parameter that I can pass. This is oracle pl/sql anonymous blocks. so the code is similiar to this
function myfunc
(p_myvar ... (1 Reply)
Discussion started by: guessingo
1 Replies
4. Shell Programming and Scripting
Hello,
I am very new to Linux and am trying to find a way for following problem.
I have a number of files in a folder as Export000.dat, Export001.dat ..and so on.
Each file has a string field 'Absolute velocity'. I want it to be replaced by 'Pixel shift' in all the files. I tried something like... (4 Replies)
Discussion started by: chirag.joshi
4 Replies
5. Shell Programming and Scripting
I'm trying to remove the following string from several files.
<img heigth="1" width="1" border="0" src="http://myteenmovies.net/t.php?id=5540372">I'm using the following script
#!/bin/bash
# This script will search and replace all regular files for a string
# supplied by the user and... (1 Reply)
Discussion started by: d13g0sv
1 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
HP-UX oradev3 B.11.11 U 9000/800 3251073457
I have following files all contains text like "919642990137@". I need to search this text across all files and replace it with something like "919717298765@". I was wondering, how to accomplish this task?
cpmprod_status.sh... (8 Replies)
Discussion started by: alok.behria
8 Replies
7. Shell Programming and Scripting
What is the best way (bash/awk/sed?) to read in two text files and do a keyword search/replace?
file1.txt:
San Francisco
Los Angeles
Seattle
Dallas
file2.txt:
I love Los Angeles.
Coming to Dallas was the right choice.
San Francisco is fun.
Go to Seattle in the summer.
... (3 Replies)
Discussion started by: pxalpine
3 Replies
8. Shell Programming and Scripting
Hello,
I have hundreds of files in which I need to change email address. Here is what I am trying to do:
1. All text files are in a directory "a"
2. In the text file, I want to replace email address for preparer. All these lines start with {{PreparerEmail and end with }}. The email... (3 Replies)
Discussion started by: cartrider
3 Replies
9. Shell Programming and Scripting
I have a bit of a complex problem that I would like to solve with awk. It is essentially a 2-part problem.
I have a large directory of files with the same format, each with 266 lines.
The first 206 lines of each file are filled with attribute information.
Then the following 60 lines consist... (4 Replies)
Discussion started by: owwow14
4 Replies
10. UNIX for Dummies Questions & Answers
I am not sure how to search and replace the word in the few specific files.
I need to search and replace word in only the name containing pepsi in the filename. (12 Replies)
Discussion started by: ramkumar15
12 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)