02-28-2006
Does this file have set columns? If so you could use awk to extract the last field in the file. If so, then you can use awk like this, if not, I'll defer until more info is provided:
cat file | awk '{print $5}' where $5 is the fifth column in the file.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
how to i remove leading and trailing spaces from a line? the spaces can be behind or in front of any field or line
example of a line in the input data:
Amy Reds , 100 , /bin/sh
how to i get it to be: Amy Read,100,/bin/sh
i saw something on this on the Man pages for AWK... (7 Replies)
Discussion started by: sleepster
7 Replies
2. Shell Programming and Scripting
I am trying to strip all leading and trailing spaces of a shell variable using either awk or sed or any other utility, however unscuccessful and need your help.
echo $SH_VAR | command_line Syntax.
The SH_VAR contains embedded spaces which needs to be preserved. I need only for the leading and... (6 Replies)
Discussion started by: jerardfjay
6 Replies
3. Shell Programming and Scripting
Hi friends
I need some help,
I have a file which looks as follows
TEMP 014637065 014637065 517502 517502 RTE
517502 517502 RTE
AWATER_TEST 12325 23563 588323 2323 5656 32385 23235635
ANOTHER_TEST 12 5433 FTHH 5653 833
TEST 123 123 3235 5353 353 53 35 353 535 3
YTERS GJK JKLS
... (6 Replies)
Discussion started by: lijojoseph
6 Replies
4. Shell Programming and Scripting
Hi ,
i have to strip the spaces in the string which has the following value
ABC DEF
i want this to appear like this
ABC DEF
is there any spilt method?
please help....
Thanks (3 Replies)
Discussion started by: rag84dec
3 Replies
5. Shell Programming and Scripting
#!/bin/bash
TESTVAR=" 5spaces"
echo $TESTVAR
hostame:~# ./test.sh
5spaces
The leading spaces from my variable are removed when the content is echo'd. I am trying to make some tabular data.
`echo -e` also fails.
Any suggestions? (2 Replies)
Discussion started by: grumm3t
2 Replies
6. Shell Programming and Scripting
hello everyone. I'm hoping someone can help me out here. I have 2 files. It looks like this:
File 1:
abc1, defg, 50.00, mno,990
abc2, cats, 100.00, pops,991
abc3, dogs, 1.00, treat,992
File 2:
990, airplanes, runway, doctor
991, jets, birds, much
990,... (13 Replies)
Discussion started by: crazyhpux
13 Replies
7. Shell Programming and Scripting
Hi Experts,
In a file tht i copied from the web , i am not able to remove the leading white spaces. I tried the below , none of them working . I opened the file through vi to check for the special characters if any , but no such characters found.
Your advice will be greatly appreciated.
sed... (5 Replies)
Discussion started by: panyam
5 Replies
8. Shell Programming and Scripting
Hi,
I am having problem in deleting the leading spaces:-
cat x.csv
baseball,NULL,8798765,Most played
baseball,NULL,8928192,Most played
baseball,NULL,5678945,Most played
cricket,NOTNULL,125782,Usually played
cricket,NOTNULL,678921,Usually played
$ nawk 'BEGIN{FS=","}!a... (2 Replies)
Discussion started by: scripter12
2 Replies
9. Shell Programming and Scripting
data.txt
{
"auth_type": "role",
"default_attributes": {
"sudoers": {
i need to know how manyspaces are before an actual character in each line of a file.
for example. in the above data.txt,
There are 0 spaces leading up to {
There are 4 spaces leading up to the... (7 Replies)
Discussion started by: SkySmart
7 Replies
10. Shell Programming and Scripting
OS : RHEL 6.7
Shell : bash
I am trying to remove the leading the spaces in the below file
$ cat pattern2.txt
hello1
hello2
hello3
hello4
Expected output is shown below.
$ cat pattern2.txt
hello1
hello2
hello3
hello4 (2 Replies)
Discussion started by: John K
2 Replies
COLRM(1) BSD General Commands Manual COLRM(1)
NAME
colrm -- remove columns from a file
SYNOPSIS
colrm [start [stop]]
DESCRIPTION
The colrm utility removes selected columns from the lines of a file. A column is defined as a single character in a line. Input is read
from the standard input. Output is written to the standard output.
If only the start column is specified, columns numbered less than the start column will be written. If both start and stop columns are spec-
ified, columns numbered less than the start column or greater than the stop column will be written. Column numbering starts with one, not
zero.
Tab characters increment the column count to the next multiple of eight. Backspace characters decrement the column count by one.
ENVIRONMENT
The LANG, LC_ALL and LC_CTYPE environment variables affect the execution of colrm as described in environ(7).
EXIT STATUS
The colrm utility exits 0 on success, and >0 if an error occurs.
SEE ALSO
awk(1), column(1), cut(1), paste(1)
HISTORY
The colrm command appeared in 3.0BSD.
BSD
August 4, 2004 BSD