03-13-2008
What I understand from the problem given below is that you are confused over using delimiters in the string.
If the string is same as what you have given , then "," can be used as a delimiter and the value can be stored in a variable as well.
Example below:
id=`cat a.txt | cut -d "," -f 1`
If "," is not something you intend to use as a delimiter, you can use space as a delimiter.Example given below:
id=`cat a.txt | tr -s " " | cut -d " " -f 1`
Hope this helps!
Thanks!
nua7
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
i have a file of the below format:
WA| 3|52|Waste |
PW| 3|53|Promotion Waste |
BR| 3|54|Breakage |
TH| 3|55|Theft |
IC| 3|56|Insurance Claim |
I want to replace the last delimiter | by using sed command ...can u please help me witht this
Thanks in... (4 Replies)
Discussion started by: jisha
4 Replies
2. UNIX for Dummies Questions & Answers
I am having the following file. I need to insert a delimiter in this file. I used sed but its not working.
AAABBB 9 JJJ
AAABBC 9 TTTTT
AAABBA 8 JJJ
AAABBC 7 TTTTT
AAABBC 6 TTTTT
Now i want the output file as:
AAA|BBB| |9| |JJJ|
AAA|BBC| |9| | |TTTTT| (3 Replies)
Discussion started by: sivakumar.rj
3 Replies
3. Shell Programming and Scripting
Hi,
I have a string like ABC.123.XYZ-A1-B2-P1-C4. I want to delimit the string based on "-" and then get result as only two strings. One with string till last hyphen and other with value after last hyphen... For this case, it would be something like first string as "ABC.123.XYZ-A1-B2-P1" and... (6 Replies)
Discussion started by: gupt_ash
6 Replies
4. Shell Programming and Scripting
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
5. UNIX for Dummies Questions & Answers
I have file with unconstatnt delimiter for each field which are non-printable characters like tab and space
file
6271 manchester (tab) 11/09/09 200 accepted
6272 manchester (tab) 11/09/09 200 accepted
I want only first... (7 Replies)
Discussion started by: tsurendra
7 Replies
6. Shell Programming and Scripting
Hi,
I am trying to load data from a file to oracle DB. The file am using has a ";" as a delimiter. While I load the file, I want to check whether the file is having the correct delimiter or not. if not, the file should not be processed. Is there any way that i could handle this scenario using... (3 Replies)
Discussion started by: smileyreddy
3 Replies
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
hi all,
i have a string with a number of "/"s as delimiter.
and i want everything BEFORE the last delimiter
i know to use basename to get everything after the last delimiter.
thx a lot! (2 Replies)
Discussion started by: sunnydanniel
2 Replies
9. Shell Programming and Scripting
Hi,
I have a No Delimiter variable length text file with following schema -
Column Name Data length
Firstname 5
Lastname 5
age 3
phoneno1 10
phoneno2 10
phoneno3 10
sample data - ... (16 Replies)
Discussion started by: Gaurav Martha
16 Replies
10. Shell Programming and Scripting
Hi,
Extremely new to Perl scripting, but need a quick fix without using TEXT::CSV
I need to read in a file, pass any delimiter as an argument, and convert it to bar delimited on the output. In addition, enclose fields within double quotes in case of any embedded delimiters.
Any help would... (2 Replies)
Discussion started by: JPB1977
2 Replies
CUT(1) User Commands CUT(1)
NAME
cut - remove sections from each line of files
SYNOPSIS
cut OPTION... [FILE]...
DESCRIPTION
Print selected parts of lines from each FILE to standard output.
With no FILE, or when FILE is -, read standard input.
Mandatory arguments to long options are mandatory for short options too.
-b, --bytes=LIST
select only these bytes
-c, --characters=LIST
select only these characters
-d, --delimiter=DELIM
use DELIM instead of TAB for field delimiter
-f, --fields=LIST
select only these fields; also print any line that contains no delimiter character, unless the -s option is specified
-n (ignored)
--complement
complement the set of selected bytes, characters or fields
-s, --only-delimited
do not print lines not containing delimiters
--output-delimiter=STRING
use STRING as the output delimiter the default is to use the input delimiter
-z, --zero-terminated
line delimiter is NUL, not newline
--help display this help and exit
--version
output version information and exit
Use one, and only one of -b, -c or -f. Each LIST is made up of one range, or many ranges separated by commas. Selected input is written
in the same order that it is read, and is written exactly once. Each range is one of:
N N'th byte, character or field, counted from 1
N- from N'th byte, character or field, to end of line
N-M from N'th to M'th (included) byte, character or field
-M from first to M'th (included) byte, character or field
AUTHOR
Written by David M. Ihnat, David MacKenzie, and Jim Meyering.
REPORTING BUGS
GNU coreutils online help: <http://www.gnu.org/software/coreutils/>
Report cut translation bugs to <http://translationproject.org/team/>
COPYRIGHT
Copyright (C) 2017 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
Full documentation at: <http://www.gnu.org/software/coreutils/cut>
or available locally via: info '(coreutils) cut invocation'
GNU coreutils 8.28 January 2018 CUT(1)