Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Insert Inverted Commas Around Numeric Values
Top Forums Shell Programming and Scripting Insert Inverted Commas Around Numeric Values Post 302581613 by drl on Tuesday 13th of December 2011 01:20:34 PM
Old 12-13-2011
Hi.
Code:
echo 1111,2222,3333,4444 | sed "s/\([0-9][0-9]*\)/'\1'/g"

producing:
Code:
'1111','2222','3333','4444'

Where ['] is a straight single-quote, an apostrophe, Dec 39:
Code:
Dec Hex    Dec Hex    Dec Hex  Dec Hex  Dec Hex  Dec Hex   Dec Hex   Dec Hex  
  0 00 NUL  16 10 DLE  32 20    48 30 0  64 40 @  80 50 P   96 60 `  112 70 p
  1 01 SOH  17 11 DC1  33 21 !  49 31 1  65 41 A  81 51 Q   97 61 a  113 71 q
  2 02 STX  18 12 DC2  34 22 "  50 32 2  66 42 B  82 52 R   98 62 b  114 72 r
  3 03 ETX  19 13 DC3  35 23 #  51 33 3  67 43 C  83 53 S   99 63 c  115 73 s
  4 04 EOT  20 14 DC4  36 24 $  52 34 4  68 44 D  84 54 T  100 64 d  116 74 t
  5 05 ENQ  21 15 NAK  37 25 %  53 35 5  69 45 E  85 55 U  101 65 e  117 75 u
  6 06 ACK  22 16 SYN  38 26 &  54 36 6  70 46 F  86 56 V  102 66 f  118 76 v
  7 07 BEL  23 17 ETB  39 27 '  55 37 7  71 47 G  87 57 W  103 67 g  119 77 w
  8 08 BS   24 18 CAN  40 28 (  56 38 8  72 48 H  88 58 X  104 68 h  120 78 x
  9 09 HT   25 19 EM   41 29 )  57 39 9  73 49 I  89 59 Y  105 69 i  121 79 y
 10 0A LF   26 1A SUB  42 2A *  58 3A :  74 4A J  90 5A Z  106 6A j  122 7A z
 11 0B VT   27 1B ESC  43 2B +  59 3B ;  75 4B K  91 5B [  107 6B k  123 7B {
 12 0C FF   28 1C FS   44 2C ,  60 3C <  76 4C L  92 5C \  108 6C l  124 7C |
 13 0D CR   29 1D GS   45 2D -  61 3D =  77 4D M  93 5D ]  109 6D m  125 7D }
 14 0E SO   30 1E RS   46 2E .  62 3E >  78 4E N  94 5E ^  110 6E n  126 7E ~
 15 0F SI   31 1F US   47 2F /  63 3F ?  79 4F O  95 5F _  111 6F o  127 7F DEL

The curly version is ['] , pasted from http://en.wikipedia.org/wiki/Quotation_mark

Best wishes ... cheers, drl
Last edited by drl; 12-13-2011 at 02:44 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace spaces with 0's having numeric values.

What could be the regular expression with gsub function in awk to replace all numerics having spaces before to be replaced with 0s? (1 Reply)
Discussion started by: videsh77
1 Replies

2. UNIX for Dummies Questions & Answers

How do I insert commas/delimiters in File

Hi, Newbie here. Need to convert a txt file to .csv format. There's no character to replace so not sure if I can use sed :confused: . The comma is to be inserted after every certain number of characters in each line... Help! Thanks. (4 Replies)
Discussion started by: mbelen
4 Replies

3. Shell Programming and Scripting

difference between double inverted coma and single inverted comma

Whats the basic difference between double inverted comma and single inverted comma and no comma applied at all? Eg1 if Eg2 if iEg3 f (1 Reply)
Discussion started by: abhisekh_ban
1 Replies

4. Programming

numeric values ending in 'U'

I am getting back on the C++ programming after many years away. I recently received an SDK that has code like this where numeric values end in 'U'. What does this mean? if ((ptr % 16U) == 0U) return buffer; (3 Replies)
Discussion started by: sneakyimp
3 Replies

5. UNIX for Dummies Questions & Answers

Insert Commas at fixed positions

Hi I have a text file which is position delimited, i.e. Code1 Description1 Value1 Code2 Description2 Value2 etc. I want to import this file into MySQL so I want to convert the file into Comma delimited format. To do this I want to insert commas at fixed positions on... (7 Replies)
Discussion started by: arossco
7 Replies

6. Shell Programming and Scripting

CSV with commas in field values, remove duplicates, cut columns

Hi Description of input file I have: ------------------------- 1) CSV with double quotes for string fields. 2) Some string fields have Comma as part of field value. 3) Have Duplicate lines 4) Have 200 columns/fields 5) File size is more than 10GB Description of output file I need:... (4 Replies)
Discussion started by: krishnix
4 Replies

7. Shell Programming and Scripting

Inverted commas replace

Hi, My input file is like this chr1 + "NM_1234" chr1 - "NM_1234" If I want my third column to contain both the first and second column values, how do I do it? I know how to do it by including the column numbers, but I want the values before the inverted commas. So, my output would... (5 Replies)
Discussion started by: jacobs.smith
5 Replies

8. UNIX for Dummies Questions & Answers

Insert single quote and commas

Hi All, I have a set of data as below : XS012371378 Raj 23-09-12 SH128238948 Andrew 24-08-12 CH273712399 Walsh 12-10-12 JK7249923893 Nick 10-02-13 JP6383791389 Braslin 30-12-13 I want the first column to be extracted separately. I can get this using awk. awk '{print $1}' file_name ... (3 Replies)
Discussion started by: Nand Kishor
3 Replies

9. UNIX for Beginners Questions & Answers

Insert commas

Original content: ACACCTCAT 129 | ACACCTCAT 0 ACACCTCATX 171 | ACACCTCATX 0 ACACRESRT 0 ACACRESRT 0 ACACRESRTX 0 ... (4 Replies)
Discussion started by: loktamann
4 Replies

10. UNIX for Beginners Questions & Answers

Replace a numeric values in a certain column

Hi All, I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7 I tried awk '{gsub("8","7",$35)}1' infile > outfile ----> not working sed -i 's/8/7'g' infile --- it is replacing all... (3 Replies)
Discussion started by: arunkumar_mca
3 Replies

LEARN ABOUT HPUX

ascii

ascii(5)							File Formats Manual							  ascii(5)

NAME

       ascii - map of ASCII character set

SYNOPSIS

DESCRIPTION

       The file provides a map of the ASCII character set, giving both octal and hexadecimal equivalents of each character.  The file contains the
       following text:

	      |000 nul|001 soh|002 stx|003 etx|004 eot|005 enq|006 ack|007 bel|
	      |010 bs |011 ht |012 nl |013 vt |014 np |015 cr |016 so |017 si |
	      |020 dle|021 dc1|022 dc2|023 dc3|024 dc4|025 nak|026 syn|027 etb|
	      |030 can|031 em |032 sub|033 esc|034 fs |035 gs |036 rs |037 us |
	      |040 sp |041  ! |042  " |043  # |044  $ |045  % |046  & |047  ' |
	      |050  ( |051  ) |052  * |053  + |054  , |055  - |056  . |057  / |
	      |060  0 |061  1 |062  2 |063  3 |064  4 |065  5 |066  6 |067  7 |
	      |070  8 |071  9 |072  : |073  ; |074  < |075  = |076  > |077  ? |
	      |100  @ |101  A |102  B |103  C |104  D |105  E |106  F |107  G |
	      |110  H |111  I |112  J |113  K |114  L |115  M |116  N |117  O |
	      |120  P |121  Q |122  R |123  S |124  T |125  U |126  V |127  W |
	      |130  X |131  Y |132  Z |133  [ |134   |135  ] |136  ^ |137  _ |
	      |140  ` |141  a |142  b |143  c |144  d |145  e |146  f |147  g |
	      |150  h |151  i |152  j |153  k |154  l |155  m |156  n |157  o |
	      |160  p |161  q |162  r |163  s |164  t |165  u |166  v |167  w |
	      |170  x |171  y |172  z |173  { |174  | |175  } |176  ~ |177 del|

	      | 00 nul| 01 soh| 02 stx| 03 etx| 04 eot| 05 enq| 06 ack| 07 bel|
	      | 08 bs | 09 ht | 0a nl | 0b vt | 0c np | 0d cr | 0e so | 0f si |
	      | 10 dle| 11 dc1| 12 dc2| 13 dc3| 14 dc4| 15 nak| 16 syn| 17 etb|
	      | 18 can| 19 em | 1a sub| 1b esc| 1c fs | 1d gs | 1e rs | 1f us |
	      | 20 sp | 21  ! | 22  " | 23  # | 24  $ | 25  % | 26  & | 27  ' |
	      | 28  ( | 29  ) | 2a  * | 2b  + | 2c  , | 2d  - | 2e  . | 2f  / |
	      | 30  0 | 31  1 | 32  2 | 33  3 | 34  4 | 35  5 | 36  6 | 37  7 |
	      | 38  8 | 39  9 | 3a  : | 3b  ; | 3c  < | 3d  = | 3e  > | 3f  ? |
	      | 40  @ | 41  A | 42  B | 43  C | 44  D | 45  E | 46  F | 47  G |
	      | 48  H | 49  I | 4a  J | 4b  K | 4c  L | 4d  M | 4e  N | 4f  O |
	      | 50  P | 51  Q | 52  R | 53  S | 54  T | 55  U | 56  V | 57  W |
	      | 58  X | 59  Y | 5a  Z | 5b  [ | 5c   | 5d  ] | 5e  ^ | 5f  _ |
	      | 60  ` | 61  a | 62  b | 63  c | 64  d | 65  e | 66  f | 67  g |
	      | 68  h | 69  i | 6a  j | 6b  k | 6c  l | 6d  m | 6e  n | 6f  o |
	      | 70  p | 71  q | 72  r | 73  s | 74  t | 75  u | 76  v | 77  w |
	      | 78  x | 79  y | 7a  z | 7b  { | 7c  | | 7d  } | 7e  ~ | 7f del|

   Control Characters
       The following table shows the set of ASCII control characters with their octal, decimal, and hexadecimal values.  To obtain the	respective
       characters from the keyboard, use the indicated keypress combinations.

       To place control characters in a file when using the or editor, type Ctrl-before typing the desired control character.

				      +----+-----+-----+---------+--------+------------------------+--------------+
				      |Oct | Dec | Hex | Display | Symbol |	  Char Name	   |   Keypress   |
				      +----+-----+-----+---------+--------+------------------------+--------------+
				      |000 | 000 | 00  |  none	 |  NUL   | Null		   | Ctrl-Shift-@ |
				      |001 | 001 | 01  |   ^A	 |  SOH   | Start of Header	   |	Ctrl-A	  |
				      |002 | 002 | 02  |   ^B	 |  STX   | Start of Text	   |	Ctrl-B	  |
				      |003 | 003 | 03  |   ^C	 |  ETX   | End of Text 	   |	Ctrl-C	  |
				      |004 | 004 | 04  |   ^D	 |  EOT   | End of Transmission    |	Ctrl-D	  |
				      |005 | 005 | 05  |   ^E	 |  ENQ   | Enquire		   |	Ctrl-E	  |
				      |006 | 006 | 06  |   ^F	 |  ACK   | Acknowledge 	   |	Ctrl-F	  |
				      |007 | 007 | 07  |   ^G	 |  BEL   | Bell		   |	Ctrl-G	  |
				      +----+-----+-----+---------+--------+------------------------+--------------+
				      |010 | 008 | 08  |   ^H	 |   BS   | Back Space		   |	Ctrl-H	  |
				      |011 | 009 | 09  |   ^I	 |   HT   | Horizontal Tab	   |	Ctrl-I	  |
				      |012 | 010 | 0A  |   ^J	 |   LF   | Line Feed		   |	Ctrl-J	  |
				      |013 | 011 | 0B  |   ^K	 |   VT   | Vertical Tab	   |	Ctrl-K	  |
				      |014 | 012 | 0C  |   ^L	 |   FF   | Form Feed		   |	Ctrl-L	  |
				      |015 | 013 | 0D  |   ^M	 |   CR   | Carriage Return	   |	Ctrl-M	  |
				      |016 | 014 | 0E  |   ^N	 |   SO   | Shift Out		   |	Ctrl-N	  |
				      |017 | 015 | 0F  |   ^O	 |   SI   | Shift In		   |	Ctrl-O	  |
				      +----+-----+-----+---------+--------+------------------------+--------------+
				      |020 | 016 | 10  |   ^P	 |  DLE   | Data Link Escape	   |	Ctrl-P	  |
				      |021 | 017 | 11  |   ^Q	 |  DC1   | Device Control 1	   |	Ctrl-Q	  |
				      |022 | 018 | 12  |   ^R	 |  DC2   | Device Control 2	   |	Ctrl-R	  |
				      |023 | 019 | 13  |   ^S	 |  DC3   | Device Control 3	   |	Ctrl-S	  |
				      |024 | 020 | 14  |   ^T	 |  DC4   | Device Control 4	   |	Ctrl-T	  |
				      |025 | 021 | 15  |   ^U	 |  NAK   | Negative Acknowledge   |	Ctrl-U	  |
				      |026 | 022 | 16  |   ^V	 |  SYN   | Synchronize 	   |	Ctrl-V	  |
				      |027 | 023 | 17  |   ^W	 |  ETB   | End Transmission Block |	Ctrl-W	  |
				      +----+-----+-----+---------+--------+------------------------+--------------+
				      |030 | 024 | 18  |   ^X	 |  CAN   | Cancel		   |	Ctrl-X	  |
				      |031 | 025 | 19  |   ^Y	 |   EM   | End of Medium	   |	Ctrl-Y	  |
				      |032 | 026 | 1A  |   ^Z	 |  SUB   | Substitute		   |	Ctrl-Z	  |
				      |033 | 027 | 1B  |   ^[	 |  ESC   | Escape		   |	Ctrl-[	  |
				      |034 | 028 | 1C  |   ^	 |   FS   | File Separator	   |	Ctrl-	  |
				      |035 | 029 | 1D  |   ^]	 |   GS   | Group Separator	   |	Ctrl-]	  |
				      |036 | 030 | 1E  |   ^^	 |   RS   | Record Separator	   | Ctrl-Shift-^ |
				      |037 | 031 | 1F  |   ^_	 |   US   | Unit Separator	   | Ctrl-Shift-_ |
				      +----+-----+-----+---------+--------+------------------------+--------------+
				      |177 | 127 | 7F  |   ^?	 |  DEL   | Delete		   |	 DEL	  |
				      +----+-----+-----+---------+--------+------------------------+--------------+
WARNINGS

       Note  that some HP-UX subsystems, such as the keyboard interface, window systems, and other system software, may use selected keyboard con-
       trol characters for special purposes, possibly causing unexpected results.

FILES

																	  ascii(5)
All times are GMT -4. The time now is 08:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy