Now I figured out that it is not the 'sed' script that is causing the issue. Actually what happens is that I want to remove some fields from my existing csv file using 'awk'. Let say I just to delete the ITDCLIENTUSERID from my csv file. My initial csv before deleting is like this:
I tried to delete the ITDCLIENTUSERID field using the following script:
which gives the output like this:
Here the ending characters '|' comes in a new line but I want it should continue in the above line instead of coming into a new line.
My expected result should be like this:
can you please help me out in getting my proper expected result.
---------- Post updated at 05:46 AM ---------- Previous update was at 05:37 AM ----------
Small correction, My output looks like this after the 'awk' running.
Last edited by Scott; 12-02-2011 at 07:04 AM..
Reason: Code tags
Hi.
I have many files in a folder, and even more in the subfolders. I need a script that finds and removes certain characters (them being /n in this one) in the files in the folder and it's subfolders.
So, could someone write me a script that works in Linux, does this:
Searchs for "/n" in... (5 Replies)
I am calling SQL script in my UNIX Shell script and trying to create the CSV file and my last column value of each row is 23 blank spaces.
In my SQL script,the last column is like below.
RPAD(' ',23,' ') -- Padding 23 blank Spaces
The CSV file is generated but the sapce(23 spaces) is... (2 Replies)
I have data like:
Blue Apple 6
Red Apple 7
Yellow Apple 8
Green Banana 2
Purple Banana 8
Orange Pear 11
What I want to do is if $2 in a row is the same as $2 in the previous row remove that row. An identical $2 may exist more than one time.
So the out file would look like:
Blue... (4 Replies)
Hello Everyone,
My issue is that I want to traverse a database table row by row and do some action on the value retrieved in each row.
I have gone through a lot of shell script questions/posts. I could find row by row traversal of a file but not a database table.
Please help.
Thanks &... (5 Replies)
Friends,
I observed a peculiar problem in shell.
if I set a variable using standard input and backspace was used by the user, then the variable get ^? characters embedded in the variable.
###
echo "Enter value for X="
read X
echo $X
expr $X + 1
###
If the variable is echoed, then there... (3 Replies)
Hi All,
I've a csv file in which the record is getting break into 1 line or more than one line. I want to combine those splits into one line and remove the unwanted character existing in the record i.e. double quote symbol ("). The line gets break only when the record contains double... (4 Replies)
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Hi,
I need to remove first column from a csv file and i can do this by using below command.
cut -f1 -d, --complement Mytest.csv
I need to implement this in shell scripting, Whenever i am using the above command alone in command line it is working fine.
I have 5 files in my directory and... (3 Replies)
I have this fastq file:
@M04961:22:000000000-B5VGJ:1:1101:9280:7106 1:N:0:86
GGGGGGGGGGGGCATGAAAACATACAAACCGTCTTTCCAGAAATTGTTCCAAGTATCGGCAACAGCTTTATCAATACCATGAAAAATATCAACCACACCA
+test-1
GGGGGGGGGGGGGGGGGCCGGGGGFF,EDFFGEDFG,@DGGCGGEGGG7DCGGGF68CGFFFGGGG@CGDGFFDFEFEFF:30CGAFFDFEFF8CAF;;8... (10 Replies)
Discussion started by: Xterra
10 Replies
LEARN ABOUT SUSE
mod-active
MOD-ACTIVE(8) InterNetNews Documentation MOD-ACTIVE(8)NAME
mod-active - Batch processing of newsgroups creation and removal commands
SYNOPSIS
mod-active [ctlinnd-command-file ...]
DESCRIPTION
mod-active is a Perl script that updates the active file based on its input lines of ctlinnd "newgroup", "rmgroup" and "changegroup"
commands. It pauses the server briefly while the existing active file is read and rewritten, which not only keeps innd from updating the
active file but also locks against other instances of mod-active.
The script must be run as the news user.
The input to mod-active can come either from one or more ctlinnd-command-file files named on the command line, or from the standard input.
Typically its input is the output from the docheckgroups or actsync commands. Every line which contains the string "ctlinnd newgroup",
"ctlinnd rmgroup", or "ctlinnd changegroup", optionally preceded by whitespace and/or the path to ctlinnd, is noted for the update.
Redundant commands, such as a newgroup directive for a group that already exists, are silently ignored. All other lines in the input are
also silently ignored. After the new active file has been generated, the existing one is renamed to active.old and the new one is moved
into place. The script then displays the differences between the two files. Any groups that were added to the active file are also added
to the active.times file with the string "checkgroups-update".
Please note that no syntax checking is performed on group names by mod-active.
BUGS
Though innd is paused while mod-active works, it is not inconceivable that there could be a conflict if something else tries to update the
active file during the relatively short time that mod-active is working. The two most realistic ways for this to happen are either by an
administrator concurrently doing a manual ctlinnd command, or by innd receiving a control message, then mod-active pausing the server, then
the control message handler script that innd forked running its own ctlinnd command while mod-active is working. Note that such scenarios
are very unlikely to happen.
HISTORY
Written by David C Lawrence <tale@isc.org> for InterNetNews. Converted to POD by Julien Elie.
SEE ALSO active(5), active.times(5), actsync(8), ctlinnd(8), docheckgroups(8), innd(8).
INN 2.5.2 2009-05-21 MOD-ACTIVE(8)