Insert Inverted Commas Around Numeric Values Post: 302581574

Sponsored Content

Top Forums Shell Programming and Scripting Insert Inverted Commas Around Numeric Values Post 302581574 by birei on Tuesday 13th of December 2011 11:54:57 AM

12-13-2011

Registered User

Hi RichZR,

Using Perl:

Code:

$ cat script.pl
use warnings;                                                                                                                                                                                                                                
use strict;                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                             
while ( <DATA> ) {                                                                                                                                                                                                                           
        chomp;                                                                                                                                                                                                                               
        s/^|(?=,)|(?<=,)|$/'/g;                                                                                                                                                                                                              
        printf qq[$_\n];                                                                                                                                                                                                                     
}                                                                                                                                                                                                                                            
                                                                                                                                                                                                                                             
__DATA__                                                                                                                                                                                                                                     
1111,2222,3333,4444                                                                                                                                                                                                                          
2222,3333
$ perl script.pl
'1111','2222','3333','4444'                                                                                                                                                                                                                  
'2222','3333'

Regards,
Birei

birei

View Public Profile for birei

Find all posts by birei

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?

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.

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

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;

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...

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:...

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...

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 ...

9. UNIX for Beginners Questions & Answers

Insert commas

Original content: ACACCTCAT 129 | ACACCTCAT 0 ACACCTCATX 171 | ACACCTCATX 0 ACACRESRT 0 ACACRESRT 0 ACACRESRTX 0 ...

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...

LEARN ABOUT FREEBSD

gpioctl

GPIOCTL(1)						    BSD General Commands Manual 						GPIOCTL(1)

NAME

     gpioctl -- GPIO control utility

SYNOPSIS

     gpioctl -l [-f ctldev] [-v]
     gpioctl -t [-f ctldev] pin
     gpioctl -c [-f ctldev] pin flag [flag ...]
     gpioctl [-f ctldev] pin [0|1]

DESCRIPTION

     The gpioctl utility could be used to manage GPIO pins from userland and list available pins.

     The options are as follows:

     -c pin flag [flag ...]
		Configure pin by setting provided flags. The following flags are currently defined:

		      IN     Input pin

		      OUT    Output pin

		      OD     Open drain pin

		      PP     Push pull pin

		      TS     Tristate pin

		      PU     Pull-up pin

		      PD     Pull-down pin

		      II     Inverted input pin

		      IO     Inverted output pin

     -f ctldev	GPIO controller device to use If not specified, defaults to /dev/gpioc0

     -l 	list available pins

     -t pin	toggle value of provided pin number

     -v 	be verbose: for each listed pin print current configuration

EXAMPLES

     o	 List pins available on GPIO controller defined by device /dev/gpioc0

	 gpioctl -f /dev/gpioc0 -l

     o	 Set the value of pin 12 to 1

	 gpioctl -f /dev/gpioc0 12 1

     o	 Configure pin 12 to be input pin

	 gpioctl -f /dev/gpioc0 -c 12 IN

SEE ALSO

     gpio(4), gpioiic(4), gpioled(4)

HISTORY

     The gpioctl utility appeared in FreeBSD 9.0.

AUTHORS

     The gpioctl utility and this manual page were written by Oleksandr Tymoshenko <gonzo@freebsd.org>.

BSD
								 November 7, 2013							       BSD

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace spaces with 0's having numeric values.

Discussion started by: videsh77

2. UNIX for Dummies Questions & Answers

How do I insert commas/delimiters in File

Discussion started by: mbelen

3. Shell Programming and Scripting

difference between double inverted coma and single inverted comma

Discussion started by: abhisekh_ban

4. Programming

numeric values ending in 'U'

Discussion started by: sneakyimp