Sponsored Content
Top Forums Shell Programming and Scripting Greping columns data from file. Post 302221799 by esungoe on Tuesday 5th of August 2008 08:11:21 AM
Old 08-05-2008
Great era,
Thanks i was not aware of -silent feature of sqlplus ..

now without greping i got my desire output.

//Regards
Sunil Goyal
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help with Data Positioning from Columns in a flat file.

Hi All, I have used this forum many times to solve my many scripting problems. This time, I would like to seek some answers to a problem that I've been head scratching quite a bit on. My Example: I am converting a 2000-byte file into a 300-byte file this file has no delimiters and hardly any... (3 Replies)
Discussion started by: oott1
3 Replies

2. Shell Programming and Scripting

Need Help for Adding Three new columns in existing file from fatching data from file

not required this time (36 Replies)
Discussion started by: Sandeep_Malik
36 Replies

3. UNIX for Advanced & Expert Users

Create a file and enter data in columns

Hello!!!!!!!! I have an issue regarding inserting records in a file columnwise.Is it possible using awk/nawk script? Example: File1: 1|AAA|25|2 5|qqe|20|7 4|wer|31|81 I need to create a second file in which data can be inserted in a columnwise manner i.e. File2: AAA|25|1|2... (1 Reply)
Discussion started by: abhijeet1409
1 Replies

4. UNIX and Linux Applications

Initializing columns to NULL an saving data to a new file

Hi I've been trying to delete columns from a file, and the best option I could come up was to initialise them to NULL. The reason for this is because I need to compare the differences between 2 files with those specific columns excluded. Here is my script: #!/bin/bash... (4 Replies)
Discussion started by: ladyAnne
4 Replies

5. Shell Programming and Scripting

Finding standard deviation for all columns in a data file

Hi All, I want someone to modify the below script from this forum so that it can be used for all columns in the file( instead of only printing column 3 mean and standard deviation values). I don't know how to loop around all the columns. ... (3 Replies)
Discussion started by: ks_reddy
3 Replies

6. Shell Programming and Scripting

awk based script to find the average of all the columns in a data file

Hi All, I need the modification for the below mentioned code (found in one more post https://www.unix.com/shell-programming-scripting/27161-script-generate-average-values.html) to find the average values for all the columns(but for a specific rows) and print the averages side by side. I have... (4 Replies)
Discussion started by: ks_reddy
4 Replies

7. Shell Programming and Scripting

validating data in columns and writing them to new file

I have a file that contains records in the below format: 23857250998423948239482348239580923682396829682398094823049823948 23492780582305829852095820958293582093585823095892386293583203248 23482038509825098230958235234230502958205983958235820358205892095... (10 Replies)
Discussion started by: shellhelp
10 Replies

8. Shell Programming and Scripting

Insert space or pattern between columns in a data file

I have a data file where three data sets are written in three columns. Can I increase the space between the columns without reading them? Also can I insert particular patterns, say comma between 1st and 2nd column and colon between 2nd and 3rd column? (13 Replies)
Discussion started by: hbar
13 Replies

9. UNIX for Beginners Questions & Answers

Delimiter appending in a data file if we receive a less columns than expected

Required No.of field = 12 Let say you got a “~” delimited input file and this file has 6 input fields and now I want to add 12-5=7 number of “~” into this input file in order to make it 12 fields datafile can have n number of records ex., a~b~c~d~12~r a~b~c~d~12~r a~b~c~d~12~r... (19 Replies)
Discussion started by: LJJ
19 Replies
langinfo.h(3HEAD)                                                     Headers                                                    langinfo.h(3HEAD)

NAME
langinfo.h, langinfo - language information constants SYNOPSIS
#include <langinfo.h> DESCRIPTION
The <langinfo.h> header contains the constants used to identify items of langinfo data (see nl_langinfo(3C)). The type of the constant, nl_item, is defined as described in <nl_types.h>. The following constants are defined. The entries under Category indicate in which setlocale(3C) category each item is defined. Constant Category Meaning CODESET LC_CTYPE codeset name D_T_FMT LC_TIME string for formatting date and time D_FMT LC_TIME date format string T_FMT LC_TIME time format string T_FMT_AMPM LC_TIME a.m. or p.m. time format string AM_STR LC_TIME ante-meridiem affix PM_STR LC_TIME post-meridiem affix DAY_1 LC_TIME name of the first day of the week (for example, Sunday) DAY_2 LC_TIME name of the second day of the week (for example, Monday) DAY_3 LC_TIME name of the third day of the week (for example, Tuesday) DAY_4 LC_TIME name of the fourth day of the week (for example, Wednesday) DAY_5 LC_TIME name of the fifth day of the week (for example, Thursday) DAY_6 LC_TIME name of the sixth day of the week (for example, Friday) DAY_7 LC_TIME name of the seventh day of the week (for example, Saturday) ABDAY_1 LC_TIME abbreviated name of the first day of the week ABDAY_2 LC_TIME abbreviated name of the second day of the week ABDAY_3 LC_TIME abbreviated name of the third day of the week ABDAY_4 LC_TIME abbreviated name of the fourth day of the week ABDAY_5 LC_TIME abbreviated name of the fifth day of the week ABDAY_6 LC_TIME abbreviated name of the seventh day of the week ABDAY_7 LC_TIME abbreviated name of the seventh day of the week MON_1 LC_TIME name of the first month of the year MON_2 LC_TIME name of the second month MON_3 LC_TIME name of the third month MON_4 LC_TIME name of the fourth month MON_5 LC_TIME name of the fifth month MON_6 LC_TIME name of the sixth month MON_7 LC_TIME name of the seventh month MON_8 LC_TIME name of the eighth month MON_9 LC_TIME name of the ninth month MON_10 LC_TIME name of the tenth month MON_11 LC_TIME name of the eleventh month MON_12 LC_TIME name of the twelfth month ABMON_1 LC_TIME abbreviated name of the first month ABMON_2 LC_TIME abbreviated name of the second month ABMON_3 LC_TIME abbreviated name of the third month ABMON_4 LC_TIME abbreviated name of the fourth month ABMON_5 LC_TIME abbreviated name of the fifth month ABMON_6 LC_TIME abbreviated name of the sixth month ABMON_7 LC_TIME abbreviated name of the seventh month ABMON_8 LC_TIME abbreviated name of the eighth month ABMON_9 LC_TIME abbreviated name of the ninth month ABMON_10 LC_TIME abbreviated name of the tenth month ABMON_11 LC_TIME abbreviated name of the eleventh month ABMON_12 LC_TIME abbreviated name of the twelfth month ERA LC_TIME era description segments ERA_D_FMT LC_TIME era date format string ERA_D_T_FMT LC_TIME era date and time format string ERA_T_FMT LC_TIME era time format string ALT_DIGITS LC_TIME alternative symbols for digits RADIXCHAR LC_NUMERIC radix character THOUSEP LC_NUMERIC separator for thousands YESEXPR LC_MESSAGES affirmative response expression NOEXPR LC_MESSAGES negative response expression YESSTR LC_MESSAGES affirmative response for yes/no queries NOSTR LC_MESSAGES negative response ro yes/no queries CRNCYSTR LC_MONETARY local currency symbol, preceded by '-' if the symbol sould appear before the value, '+' if the symbol should appear after the value, or '.' if the symbol should replace the radix character If the locale's values for p_cs_precedes and n_cs_precedes do not match, the value of nl_langinfo(CRNCYSTR) is unspecified. The <langinfo.h> header declares the following as a function: char *nl_langinfo(nl_item); Inclusion of <langinfo.h> header may also make visible all symbols from <nl_types.h>. USAGE
Wherever possible, users are advised to use functions compatible with those in the ISO C standard to access items of langinfo data. In par- ticular, the strftime(3C) function should be used to access date and time information defined in category LC_TIME. The localeconv(3C) func- tion should be used to access information corresponding to RADIXCHAR, THOUSEP, and CRNCYSTR. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Interface Stability |Standard | +-----------------------------+-----------------------------+ SEE ALSO
mkmsgs(1), localeconv(3C), nl_langinfo(3C), nl_types.h(3HEAD), setlocale(3C), strftime(3C), attributes(5), standards(5) SunOS 5.10 30 Aug 2002 langinfo.h(3HEAD)
All times are GMT -4. The time now is 02:40 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy