Sponsored Content
Top Forums Shell Programming and Scripting Parse comma delimited and optionally quotes dimilited file Post 302239577 by vramana2003 on Wednesday 24th of September 2008 04:17:04 AM
Old 09-24-2008
Hi era,

Sry. I can't use perl..

Thank you.
Ram
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comma Delimited file

I have a comma delimited file that sometimes has addresses details in. The problem is that the address detail can be seen as: "Sample House, Sample Road". When I run a script specifying the file is comma delimited I would like it to ignore comma's that are in between speech marks. Is this... (2 Replies)
Discussion started by: dbrundrett
2 Replies

2. Shell Programming and Scripting

Converting Tab delimited file to Comma delimited file in Unix

Hi, Can anyone let me know on how to convert a Tab delimited file to Comma delimited file in Unix Thanks!! (22 Replies)
Discussion started by: charan81
22 Replies

3. Shell Programming and Scripting

Parsing comma delimited text file

I need to delete a set of files in certain directories if there're older than a certain number of days. So I have a text file, with each line containing the directory & number of days. The format is like this: dirA,5 dirB,7 How do I write script to iteratively parse this text file & delete... (5 Replies)
Discussion started by: chengwei
5 Replies

4. UNIX for Dummies Questions & Answers

Comma delimited file

Hi All, I have output of sql saved in comma separated file. Now i need to read line by line this file and assign word to a unix variable for further processing Eg: Test file world, 1, 3, 4 earth,2,3,4,5 moon,1,2,3,4 Output should be word1= world word2=1 echo " first word... (7 Replies)
Discussion started by: gwrm
7 Replies

5. Shell Programming and Scripting

Replacing comma with in double quotes in a csv file

Hello, I need to read a csv file and I am trying to replace a comma with a text DSEE?DSEE. Example Input "Chapter","NewTrains, "oldTrains","Delayed",10,"London" "Chapter","Newbuses,oldbuses","On Time",20,"London" Output "Chapter","NewTrainsDSEE?DSEE... (5 Replies)
Discussion started by: venkatvani
5 Replies

6. UNIX for Dummies Questions & Answers

Flat File - Comma Delimited

I have a flat file whose contents are comma delimited and there are 84 columns in total, so everytime I try to view the contents, things get over lapped it becomes diffcult to read through the result set. Is there a command / what would be the best way...if I want to view the results alligned... (4 Replies)
Discussion started by: priya33184
4 Replies

7. Shell Programming and Scripting

Comma delimited file manipulation

Question about how to change the first & last name in column one & two so that the names have a capital letter for just the first letter. Example: asdf@asdf.com,asdf,asdfasdf,176.23.22.345,4/12/2012 changed to: asdf@asdf.com,Asdf,Asdfasdf,176.23.22.345,4/12/2012 Thank you kindly, Nick (2 Replies)
Discussion started by: nickytcom
2 Replies

8. Shell Programming and Scripting

Need a script to convert comma delimited files to semi colon delimited

Hi All, I need a unix script to convert .csv files to .skv files (changing a comma delimited file to a semi colon delimited file). I am a unix newbie and so don't know where to start. The script will be scheduled using cron and needs to convert each .csv file in a particular folder to a .skv... (4 Replies)
Discussion started by: CarpKing
4 Replies

9. Shell Programming and Scripting

Help/Advise please for converting space delimited string variable to comma delimited with quote

Hi, I am wanting to create a script that will construct a SQL statement based on a a space delimited string that it read from a config file. Example of the SQL will be For example, it will read a string like "AAA BBB CCC" and assign to a variable named IN_STRING. I then concatenate... (2 Replies)
Discussion started by: newbie_01
2 Replies

10. Shell Programming and Scripting

awk to parse comma separated field and removing comma in between number and double quotes

Hi Experts, Please support I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6. ... (3 Replies)
Discussion started by: as7951
3 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 03:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy