Sponsored Content
Top Forums Shell Programming and Scripting Script for extracting data from csv file based on column values. Post 302848219 by rdcwayx on Wednesday 28th of August 2013 08:29:18 PM
Old 08-28-2013
so what did you try? Here are hints.

-f FILENAME can be used to identify if the file is exist or not.

awk can be used to get the report.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extracting data from a .csv file

I have a .csv file equipment,bandtype abc,aws def,mmds ghi,umts jkl,mmds I can get the equipment from `hostname`. In my script i want to check what is the hostname. then see if it exists in the.csv file. if it does then i want to store the second parameter(bandtype) for the corresponding... (3 Replies)
Discussion started by: lassimanji
3 Replies

2. UNIX for Dummies Questions & Answers

Extracting rows from a text file based on numerical values of a column

I have a text file where the second column is a list of numbers going from small to large. I want to extract the rows where the second column is smaller than or equal to 0.0001. My input: rs10082730 9e-08 12 46002702 rs2544081 1e-07 12 46015487 rs1425136 1e-06 7 35396742 rs2712590... (1 Reply)
Discussion started by: evelibertine
1 Replies

3. UNIX for Dummies Questions & Answers

Extracting rows from a space delimited text file based on the values of a column

I have a space delimited text file. I want to extract rows where the third column has 0 as a value and write those rows into a new space delimited text file. How do I go about doing that? Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies

4. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file based on certain conditions

Hi Guys, I am new to shell script.I need your help to write a shell script. I need to write a shell script to extract data from a .csv file where columns are ',' separated. The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (1 Reply)
Discussion started by: Vivekit82
1 Replies

5. Linux

Filter a .CSV file based on the 5th column values

I have a .CSV file with the below format: "column 1","column 2","column 3","column 4","column 5","column 6","column 7","column 8","column 9","column 10 "12310","42324564756","a simple string with a , comma","string with or, without commas","string 1","USD","12","70%","08/01/2013",""... (2 Replies)
Discussion started by: dhruuv369
2 Replies

6. Shell Programming and Scripting

Fetching values in CSV file based on column name

input.csv: Field1,Field2,Field3,Field4,Field4 abc ,123 ,xyz ,000 ,pqr mno ,123 ,dfr ,111 ,bbb output: Field2,Field4 123 ,000 123 ,111 how to fetch the values of Field4 where Field2='123' I don't want to fetch the values based on column position. Instead want to... (10 Replies)
Discussion started by: bharathbangalor
10 Replies

7. Shell Programming and Scripting

Remove the values from a certain column without deleting the Column name in a .CSV file

(14 Replies)
Discussion started by: dhruuv369
14 Replies

8. Linux

To get all the columns in a CSV file based on unique values of particular column

cat sample.csv ID,Name,no 1,AAA,1 2,BBB,1 3,AAA,1 4,BBB,1 cut -d',' -f2 sample.csv | sort | uniq this gives only the 2nd column values Name AAA BBB How to I get all the columns of CSV along with this? (1 Reply)
Discussion started by: sanvel
1 Replies

9. Shell Programming and Scripting

Extracting values based on line-column numbers from multiple text files

Dear All, I have to solve the following problems with multiple tab-separated text file but I don't know how. Any help would be greatly appreciated. I have access to Linux mint (but not as a professional). I have multiple tab-delimited files with the following structure: file1: 1 44 2 ... (5 Replies)
Discussion started by: Bastami
5 Replies
XSetNormalHints(3X11)													     XSetNormalHints(3X11)

Name
       XSetNormalHints, XGetNormalHints - set or get normal state hints

Syntax
       XSetNormalHints(display, w, hints)
	     Display *display;
	     Window w;
	     XSizeHints *hints;

       Status XGetNormalHints(display, w, hints_return)
	     Display *display;
	     Window w;
	     XSizeHints *hints_return;

Arguments
       display	 Specifies the connection to the X server.

       hints	 Specifies a pointer to the size hints for the window in its normal state.

       hints_return
		 Returns the size hints for the window in its normal state.

       w	 Specifies the window.

Description
       The function sets the size hints structure for the specified window.  Applications use to inform the window manager of the size or position
       desirable for that window.  In addition, an application that wants to move or resize itself should call and specify its new  desired  loca-
       tion  and  size	as  well  as  making direct Xlib calls to move or resize.  This is because window managers may ignore redirected configure
       requests, but they pay attention to property changes.

       To set size hints, an application not only must assign values to the appropriate members in the hints structure but also must set the flags
       member of the structure to indicate which information is present and where it came from.  A call to is meaningless, unless the flags member
       is set to indicate which members of the structure have been assigned values.

       can generate and errors.

       The function returns the size hints for a window in its normal state.  It returns a nonzero status if it succeeds or zero if  the  applica-
       tion specified no normal size hints for this window.

       can generate a error.

Property
       WM_NORMAL_HINTS

Diagnostics
       The server failed to allocate the requested resource or server memory.

       A value for a Window argument does not name a defined Window.

See Also
       XSetCommand(3X11), XSetIconName(3X11), XSetIconSizeHints(3X11), XSetSizeHints(3X11), XSetStandardProperties(3X11), XSetWMHints(3X11), XSet-
       ZoomHints(3X11), XStoreName(3X11)
       Guide to the Xlib Library

															     XSetNormalHints(3X11)
All times are GMT -4. The time now is 03:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy