Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Cut columns with delimiter
Top Forums Shell Programming and Scripting Cut columns with delimiter Post 302534839 by divya bandipotu on Wednesday 29th of June 2011 01:13:37 AM
Old 06-29-2011
@krrishv

I have removed numbers and spaces from all the rows and tried like below...
Code:
cat checkit.sh
Identifier,Username,First_Name,Middle,Last_Name,Employee_ID,City,RS Code,Postal,Email_addr,HomePhone,WorkPhone,Internal,Ethnic_Question,Ethnic_Questio
n,USA_EEO2_Ethnicity_Answer,USA_EEO2_Race_Question,USA_EEO2_Race_Question,USA_EEO2_Race_Answer,Gende r_Question,Gender_Question,Gender,SSOID^M
"67042","67042","A","","Jones","67042","Georgetown","US","78628","AJ_Jones@amat.com","+1 512-863-2043","+1 512-272-3247","TRUE","-1","-1","-3","-2","-2","-9","-3","-3","-11","67042"^M
"113021","113021","Aan Wooi","","Mu","113021","Tampines","MY","520852","Aan_Wooi_Mu@amat.com","","+65 98374227","TRUE","-1","-1","-1","-2","-2","-4","-3","-3","-11","113021"^M
"66872","66872","Aaron","","Hunter","66872","Santa Cruz","US","95060","Aaron_Hunter@amat.com","+1 408-458-0959","+1 408-584-0592","TRUE","-1","-1","-3","-2","-2","-9","-3","-3","-11","66872"^M
"70277","70277","Aaron","","Maciej","70277","Austin","US","78729","Aaron_Maciej@amat.com","+1 512-635-9991","+1 512-272-3617","TRUE","-1","-1","-3","-2","-2","-9","-3","-3","-11","70277"^M
"79145","79145","Aaron","","Wei","79145","Hsin Chu","TW","N/A","Aaron_Wei@amat.com","+886 35323094","+1 886-3-579-3464","TRUE","-1","-1","-1","-2","-2","-4","-3","-3","-11","79145"^M
"103260","103260","Aaron","","Liu","103260","Lingya District","TW","802","Aaron_Liu@amat.com","+886 88677615344","+1 886-4-22172610","TRUE","-1","-1","-1","-2","-2","-4","-3","-3","-11","103260"^M
"104267","104267","Aaron","","Himmler","104267","San Jose","US","95136","Aaron_Himmler@amat.com","+1 (703) 8955735","+1 408-584-0249","TRUE","-1","-1","-3","-2","-2","-9","-3","-3","-11","104267"^M

 
cat checkit.sh | awk -F "," '{print $7}' | tail -7
"Georgetown"
"Tampines"
"Santa Cruz"
"Austin"
"Hsin Chu"
"Lingya District"
"San Jose"



Can u check, whether it is usefull for u??

Thanx
Last edited by Franklin52; 06-29-2011 at 04:11 AM.. Reason: Please use code tags for code and data samples, thank you
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Dynamic delimiter in cut command

hello.. my prob is as follows: i have to read from a file which may have different formats depending upon the delimiter used in the data of the file.now i need that the user input the delimiter.the input delimiter is stored in a variable and is used on cut command to retrieve necessary... (3 Replies)
Discussion started by: tej.buch
3 Replies

2. Shell Programming and Scripting

\r as delimiter in cut

I need to use \r as a delimiter in the -d option of the cut comand . Any help ? Thanks in advance . SD (5 Replies)
Discussion started by: shweta_d
5 Replies

3. Shell Programming and Scripting

Cut Number which appear before a delimiter

Hi All, How can i use the cut option to only output the number of rows, which is 2 is this case ? Pls note that the number of digit before the delimiter ":" is always varying. $ grep -n uuu xxx 2:** xxx yyy gg 44 tt uuu 2007 $ (2 Replies)
Discussion started by: Raynon
2 Replies

4. UNIX for Dummies Questions & Answers

Problem Using Cut With A Space Delimiter

I am trying to extract 'postmaster' from the following string: PenaltyError:=554 5.7.1 Error, send your mail to postmaster@LOCALDOMAIN using the following command: cat /usr/share/assp/assp.cfg | grep ^PenaltyError:= | cut -d '@' -f1 | cut -f8 but it returns: PenaltyError:=554 5.7.1 Error,... (10 Replies)
Discussion started by: cleanden
10 Replies

5. UNIX for Advanced & Expert Users

use a word as a delimiter with cut

Is there a way to use a word as a delimiter with cut? Or is there a way to use sed or awk with a word as a delimiter? I don't care which program I use for a delimiter I just want to use a word as a delimiter. (2 Replies)
Discussion started by: cokedude
2 Replies

6. Shell Programming and Scripting

cut -d with more than 1 delimiter?

I need to cut or otherwise get the 4th and 5th position output of for i in `date +%H` ; do vnstat --dumpdb | grep "h;$i" ; done example output is: h;13;1310318701;443;93 I only need ";443;93" from any given run of "for i in `date +%H` ; do vnstat --dumpdb | grep "h;$i" ; done" Thanks... (3 Replies)
Discussion started by: Habitual
3 Replies

7. Shell Programming and Scripting

how to cut all string after the last delimiter?

hi all, suppose a string: abc/def/ghi/jkl/mn.txt and i want to get the file name without the path. however, different files have different paths, therefore the number of delimiter is uncertain. thanks so much! (3 Replies)
Discussion started by: sunnydanniel
3 Replies

8. Shell Programming and Scripting

How to cut by delimiter, and delimiter can be anything except numbers?

Hi all, I have a number of strings like below: //mnt/autocor/43°13'(33")W/ and i'm trying to get the numbers in this string, for example 431333 please help thanks ahead (14 Replies)
Discussion started by: sunnydanniel
14 Replies

9. Shell Programming and Scripting

cut delimiter and save

i have list of names in a text file and I wanted to delete the commas en every line. for example: inside the text is a list of names in it with commas after each line. I wanted to delete these commas. which command must I execute for this? unix, dale, shawn, aaron, (4 Replies)
Discussion started by: garfish
4 Replies

10. Shell Programming and Scripting

Cut cmd with delimiter as |#|

Hi All- We have a file data as below with delimiter as |#| 10|#|20|#|ABC 13|#|23|#|PBC If I want to cut the 2nd field out of this, below command is not working as multiple pipe is causing an issue , it seems cut -f2 -d"|#|" <file_name> can you please help to provide the correct command... (7 Replies)
Discussion started by: sureshg_sampat
7 Replies

LEARN ABOUT DEBIAN

email-reminder-editor

EMAIL-REMINDER-EDITOR(1)				User Contributed Perl Documentation				  EMAIL-REMINDER-EDITOR(1)

NAME

       Email-Reminder-Editor - edit special occasion reminders

SYNOPSIS

       Simple editor for modifying special occasion email reminders.

DESCRIPTION

       Email-reminder allows users to define events that they want to be reminded of by email.	Possible events include birthdays, anniversaries
       and yearly events.  Reminders can be sent on the day of the event and a few days beforehand.

       This is a simple editor that allows users to add/modify their reminders.  It saves changes automatically when the program is closed.

OPTIONS

       --help
	     Displays basic usage message.

       --simulate
	     Does not actually save any changes.

       --verbose
	     Prints out information about what the program is doing.

       --version
	     Displays the version number.

FILES

       ~/.email-reminders

AUTHOR

       Francois Marier <francois@email-reminder.org.nz>

SEE ALSO

       collect-reminders, send-reminders

COPYRIGHT

       Copyright (C) 2004-2010 by Francois Marier

       Email-Reminder is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
       the Free Software Foundation; either version 3 of the License, or (at your option) any later version.

       Email-Reminder is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with Email-Reminder; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.

perl v5.14.2							    2012-05-28						  EMAIL-REMINDER-EDITOR(1)
All times are GMT -4. The time now is 03:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy