Sponsored Content
Top Forums Shell Programming and Scripting Parsing issue while reading excel having 3000 record Post 302536982 by premp26 on Wednesday 6th of July 2011 06:52:01 PM
Old 07-06-2011
Parsing issue while reading excel having 3000 record

Hi
Need urgent help

Last edited by premp26; 08-29-2011 at 02:11 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Parsing a variable length record

I need to pick a field out of a variable record - the field is always found 4 fields after a certain text string, but it can be on any line of the record and in any position across the record on a line. I have had no luck through any of the Unix editors being able to cut a field that isn't always... (17 Replies)
Discussion started by: Barb
17 Replies

2. UNIX and Linux Applications

Reading and Writing from Excel using Unix scripting

Hi All, I want to read and write into Excel files. I want my script to generate the required output directly in the Excel format. Is it possible through unix scripting or shall I have to use some other language for this purpose? Waiting for your suggestion. Thanks in Advance. ... (3 Replies)
Discussion started by: AshishK
3 Replies

3. Shell Programming and Scripting

reading data from excel using shell script

Hi all I am new to shell scripting. I need to write a shell script that reads each row of an USER_ID colume in a excel file. the excel has around 10000 rows of data. Can someone gives me some example or advice what's best way to do this thanks (11 Replies)
Discussion started by: tiger99
11 Replies

4. UNIX for Dummies Questions & Answers

Parsing out records from one huge record

Hi, I have one huge record and know that each record in the file is 550 bytes long. How do I parse out individual records from the single huge record. Thanks, (4 Replies)
Discussion started by: bwrynz1
4 Replies

5. UNIX for Advanced & Expert Users

Parsing records from one record

Hi, I got a file which is one huge record. I know each record should be 550 bytes long. How do I parse out the records from the one huge record. (1 Reply)
Discussion started by: bwrynz1
1 Replies

6. Shell Programming and Scripting

Skip parsing the header record - Awk

Guys.... Got a scenario in which I need to skip parsing the header record while I do an awk. Does awk has the flexibility to accomplish this?. If so, how do we do this?. Thanks !!! -Anduzzi :) (2 Replies)
Discussion started by: anduzzi
2 Replies

7. Shell Programming and Scripting

urgent<parsing data from a excel file>

Hi all, I wud like to get ur assistance in retrieving lines containing l1.My excel dataset contains around 8000 lines.I converted it into a text tab delimiter file and got the lines containing l1,My output is a list of lines containing l1 saved in a outfile.Some of d lines from my outfile s... (5 Replies)
Discussion started by: sayee
5 Replies

8. Programming

Excel reading on Linux using Java

Hi, I have a requirement where users will send excel(.xls) file to Linux Platform using ftp/sftp. After that the excel file needs to be read using java on linux and converted into csv. I am using jxl to parse the excel, but few character like £ are not getting parsed properly. If i open the... (0 Replies)
Discussion started by: joy_bt
0 Replies

9. Shell Programming and Scripting

Perl Reading Excel sheet isssue

There is a perl scriptwhich will read Excel sheet and create one file(.v) . Excel sheet::: A B C D 1 cpu_dailog 2 3 4 Perl will create the file(.v) like thsi ::: assert (cpu_dailog_iso ==2) ; assert (cpu_dailog_reset ==3); assert (cpu_dailog_idle... (3 Replies)
Discussion started by: naaj_ila
3 Replies

10. Shell Programming and Scripting

Reading specific range of columns in an Excel file

Hi All, I want to read an excel file. PFA excel, I want to read the cloumn from A to G and the V to AH starting from Row number 3. Please help me on this. (7 Replies)
Discussion started by: Abhisrajput
7 Replies
sys_attrs_inet(5)						File Formats Manual						 sys_attrs_inet(5)

NAME
sys_attrs_inet - inet subsystem attributes DESCRIPTION
This reference page lists and describes attributes for the Internet (inet) kernel subsystem. Refer to the sys_attrs(5) reference page for an introduction to the topic of kernel subsystem attributes. The number of hash buckets in the kernel interface alias table (in_ifaddr). The value of the inifaddr_hsize attribute is always rounded down to the nearest power of 2. The maximum value is 512. Default value: 32 (hash buckets) Minimum value: 16 Maximum value: 512 The default Internet Protocol (IP) time-to-live value. Default value: DEFTTL, or 64 (router hops) Minimum value: 0 Maximum value: 255 A value that enables (1) or disables (0) a check to determine whether an IP datagram whose destination address is a directed broad- cast address has been received on the interface corresponding to that broadcast address. Default value: 0 (disabled) A value that enables (1) or disables (0) a system's ability to forward IP packets that are not addressed to the system. This func- tionality is usually enabled by using the /usr/sbin/iprsetup command. Default value: 0 (disabled) For systems functioning as routers, both ipforwarding and ipgateway attributes must be 1. Maximum time an IP fragment can spend waiting to be reassembled. Default value: IPFRAGTTL (60, in units of .5 seconds, or 30 seconds) Minimum value: 1 Maximum value: INT_MAX, or 2 billion A value that enables (1) or disables (0) a system's ability to forward IP packets that are not addressed to the system. This func- tionality is usually enabled by using the /usr/sbin/iprsetup command. Default value: 0 (disabled) For systems functioning as routers, both ipforwarding and ipgateway attributes must be 1. The number of times a system can simultaneously make outgoing connections to other systems. The number of outgoing ports is the value of the ipport_userreserved attribute minus the value of the ipport_userreserved_min attribute. The default value of the attribute is 5000; therefore, the default number of outgoing ports is 3976. Default value: 5000 Minimum value: 1 Maximum value: 65535 The lower limit of range of port numbers available for use by a TCP or UDP application. The number of outgoing ports is the value of the ipport_userreserved attribute minus the value of the ipport_userreserved_min attribute. The default value of the attribute is 5000; therefore, the default number of outgoing ports is 3976. Default value: 1024 Minimum value: 1 Maximum value: 65535 Maximum length of the IP input queue (ipintrq) before input packets are dropped. Default value: 1024 (bytes) Minimum value: 1024 Maximum value: 65535 Maximum number of IP input queues. Default value: 1 (queues) Minimum value: 1 Maximum value: 64 A value that enables (1) or disables (0) the sending of ICMP redirect messages. Default value: 1 (enabled) Enables (1) or disables (0) source routing. Default value: 1 (enabled) Time to wait after a decrease in a PMTU value before attempting to determine if the PMTU value has increased. Default value: PMTU_DECREASE_INTVL, or 1200 (in units of .5 seconds) Minimum value: 1 Maximum value: UINT_MAX, or 4 billion A value that enables (1) or disables (0) discovery of the path maximum transfer unit (PMTU). Default value: 1 (enabled) Time to wait after an increase in a PMTU value before attempting to determine if the PMTU has increased. Default value: PMTU_INCREASE_INTVL, or 240 (in units of .5 seconds) Minimum value: 1 Maximum value: UINT_MAX, or 4 billion The timer processing interval for routes participating in the PMTU discovery process. Default value: PMTU_RT_CHECK_INTVL, or 20 (in units of .5 seconds) Minimum value: 1 Maximum value: UINT_MAX, or 4 billion A value that enables (1) or disables (0), consideration of all IP addresses in the same network as being local. When this value is 1, all IP addresses that are in different subnets but in the same network are considered local. When this value is 0, only the IP addresses that match a directly connected subnet are considered local. Default value: 1 (enabled) The number of Transmission Control Protocol (TCP) hash tables. Default value: 1 (table) Minimum value: 1 Maximum value: 64 The number of buckets in the TCP inpcb hash table. Default value: 512 (buckets) Minimum value: 0 Maximum value: INT_MAX, or 2 billion Enables (1) or disables (0) optimization of the listen path for server sockets. Default value: 1 (enabled) A value that enables (1) or disables (0) 4.2 BSD-compatible behavior for the initial send sequence of numbers and keepalives. Default value: 1 (enabled) The number of initial segments to send during congestion window negotiation. Default value: 2 (segments) Minimum value: 1 Maximum value: UINT_MAX, or 4 billion A value that enables (0) or disables (1) window scaling. Default value: 0 (enabled) Note The values for disabling and enabling are the reverse of what they are for most other attributes. A value that enables (1) or disables (0) TCP keepalive for all sockets. TCP keepalive supports the periodic transmission of messages on a connected socket in order to keep connections active. If keepalive is enabled, sockets that do not exit cleanly are cleaned up when the keepalive interval expires. If keepalive is not enabled, those sockets will continue to exist until you reboot the sys- tem. Default value: 0 (disabled) Applications enable keepalive for sockets by setting the setsockopt() function's SO_KEEPALIVE option. Use the tcp_keepalive_default attribute to override programs that do not set keepalive on their own, particularly if you have no access to the sources for those programs. Maximum number of keepalive probes that can be sent before a connection is dropped. Default value: TCPTV_KEEPCNT, or 8 (probes) Minimum value: 1 Maximum value: 32767 Idle time before the first keepalive probe. Default value: TCPTV_KEEP_IDLE, or 14400 (in units of .5 seconds) Minimum value: 1 Maximum value: 32767 Initial connect timeout. Default value: TCPTV_KEEP_INIT, or 150 (in units of .5 seconds) Minimum value: 1 Maximum value: 32767 Time between keepalive probes. Default value: TCPTV_KEEP_INTVL, or 150 (in units of .5 seconds) Minimum value: 1 Maximum value: 32767 The maximum lifetime of a TCP segment. Default value: 60 (in units of .5 seconds) Minimum value: 1 Maximum value: 2 billion Default maximum segment size. Default value: TCP_MSS, or 536 (bytes) Minimum value: 1 Maximum value: 2 billion Default receive buffer size for TCP sockets. Default value: TCP_RECVSPACE, or 61440 (bytes) Minimum value: 1 Maximum value: 4 billion (cannot be larger than sb_max) Minimum amount of time between TCP retransmissions. Default value: 2 (in units of .5 seconds), or 1 second Minimum value: 1 Maximum value: 2 billion The maximum number of TCP retransmitted packets to send before giving up. Default value: 128 (packets) Minimum value: 1 Maximum value: INT_MAX, or 2 billion Initial assumed round-trip time, in seconds. Default value: 3 (seconds) Minimum value: 0 Maximum value: INT_MAX, or 2 billion Default send buffer size, in bytes, for TCP sockets. Default value: TCP_SENDSPACE, or 61440 (bytes) Minimum value: 1 Maximum value: UINT_MAX, or 4 billion (cannot be larger than sb_max) IP time-to-live, in router hops, for TCP packets. Default value: TCP_TTL, or 60 (router hops) Minimum value: 0 Maximum value: 255 A value that enables (1) or disables (0) 4.2 BSD-compatible behavior for an urgent pointer. The urgent pointer is a pointer to the first octet of data past the urgent section. When disabled, the urgent pointer is a pointer to the last octet of data in the urgent section. Default value: 1 (enabled) A value that enables (0) or disables (1) delayed acknowledgments. Default value: 0 (enabled) Note The values for disabling and enabling are the reverse of what they are for most other attributes. Number of duplicate acknowledgments (ACKs) before retransmission. Default value: TCPREXMTTHRESH, or 3 (duplicate acknowledgements) Minimum value: 1 Maximum value: INT_MAX, or 2 billion A value that enables (1) or disables (0) the movement of TCP inpcbs in the TIME_WAIT state to the end of the inpcb list. Default value: 0 (disabled) Default receive buffer size, in bytes, for UDP sockets. Default value: UDP_RECVSPACE, or 42240 (bytes) Minimum value: 1 Maximum value: UINT_MAX, or 4 billion (cannot be larger than sb_max) Default send buffer size, in bytes, for UDP sockets. Default value: UDP_SENDSPACE, or 9216 (bytes) Minimum value: 1 Maximum value: UINT_MAX, or 4 billion (cannot be larger than sb_max) IP time-to-live, in router hops, for UDP packets. Default value: UDP_TTL, or 30 (router hops) Minimum value: 0 Maximum value: 255 A value that enables (1) or disables (0) checksumming in the Internet user datagram protocol (UDP). Default value: 1 (enabled) SEE ALSO
sys_attrs(5) Tuning Tru64 UNIX for Internet Servers at the following location: http://www.digital.com/internet/document/ias/tuning.html. System Configuration and Tuning sys_attrs_inet(5)
All times are GMT -4. The time now is 03:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy