Cutting a file with multiple delimiters into columns Post: 302409334

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

cutting columns if delimiter has more than one charecter

Hi, My file looks like abc$%sdfhs$%sdf$%sdfaf$% here as seen delimiter is $%...now how cas i take out second field as cut command expect delimiter as single charecter only.....is there is any other way thanks and regards mahabunta

2. Shell Programming and Scripting

Cutting Columns and Moving in to a file

Guys, Can any one tell me how can we cut the columns and move each column in to a separate file using awk? I have a tab delimited file as shown below, 1213 wattt werree 2345 skhasdjh aasas I want to output this in to three files named a.txt,b.txt and c.txt say a.txt...

3. Shell Programming and Scripting

Cutting columns starting at the end of each line...

Hi Guys, Can you help me with a sed or a csh script that will have an output from the input below. Cutting the columns starting from the end of the line and not from the start of the line? Sample1 - The underscore character "_" is actually a space...i need to put it as underscore here coz...

4. UNIX for Dummies Questions & Answers

cutting columns if delimiter has more than one charecter (|^)

Hi All, I am having a file with the delimiter '|^'. File name:test_dlim.csv I want to cut the first field of this using awk command. I tried with the help of the following link:...

5. Shell Programming and Scripting

Sorting problem: Multiple delimiters, multiple keys

Hello If you wanted to sort a .csv file that was filled with lines like this: <Ticker>,<Date as YYYYMMDD>,<Time as H:M:S>,<Volume>,<Corr> (H : , M, S: ) by date, does anybody know of a better solution than to turn the 3rd and 4th colons of every line into commas, sorting on four keys,...

6. UNIX for Dummies Questions & Answers

cutting multiple columns into multiple files

Hypothetically, suppose that file1 id v1 v2 v3 v4 v5 v6 v7..........v100 1 1 1 1 1 1 2 2 .....50 2 1 1 1 1 1 2 2 .....50 3 1 1 1 1 1 2 2 .....50 4 1 1 1 1 1 2 2 .....50 5 1 1 1 1 1 2 2 .....50 I want to write a loop such that I take the id# and the first 5 columns (v1-v5) into the...

7. Shell Programming and Scripting

Awk match multiple columns in multiple lines in single file

Hi, Input 7488 7389 chr1.fa chr1.fa 3546 9887 chr5.fa chr9.fa 7387 7898 chrX.fa chr3.fa 7488 7389 chr21.fa chr3.fa 7488 7389 chr1.fa chr1.fa 3546 9887 chr9.fa chr5.fa 7898 7387 chrX.fa chr3.fa Desired Output 7488 7389 chr1.fa chr1.fa 2 3546 9887 chr5.fa chr9.fa 2...

8. UNIX for Dummies Questions & Answers

Seperate columns according to delimiters

Hi all I need your help to separate colomns based on "-" delimiter for a very big file 30 millions rows I have a colmun looking like this : clomun 1 1-100000989-A_ATC 1-10000179-AAAAA 1-100002154-TGTTA 1-100002155-GTTAG 1-100002443 1-100002490 1-100002619 I need to separte in three...

9. UNIX for Dummies Questions & Answers

Cutting specific columns from lines

I am trying to remove columns 81-97 from a line that can be as long as 114 characters. Because a number of lines might not have under 80 characters, using the cut command following by paste could be a problem. While sed might work, is there some other utility that could do this more easily? ...

10. Shell Programming and Scripting

Getting fields from a file having multiple delimiters

Hi All, I have a file with a single row having the following text ABC.ABC.ABC,Database,New123,DBNAME,F,ABC.ABC.ABC_APP,"@FUNCTION1("ENT1") ,@FUNCTION2("ENT2")",R, I want an output in the following format ABC.ABC.ABC DBNAME ABC.ABC.ABC_APP '@FUNCTION1("ENT1")...

LEARN ABOUT PHP

localeconv

LOCALECONV(3)								 1							     LOCALECONV(3)

localeconv - Get numeric formatting information

SYNOPSIS

       array localeconv (void  )

DESCRIPTION

	Returns an associative array containing localized numeric and monetary formatting information.

RETURN VALUES

       localeconv(3)  returns  data based upon the current locale as set by setlocale(3). The associative array that is returned contains the fol-
       lowing fields:

       +------------------+---------------------------------------------------+
       |  Array element   |						      |
       |		  |						      |
       |		  |		       Description		      |
       |		  |						      |
       +------------------+---------------------------------------------------+
       |  decimal_point   |						      |
       |		  |						      |
       |		  |		 Decimal point character	      |
       |		  |						      |
       |  thousands_sep   |						      |
       |		  |						      |
       |		  |		   Thousands separator		      |
       |		  |						      |
       |    grouping	  |						      |
       |		  |						      |
       |		  |	   Array containing numeric groupings	      |
       |		  |						      |
       | int_curr_symbol  |						      |
       |		  |						      |
       |		  |	International currency symbol (i.e. USD)      |
       |		  |						      |
       | currency_symbol  |						      |
       |		  |						      |
       |		  |	     Local currency symbol (i.e. $)	      |
       |		  |						      |
       |mon_decimal_point |						      |
       |		  |						      |
       |		  |	    Monetary decimal point character	      |
       |		  |						      |
       |mon_thousands_sep |						      |
       |		  |						      |
       |		  |	      Monetary thousands separator	      |
       |		  |						      |
       |  mon_grouping	  |						      |
       |		  |						      |
       |		  |	   Array containing monetary groupings	      |
       |		  |						      |
       |  positive_sign   |						      |
       |		  |						      |
       |		  |		Sign for positive values	      |
       |		  |						      |
       |  negative_sign   |						      |
       |		  |						      |
       |		  |		Sign for negative values	      |
       |		  |						      |
       | int_frac_digits  |						      |
       |		  |						      |
       |		  |	     International fractional digits	      |
       |		  |						      |
       |   frac_digits	  |						      |
       |		  |						      |
       |		  |		 Local fractional digits	      |
       |		  |						      |
       |  p_cs_precedes   |						      |
       |		  |						      |
       |		  |						      |
       |		  | TRUE  if  currency_symbol  precedes  a   positive |
       |		  | value, FALSE if it succeeds one		      |
       |		  |						      |
       | p_sep_by_space   |						      |
       |		  |						      |
       |		  |						      |
       |		  | TRUE  if a space separates currency_symbol from a |
       |		  | positive value, FALSE otherwise		      |
       |		  |						      |
       |  n_cs_precedes   |						      |
       |		  |						      |
       |		  |						      |
       |		  | TRUE  if  currency_symbol  precedes  a   negative |
       |		  | value, FALSE if it succeeds one		      |
       |		  |						      |
       | n_sep_by_space   |						      |
       |		  |						      |
       |		  |						      |
       |		  | TRUE  if a space separates currency_symbol from a |
       |		  | negative value, FALSE otherwise		      |
       |		  |						      |
       |   p_sign_posn	  |						      |
       |		  |						      |
       |		  |						      |
       |		  |						      |
       |		  |		  o0 - Parentheses surround the quan- |
       |		  |		  tity and currency_symbol	      |
       |		  |						      |
       |		  |		  o1  -  The sign string precedes the |
       |		  |		  quantity and currency_symbol	      |
       |		  |						      |
       |		  |		  o2 - The sign string	succeeds  the |
       |		  |		  quantity and currency_symbol	      |
       |		  |						      |
       |		  |		  o3  -  The  sign string immediately |
       |		  |		  precedes the currency_symbol	      |
       |		  |						      |
       |		  |		  o4 - The  sign  string  immediately |
       |		  |		  succeeds the currency_symbol	      |
       |		  |						      |
       |   n_sign_posn	  |						      |
       |		  |						      |
       |		  |						      |
       |		  |						      |
       |		  |		  o0 - Parentheses surround the quan- |
       |		  |		  tity and currency_symbol	      |
       |		  |						      |
       |		  |		  o1 - The sign string	precedes  the |
       |		  |		  quantity and currency_symbol	      |
       |		  |						      |
       |		  |		  o2  -  The sign string succeeds the |
       |		  |		  quantity and currency_symbol	      |
       |		  |						      |
       |		  |		  o3 - The  sign  string  immediately |
       |		  |		  precedes the currency_symbol	      |
       |		  |						      |
       |		  |		  o4  -  The  sign string immediately |
       |		  |		  succeeds the currency_symbol	      |
       |		  |						      |
       +------------------+---------------------------------------------------+
	The p_sign_posn, and n_sign_posn contain a string of formatting options. Each number representing one of the above listed conditions.

	The grouping fields contain arrays that define the way numbers should be grouped. For example, the monetary grouping field for	the  nl_NL
       locale  (in  UTF-8  mode  with the euro sign), would contain a 2 item array with the values 3 and 3. The higher the index in the array, the
       farther left the grouping is. If an array element is equal to CHAR_MAX, no further grouping is done. If an array element is equal to 0, the
       previous element should be used.

EXAMPLES

       Example #1

	      localeconv(3) example

	      <?php
	      if (false !== setlocale(LC_ALL, 'nl_NL.UTF-8@euro')) {
		  $locale_info = localeconv();
		  print_r($locale_info);
	      }
	      ?>

	      The above example will output:

	      Array
	      (
		  [decimal_point] => .
		  [thousands_sep] =>
		  [int_curr_symbol] => EUR
		  [currency_symbol] => EUR
		  [mon_decimal_point] => ,
		  [mon_thousands_sep] =>
		  [positive_sign] =>
		  [negative_sign] => -
		  [int_frac_digits] => 2
		  [frac_digits] => 2
		  [p_cs_precedes] => 1
		  [p_sep_by_space] => 1
		  [n_cs_precedes] => 1
		  [n_sep_by_space] => 1
		  [p_sign_posn] => 1
		  [n_sign_posn] => 2
		  [grouping] => Array
		      (
		      )

		  [mon_grouping] => Array
		      (
			  [0] => 3
			  [1] => 3
		      )

	      )

SEE ALSO

       setlocale(3).

PHP Documentation Group 													     LOCALECONV(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

cutting columns if delimiter has more than one charecter

Discussion started by: mahabunta

2. Shell Programming and Scripting

Cutting Columns and Moving in to a file

Discussion started by: Serious Sam

3. Shell Programming and Scripting

Cutting columns starting at the end of each line...

Discussion started by: elmer1503

4. UNIX for Dummies Questions & Answers

cutting columns if delimiter has more than one charecter (|^)

Discussion started by: boopathyvasagam