Hello Folks,
I am working on filtering a file having some special characters.
Let's say for an example a file contains person name and phone number based on positions. First 5 characters name and next 10 characters phone number. My task is to , if there is any special character in phone number (position 6-15), then that record should be removed from the file
Desired output
PLease help me with the awk script to accomplish this
I have a Ques. Regarding awk
I have few strings in a file, like..
ABC
DEF_ABC
GHI_ABC
GHI
Now I want string which has only 'ABC', not the part of any other string as it is also present in 'DEF_ABC'
Output should be ABC
Please guide me asap !!
Thanks :b: (4 Replies)
Hello folks,
I have 2 files one( file1) contains the ddl for a view and file 2 contains the view defination/alias columns.
I want to merge the 2 into a third file using awk/sed as follows:
cheers !
:b:
FILE1
-----
PROMPT FIRST_VIEW
CREATE OR REPLACE FORCE VIEW FIRST_VIEW
AS
SELECT... (2 Replies)
Hi,
I need to do the following but I don't know exactly what to do.
I need to monitor a file ... with tail -f for example, but I know that I could do it with awk, wait for a specific string ... , then perform an action, call a script, etc.
Let's say that my file name is test.txt , I need... (3 Replies)
Hello Gurus,
I have a requirement where I have to filter a value from some field which has 99% or greater than '99%'..
For ex:
The Date (file -- sample.csv) will be like below
Field1,Field2,Field3,Field4
860440512,844284992,16155520,99%
860440512,844284992,16155520,94%... (4 Replies)
I am trying to filter out some data with awk. If someone could help me that would be great. Below is my input file.
Date: 10-JUN-12 12:00:00
B 0: 00 00 00 00 10 00 16 28
B 120: 00 00 00 39 53 32 86 29
Date: 10-JUN-12 12:00:10
B 0: 00 00 00 00 10 01 11 22
B 120: 00 00 00 29 23 32 16 29... (5 Replies)
i have text file as below
CMF_COMP_ELEM_ GSM2_B71.WORLD_20121114130908.log 107496444 rows inserted into ALL_S1_CMF_COMP_ELEM.
CMF_COMP_ELEM_ GSM3_B71.WORLD_20121114130908.log 110729006 rows inserted into ALL_S1_CMF_COMP_ELEM.
CMF_COMP_ELEM_ GSM4_B71.WORLD_20121114130908.log 92549475... (8 Replies)
Hello all,
can you explain why this filter does not work, it prints all the lines in the file:
awk -v sel="TestString" 'sel' file while these work:
awk '/TestString/' file
awk -v sel="TestString" '$0~sel' file
Thanks!:) (6 Replies)
Hello Members,
I have a file, having below contents:
<KEYVALUE>$4,0,1,4,966505098999-->RemoteSPC: 13 SSN: 146</KEYVALUE>
<KEYVALUE>$4,123,1,4,966505050198-->RemoteSPC: 1002 SSN: 222,Sec:RemoteSPC: 1004 SSN: 222</KEYVALUE>
<KEYVALUE>$4,123,1,4,966505050598-->RemoteSPC: 1002 SSN:... (9 Replies)
Discussion started by: umarsatti
9 Replies
LEARN ABOUT PHP
phones
phones(4) File Formats phones(4)NAME
phones - remote host phone number database
SYNOPSIS
/etc/phones
DESCRIPTION
The file /etc/phones contains the system-wide private phone numbers for the tip(1) program. /etc/phones is normally unreadable, and so may
contain privileged information. The format of /etc/phones is a series of lines of the form:
<system-name>[ ]*<phone-number>.
The system name is one of those defined in the remote(4) file and the phone number is constructed from [0123456789-=*%]. The `=' and `*'
characters are indicators to the auto call units to pause and wait for a second dial tone (when going through an exchange). The `=' is
required by the DF02-AC and the `*' is required by the BIZCOMP 1030.
Comment lines are lines containing a `#' sign in the first column of the line.
Only one phone number per line is permitted. However, if more than one line in the file contains the same system name tip(1) will attempt
to dial each one in turn, until it establishes a connection.
FILES
/etc/phones
SEE ALSO tip(1), remote(4)SunOS 5.10 14 Jan 1992 phones(4)