Sponsored Content
Top Forums Shell Programming and Scripting AWK, sorting-if and print help. Post 302344293 by boolean2222 on Saturday 15th of August 2009 04:11:26 PM
Old 08-15-2009
Bug AWK, sorting-if and print help.

Little-bit of awk experience, need some of the expert help on here. Browsed around here, got a little further, but I am still missing some pieces. Can you help me fill-in my missing awk cells?

Sample data file (leaving out ","'s):
Code:
Column 1       Column 2       Column 3        Column 4              etc.
apple            banana          ice cream       11:11 p/iz/za        etc.
attack          banana          etc                12:34 l/em/on       etc.
big               tomato          etc                etc.                    etc.
blowfish        tomato          etc                etc.                    etc.
cindy            tomato          etc               etc.                     etc.


What I have got thus far (pseudo-code):
Code:
awk -F","
{
$1=var1
if var1 ~ '/a/' var1=$1-fruit; else
if var1 ~ '/b/' var1=$1-animal; else
etc.
print "this is called" $var "thank you "

$2=var2
print $var2

$3=var3

$4=hmmm need it to just output "pizza" from that format and set to var4

print var3 " " var4

$5=var5
$6=var6

if count ($)2 appears more then once; then
for each instance
{
print $5 $6
}


--
The columns may be alpha-numeric, so I would like to script it as such.

Thank you for any help.

Last edited by boolean2222; 08-15-2009 at 05:14 PM.. Reason: making sample data easier to read
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk sorting

Hi, I have used the following code to sort two sets of data: awk '{printf "%10s %s\n",$1,$2}' The first column is text and the second involves numbers. I was just wondering how i would go about sorting the second number so that they ascend from the top? Thanks for any help (4 Replies)
Discussion started by: Jaken
4 Replies

2. Shell Programming and Scripting

How do I get awk to print a " in it's print part?

The line is simple, use " '{ print $1"]"$2"\"$3THE " NEEDS TO GO HERE$4 }' I've tried \", "\, ^" and '"" but none of it works. What am I missing? Putting in the [ between $1 and $2 works fine, I just need to do the same with a ". Thanks. (2 Replies)
Discussion started by: LordJezo
2 Replies

3. Shell Programming and Scripting

sorting in awk

i have following file have following type of data 1~%%~fcashfafh~%%~9797 can i sort(numeric) the file on first field and then on last feild using awk (3 Replies)
Discussion started by: mahabunta
3 Replies

4. Shell Programming and Scripting

Is there any better way for sorting in bash/awk

Hi, I have a file which is:- 1 6 4 8 2 3 2 1 9 3 2 1 3 3 5 6 3 1 4 9 7 8 2 3 I would like to sort from field $2 to field $6 for each of the line to:- 1 2 3 4 6 8 2 1 1 2 3 9 3 1 3 3 5 6 4 2 3 7 8 9 I came across this Arrays on example 26-6. But it is much complicated. I am... (7 Replies)
Discussion started by: ahjiefreak
7 Replies

5. Shell Programming and Scripting

Sorting with sed,awk ...

I need to sort this input using sed, awk or any other tool to give below output Input: RXOCF-8 CLASS 2A 57 RU 40 RXORX-8-0 CLASS 1B 23 45 16 RXORX-8-1 EXTERNAL CLASS 2A (12 Replies)
Discussion started by: aydj
12 Replies

6. Shell Programming and Scripting

Sorting inside awk

I have an array with five columns and i want to write it to a file. Before writing it i must sort it using the field in the fifth column. _________________________________________ |field 1|field 2|field 3|field 4|field 5| | | | | | | | | | |... (6 Replies)
Discussion started by: beatblaster666
6 Replies

7. Shell Programming and Scripting

AWK/GREP sorting help

hi everyone, I am kind of new to this forum. I need help in sorting this data out accordingly, I am actually doing a traceroute application and wants my AS path displayed in front of my address like this; 192.168.1.1 AS28513 AS65534 AS5089 AS5089 .... till the last AS number and if possible sort... (8 Replies)
Discussion started by: sam127
8 Replies

8. Shell Programming and Scripting

Sorting a .csv using awk or other

Hello all, I am new here and *relatively* new to Unix. I have a bit of an emergency. I have a three column file that I need to sort: sample name, miRNA, reads per million (RPM) There are multiple samples, and for each sample name there are multiple miRNAs and associated RPMs. Some of these... (6 Replies)
Discussion started by: dunnybocter
6 Replies

9. Shell Programming and Scripting

Sorting within a record using AWK

Hello, I have a file which has the following format: I have to do is sort individual records in the file based on the 4th field. Each record starts with "Module". Is there an easy way to do this using awk. I have tried piping output from awk to sort and also using "sort" inside awk but... (8 Replies)
Discussion started by: fifteate
8 Replies

10. Shell Programming and Scripting

Help with awk sorting with different values

Hello, I have a file as follows: BTA Pos KLD 4 79.7011 5.7711028907 4 79.6231 5.7083918219 5 20.9112 4.5559494707 5 58.0002 3.4423546273 6 38.2569 4.7108176788 6 18.3889 7.3631759258 (1 Reply)
Discussion started by: Homa
1 Replies
QAxWidget(3qt)															    QAxWidget(3qt)

NAME
QAxWidget - QWidget that wraps an ActiveX control SYNOPSIS
This class is part of the Qt ActiveQt Extension. #include <qaxwidget.h> Inherits QWidget and QAxBase. Public Members QAxWidget ( QWidget * parent = 0, const char * name = 0, WFlags f = 0 ) QAxWidget ( const QString & c, QWidget * parent = 0, const char * name = 0, WFlags f = 0 ) QAxWidget ( IUnknown * iface, QWidget * parent = 0, const char * name = 0, WFlags f = 0 ) ~QAxWidget () Important Inherited Members QVariant dynamicCall ( const QCString & function, const QVariant & var1 = QVariant ( ), const QVariant & var2 = QVariant ( ), const QVariant & var3 = QVariant ( ), const QVariant & var4 = QVariant ( ), const QVariant & var5 = QVariant ( ), const QVariant & var6 = QVariant ( ), const QVariant & var7 = QVariant ( ), const QVariant & var8 = QVariant ( ) ) QVariant dynamicCall ( const QCString & function, QValueList<QVariant> & vars ) QAxObject * querySubObject ( const QCString & name, const QVariant & var1 = QVariant ( ), const QVariant & var2 = QVariant ( ), const QVariant & var3 = QVariant ( ), const QVariant & var4 = QVariant ( ), const QVariant & var5 = QVariant ( ), const QVariant & var6 = QVariant ( ), const QVariant & var7 = QVariant ( ), const QVariant & var8 = QVariant ( ) ) Protected Members virtual bool createHostWindow ( bool initialized ) virtual bool translateKeyEvent ( int message, int keycode ) const DESCRIPTION
This class is defined in the Qt ActiveQt Extension, which can be found in the qt/extensions directory. It is not included in the main Qt API. The QAxWidget class is a QWidget that wraps an ActiveX control. A QAxWidget can be instantiated as an empty object, with the name of the ActiveX control it should wrap, or with an existing interface pointer to the ActiveX control. The ActiveX control's properties, methods and events which only use supported data types, become available as Qt properties, slots and signals. The base class QAxBase provides an API to access the ActiveX directly through the IUnknown pointer. QAxWidget is a QWidget and can be used as such, e.g. it can be organized in a widget hierarchy, receive events or act as an event filter. Standard widget properties, e.g. enabled are supported, but it depends on the ActiveX control to implement support for ambient properties like e.g. palette or font. QAxWidget tries to provide the necessary hints. Warning: You can subclass QAxWidget, but you cannot use the Q_OBJECT macro in the subclass (the generated moc-file will not compile), so you cannot add further signals, slots or properties. This limitation is due to the metaobject information generated in runtime. To work around this problem, aggregate the QAxWidget as a member of the QObject subclass. MEMBER FUNCTION DOCUMENTATION
QAxWidget::QAxWidget ( QWidget * parent = 0, const char * name = 0, WFlags f = 0 ) Creates an empty QAxWidget widget and propagates parent, name and f to the QWidget constructor. To initialize a control, call setControl. QAxWidget::QAxWidget ( const QString & c, QWidget * parent = 0, const char * name = 0, WFlags f = 0 ) Creates an QAxWidget widget and initializes the ActiveX control c. parent, name and f are propagated to the QWidget contructor. See also control. QAxWidget::QAxWidget ( IUnknown * iface, QWidget * parent = 0, const char * name = 0, WFlags f = 0 ) Creates a QAxWidget that wraps the COM object referenced by iface. parent, name and f are propagated to the QWidget contructor. QAxWidget::~QAxWidget () Shuts down the ActiveX control and destroys the QAxWidget widget, cleaning up all allocated resources. See also clear(). bool QAxWidget::createHostWindow ( bool initialized ) [virtual protected] Creates the client site for the ActiveX control, and returns TRUE if the control could be embedded successfully, otherwise returns FALSE. If initialized is TRUE the control has already been initialized. This function is called by initialize(). If you reimplement initialize to customize the actual control instantiation, call this function in your reimplementation to have the control embedded by the default client side. Creates the client site for the ActiveX control, and returns TRUE if the control could be embedded successfully, otherwise returns FALSE. QVariant QAxBase::dynamicCall ( const QCString & function, const QVariant & var1 = QVariant ( ), const QVariant & var2 = QVariant ( ), const QVariant & var3 = QVariant ( ), const QVariant & var4 = QVariant ( ), const QVariant & var5 = QVariant ( ), const QVariant & var6 = QVariant ( ), const QVariant & var7 = QVariant ( ), const QVariant & var8 = QVariant ( ) ) Calls the COM object's method function, passing the parameters var1, var1, var2, var3, var4, var5, var6, var7 and var8, and returns the value returned by the method, or an invalid QVariant if the method does not return a value or when the function call failed. If function is a method of the object the string must be provided as the full prototype, for example as it would be written in a QObject::connect() call. activeX->dynamicCall( "Navigate(const QString&)", "www.trolltech.com" ); Alternatively a function can be called passing the parameters embedded in the string, e.g. above function can also be invoked using activeX->dynamicCall("Navigate("www.trolltech.com"); All parameters are passed as strings; it depends on the control whether they are interpreted correctly, and is slower than using the prototype with correctly typed parameters. If function is a property the string has to be the name of the property. The property setter is called when var1 is a valid QVariant, otherwise the getter is called. activeX->dynamicCall( "Value", 5 ); QString text = activeX->dynamicCall( "Text" ).toString(); Note that it is faster to get and set properties using QObject::property() and QObject::setProperty(). It is only possible to call functions through dynamicCall() that have parameters or return values of datatypes supported by QVariant. See the QAxBase class documentation for a list of supported and unsupported datatypes. If you want to call functions that have unsupported datatypes in the parameter list, use queryInterface() to retrieve the appropriate COM interface, and use the function directly. IWebBrowser2 *webBrowser = 0; activeX->queryInterface( IID_IWebBrowser2, (void**)&webBrowser ); if ( webBrowser ) { webBrowser->Navigate2( pvarURL ); webBrowser->Release(); } This is also more efficient. Example: qutlook/centralwidget.cpp. QVariant QAxBase::dynamicCall ( const QCString & function, QValueList<QVariant> & vars ) This is an overloaded member function, provided for convenience. It behaves essentially like the above function. Calls the COM object's method function, passing the parameters in vars, and returns the value returned by the method. If the method does not return a value or when the function call failed this function returns an invalid QVariant object. The QVariant objects in vars are updated when the method has out-parameters. QAxObject * QAxBase::querySubObject ( const QCString & name, const QVariant & var1 = QVariant ( ), const QVariant & var2 = QVariant ( ), const QVariant & var3 = QVariant ( ), const QVariant & var4 = QVariant ( ), const QVariant & var5 = QVariant ( ), const QVariant & var6 = QVariant ( ), const QVariant & var7 = QVariant ( ), const QVariant & var8 = QVariant ( ) ) Returns a pointer to a QAxObject wrapping the COM object provided by the method or property name, passing passing the parameters var1, var1, var2, var3, var4, var5, var6, var7 and var8. If name is provided by a method the string must include the full function prototype. If name is a property the string must be the name of the property, and var1, ... var8 are ignored. The returned QAxObject is a child of this object (which is either of type QAxObject or QAxWidget), and is deleted when this object is deleted. It is however safe to delete the returned object yourself, and you should do so when you iterate over lists of subobjects. COM enabled applications usually have an object model publishing certain elements of the application as dispatch interfaces. Use this method to navigate the hierarchy of the object model, e.g. QAxWidget outlook( "Outlook.Application" ); QAxObject *session = outlook.querySubObject( "Session" ); if ( session ) { QAxObject *defFolder = session->querySubObject( "GetDefaultFolder(OlDefaultFolders)", "olFolderContacts" ); //... } Example: qutlook/centralwidget.cpp. bool QAxWidget::translateKeyEvent ( int message, int keycode ) const [virtual protected] Reimplement this function to pass certain key events to the ActiveX control. message is the Window message identifier specifying the message type (ie. WM_KEYDOWN), and keycode is the virtual keycode (ie. VK_TAB). If the function returns TRUE the key event is passed on to the ActiveX control, which then either processes the event or passes the event on to Qt. If the function returns FALSE the processing of the key event is ignored by ActiveQt, ie. the ActiveX control might handle it or not. The default implementation returns TRUE for the following cases: <center>.nf </center> This table is the result of experimenting with popular ActiveX controls, ie. Internet Explorer and Microsoft Office applications, but for some controls it might require modification. SEE ALSO
http://doc.trolltech.com/qaxwidget.html http://www.trolltech.com/faq/tech.html COPYRIGHT
Copyright 1992-2007 Trolltech ASA, http://www.trolltech.com. See the license file included in the distribution for a complete license statement. AUTHOR
Generated automatically from the source code. BUGS
If you find a bug in Qt, please report it as described in http://doc.trolltech.com/bughowto.html. Good bug reports help us to help you. Thank you. The definitive Qt documentation is provided in HTML format; it is located at $QTDIR/doc/html and can be read using Qt Assistant or with a web browser. This man page is provided as a convenience for those users who prefer man pages, although this format is not officially supported by Trolltech. If you find errors in this manual page, please report them to qt-bugs@trolltech.com. Please include the name of the manual page (qaxwidget.3qt) and the Qt version (3.3.8). Trolltech AS 2 February 2007 QAxWidget(3qt)
All times are GMT -4. The time now is 01:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy