Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: command to remove multiple commands in particular columns
Top Forums Shell Programming and Scripting command to remove multiple commands in particular columns Post 302531665 by bshivali on Friday 17th of June 2011 12:02:47 PM
Old 06-17-2011
Quote:
Originally Posted by yazu
Code:
% cat testfile                                                
first,"Street1,City1,Country1",test1
second,"Street2,City2","test2"
third,"Street3,City3,Country3","A,B,C,D,E"
fourth,"A,B,C,D,E",test4"
 
% cat testfile | perl -lpe 's/("[^"]+")/($temp=$1) =~ s|,||g && $temp/e'
first,"Street1City1Country1",test1
second,"Street2City2","test2"
third,"Street3City3Country3","A,B,C,D,E"
fourth,"ABCDE",test4"

Hi Yazu,
Many Thanks!!!
I have a question what will be the code if i want to implement for 1, 2 and 3 columns

Appreciate it !!!

---------- Post updated at 11:02 AM ---------- Previous update was at 10:56 AM ----------

Quote:
Originally Posted by Tytalus
Code:
#  nawk -F"\"" '{OFS=FS;gsub(",","",$2);print}' infile
first,"Street1City1Country1",test1
second,"Street2City2","test2"
third,"Street3City3Country3","A,B,C,D,E"
fourth,"ABCDE",test4"

HTH
Hi Tytalus,

Many thanks for valuable input

what will be the code if i want to implement on 1, 2 and 3 column
Actually our requirement is file which has 52 columns an there we are getting 4 columns as these kind of values and we are validating only for these four

Thanks for your help once again

Apppreciate It

Babu
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Command to run multiple commands from a file.

I need a command, which could run mutliple commands from a file. Let's say, I have mv fileA1 fileB1 mv fileA2 fileB2 ..... mv fileA20 fileB20 I put these commands in a file, then I need a command to run the file as a whole so that I don't need to type 20 times... Anyone tell me how to... (8 Replies)
Discussion started by: kaixinsjtu
8 Replies

2. Shell Programming and Scripting

Single command for add 2 columns and remove 2 columns in unix/performance tuning

Hi all, I have created a script which adding two columns and removing two columns for all files. Filename: Cust_information_1200_201010.txt Source Data: "1","Cust information","123","106001","street","1-203 high street" "1","Cust information","124","105001","street","1-203 high street" ... (0 Replies)
Discussion started by: onesuri
0 Replies

3. Shell Programming and Scripting

awk command to print multiple columns

Hello Team, I have written following command which is giving output is as shown below. bash-3.00$ grep -i startup catalina.out | tail +2 | sed -n 1p | awk -F" " '{ for (x=1; x<=5; x++) { printf"%s\n", $x } }' Dec 19, 2010 3:28:39 PM bash-3.00$ I would like to modify above command to... (2 Replies)
Discussion started by: coolguyamy
2 Replies

4. Shell Programming and Scripting

sed remove multiple set of lines in one command

is there a way with sed to removed more than one set of lines in one line? so i mean sed ${firstElem},${lastIndex}d web.xml > web1.xml this will delete lines between ${firstElem},${lastIndex} i want in the same line to do somethinkg like this (doesn't work so far) sed... (3 Replies)
Discussion started by: Poki
3 Replies

5. UNIX for Dummies Questions & Answers

Using sed command to remove multiple instances of repeating headers in one file?

Hi, I have catenated multiple output files (from a monte carlo run) into one big output file. Each individual file has it's own two line header. So when I catenate, there are multiple two line headers (of the same wording) within the big file. How do I use the sed command to search for the... (1 Reply)
Discussion started by: rebazon
1 Replies

6. Shell Programming and Scripting

perform 3 awk commands to multiple files in multiple directories

Hi, I have a directory /home/datasets/ which contains a bunch (720) of subdirectories called hour_1/ hour_2/ etc..etc.. in each of these there is a single text file called (hour_1.txt in hour_1/ , hour_2.txt for hour_2/ etc..etc..) and i would like to do some text processing in them. Each of... (20 Replies)
Discussion started by: amarn
20 Replies

7. Shell Programming and Scripting

Remove Duplicate by considering multiple columns

hi friends, my input chr1 exon 35204 35266 gene_id "GOLGB1"; transcript_id "GOLGB1"; chr1 exon 42357 42473 gene_id "GOLGB1"; transcript_id "GOLGB1"; chr1 exon 45261 45404 gene_id "GOLGB1"; transcript_id "GOLGB1"; chr1 exon 50701 50778 gene_id "GOLGB1"; transcript_id "GOLGB1";... (2 Replies)
Discussion started by: jacobs.smith
2 Replies

8. Shell Programming and Scripting

Remove Duplicates on multiple Key Columns and get the Latest Record from Date/Time Column

Hi Experts , we have a CDC file where we need to get the latest record of the Key columns Key Columns will be CDC_FLAG and SRC_PMTN_I and fetch the latest record from the CDC_PRCS_TS Can we do it with a single awk command. Please help.... (3 Replies)
Discussion started by: vijaykodukula
3 Replies

9. Shell Programming and Scripting

Issue with running multiple commands withing su command

RHEL 6.2/Bash shell root user will be executing the below script. It switches to oracle user and expect to do the following things A. Source the environment variables for BATGPRD Database (the file used for sourcing is shown below after the script) B. Shutdown the DB from sqlplus -- The... (13 Replies)
Discussion started by: omega3
13 Replies

10. UNIX for Advanced & Expert Users

Pass Multiple Commands and Open Multiple Xterms via PSS

Hello, I'm attempting to open multiple xterms and run a command as an SAP user via sudo using PSSH. So far, I'm able to run PSSH to a file of servers with no check for keys, open every xterm in to the servers in the file list, and SUDO to the SAP(ADM) user, but it won't do anything else... (11 Replies)
Discussion started by: icemanj
11 Replies

LEARN ABOUT CENTOS

cgexec

CGEXEC(1)							 libcgroup Manual							 CGEXEC(1)

NAME

       cgexec - run the task in given control groups

SYNOPSIS

       cgexec [-h] [-g <controllers>:<path>] [--sticky] command [arguments]

DESCRIPTION

       The cgexec program executes the task command with arguments arguments in the given control groups.

       -g <controllers>:<path>
	      defines  the  control  groups  in which the task will be run.  controllers is a list of controllers and path is the relative path to
	      control groups in the given controllers list.

	      This flag can be used multiple times to define multiple pairs of lists of controllers and relative paths.  Instead of  the  list	of
	      all mounted controllers, the wildcard b"*b" can be used.

	      If this option is not used, cgexec will automatically place the task in the right cgroup based on /etc/cgrules.conf.

	      If  /etc/cgrules.conf  configuration file is used, there can be used template names. Then the control group name contains a template
	      in destination tag (see cgrules.conf (5)) and if the cgroup does not exist in execution time, it is created,  based  on  /etc/cgcon-
	      fig.conf specification.  If the specifications are not present the group is created with the default kernel values.

       -h, --help
	      Display this help and exit.

       --sticky
	      If running the task command with this option, the daemon of service cgred (cgrulesengd process) does not change both the task of the
	      command and the child tasks. Without this option, the daemon does not change the task of the command but it changes the child  tasks
	      to the right cgroup based on /etc/cgrules.conf automatically.

EXAMPLES

       cgexec -g *:test1 ls
       runs command ls in control group test1 in all mounted controllers.

       cgexec -g cpu,memory:test1 ls -l
       runs command ls -l in control group test1 in controllers cpu and memory.

       cgexec -g cpu,memory:test1 -g swap:test2 ls -l
       runs command ls -l in control group test1 in controllers cpu and memory and control group test2 in controller swap.

ENVIRONMENT VARIABLES

       CGROUP_LOGLEVEL
	      controls verbosity of the tool. Allowed values are DEBUG, INFO, WARNING or ERROR.

FILES

       /etc/cgrules.conf
	      default libcgroup configuration file

SEE ALSO

       cgrules.conf (5)

Linux								    2009-03-15								 CGEXEC(1)
All times are GMT -4. The time now is 02:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy