Hi,
I have a sql file and i need to extract the table names used in the sql file using a unix script. If i can extract the lines between the keywords 'FROM' and 'WHERE' in the file, my job is done. can somebody tell me how to do this using a shell script. If u can just let me know, how to... (2 Replies)
Hi all,
I'm very very new to UNIX and AWK world.Please help me in finding a solution for my problem.
I'm having a file like this
-----------------------------------------------------------------
~Version Information
VERS. 2.0: CWLS log ASCII Standard -VERSION 2.0
WRAP. ... (4 Replies)
Hi,
HP-UX gxxxxxxxc B.11.23 U ia64 3717505098 unlimited-user license
I have a file with below pipe separated field values:
xxx|xxx|abcd|xxx|xxx|xx
xxx|xxx|abcd#123|xxx|xxx|xx
xxx|xxx|abcd#345|xxx|xxx|xx
xxx|xxx|pqrs|xxx|xxx|xx
xxx|xxx|pqrs#123|xxx|xxx|xx
The third field has values like... (6 Replies)
Thank you for assisting,
I've got a partial solution just needs a tweak.
Hulk-BASH$ cat somefile.txt
oh there is some stuff here
some more stuff here
START_LABEL
stuff I want
more stuff I want
END_LABEL
other stuff here too
and even more stuff here too
Hulk-BASH$
Hulk-BASH$ sed... (8 Replies)
Hi all,
I have a positional text file that comes from some source application. Before it is processed by destination application I have to add some header (suffix) to every record(line) in the file.
e.g.
Actual File
...............
AccountDetails
AcNO Name Amount
1234 John 26578
5678... (3 Replies)
Hello all
I am getting data like
col1 | col2 | col3
asdafa | asdfasfa | asf*&^sgê
345./ |sdfasd23425^%^&^ | sdfsa23
êsfsfd | sf(* | sdfsasf
My requirement is like
I have to to read the file and remove all special characters and hex characters ranging form 00-1f from 1st column, remove %"'... (1 Reply)
Hi Guys,
I need some script in removing lines containing strings like ",, ," and "rows". Retain only numbers as the output. See below for the input and output file.
INPUT FILE:
9817
9832
6285
6312
6313
6318
,, ,
6329
7078
7098
7130
7959
7983 (7 Replies)
The question is not as simple as the title... I have a file, it looks like this
<string name="string1">RZ-LED</string>
<string name="string2">2.0</string>
<string name="string2">Version 2.0</string>
<string name="string3">BP</string>
I would like to check for duplicate entries of... (11 Replies)
Have two files and want to compare the content of file1 with file2. When matched remove the line.
awk 'NR==FNR {b; next} !(b in $0)' file1 file2file1
1. if match
2. removefile2
1. this line has to be removed if match
2. this line has a match, remove
3. this line has no match, no removingThe... (3 Replies)
Within my text file i have several thousand lines of text with some lines containing duplicate strings/words. I would like to entirely remove those lines which contain the duplicate strings.
Eg;
One and a Two
Unix.com is the Best
This as a Line Line
Example duplicate sentence with the word... (22 Replies)
Discussion started by: martinsmith
22 Replies
LEARN ABOUT DEBIAN
nntidy
NNTIDY(1) General Commands Manual NNTIDY(1)NAME
nntidy - tidy your personal .newsrc file
SYNOPSIS
nntidy [ -aciNQrsuv ] [ group ]...
DESCRIPTION
nntidy will clean out non-existing groups, adjust obviously wrong article numbers, and remove badly formed lines from your .newsrc file.
It may optionally remove ignored groups, unsubscribed groups, and groups which are not part of your presentation sequence or the groups
specified on the command line.
You should run nntidy if your rc file has been corrupted for some reason.
OPTIONS -a Equivalent to -cisu.
-c Remove unrecognized lines. This will also remove the `options' line used by some older news readers, such as readnews(1)-i Remove entries for groups which are ignored in the database, e.g. entries marked with `X' in the GROUPS file.
-r Remove entries for unsubscribed groups.
-s Remove entries which are not included in the group presentation sequence defined in the init file. If one or more groups are speci-
fied on the command line, entries not matched by these groups (and their subgroups etc) will be removed.
Notice that depending on how you construct the presentation sequence, this may cause unsubscribed groups to be removed from .newsrc,
but this will not normally happen.
-u Truncate entries for unsubscribed groups, by removing the article numbers and leaving only the news group name and the `!' mark.
-v Verbose operation. Reports each change made to the .newsrc file.
-N No update mode. The requested operations are performed, but the result is not written back to disk. This can be used with the -v
option to see whether tidying is required.
-Q Quiet operation. The version information is not printed.
FILES
~/.newsrc The record of read articles
~/.newsrc.tidy The original rc file before tidy
SEE ALSO nn(1), nncheck(1), nngoback(1), nngrab(1), nngrep(1), nnpost(1)nnadmin(1M), nnusage(1M), nnmaster(8)AUTHOR
Kim F. Storm, Texas Instruments A/S, Denmark
E-mail: storm@texas.dk
4th Berkeley Distribution Release 6.6 NNTIDY(1)