I would like a favour from you guys to get the info from 5th column which was separated by the delimeter comma ( , )
The Data file is as below:-
The User File is as below:-
And my simple script is as below:-
The output will be:-
It's because of the commas in 3rd column which is "90, TEST AVENUE, OLD ROAD".
How can i get the correct output as below?
your help is much appreciated.
thanks
Last edited by Franklin52; 05-12-2011 at 04:53 AM..
Reason: Please use code tags
Hi,
Newbie here. I have a file that consists of data that I want to convert to a csv file. For example:
Jul 20 2008 1111 / visit home / BlackBerry8830/4.2.2 Profile/MIDP-2.0 Configuration/CLOC-1.1 VendorID/105
Jul 21 2008 22222 / add friend / BlackBerry8830/4.2.2 Profile/MIDP-2.0... (3 Replies)
Hi,
can anyone explain me below codes...i used the below one to use two delimeter(://) at a time..
but i am not able to understand the output options..
note: here there is no requirement ..only to understand myself about below command...
command:
awk -F "" '{print $1}' inputfile
... (2 Replies)
Hi,
i need to pick up dates and times from the file names which are of unequal length. The dates and time are delimited by dot. I am interested in getting the strings between the delimeter for fields -3, -4, -5 from behind (rear) so that the out put looks like :
071118.011300.556
I have... (2 Replies)
Hi All,
I want to execute this
cat /etc/passwd | awk -F: '{print $1,$7}'
with a fixed column on the first and second. Say on the first I want 12 column and second with 20 column.
Example
root /usr/bin/ksh
lp /bin/false
Thanks for any comment you may add. (5 Replies)
Hi,
I have the below script to check the count of delimeters for a file (here is File : test.csv Delimeter is ",")
awk '{gsub(/"*"/,x);print gsub(/,/,x)}' test.csv
And it return the output for each line as:
2
2
cat test.csv:
abc,xyz
"abc,zxyz",1
I need help one the below things:
- IS... (8 Replies)
I want to get IP address only from the input using sed. i.e string between between "(" and ")" delimeters.
echo "serverA (11.22.333.444) is alive" | sed 's/<??>/<??>/'
I know how to do this using cut and awk's split features.
I also want to know how to do this using awk's... (3 Replies)
Hi all,
The have 92 columns with combination of "" and , two delimiters and i need to takes some 32 columns only in that. i used awk command to extract .but its not working good.
Example: "aaaa","10,00.00",work,5555,.............
Command i tried :
awk -F"" -v OFS=","... (7 Replies)
Hey guys,
I have the following text:
1,2,3,4,5,6,'NULL','when',NULL,1,2,0,'NULL'
1,2,3,4,5,6,'NULL','what','NULL',1,2,0,1
I need the same text with the word NULL without commas
u know something like this:
1,2,3,4,5,6,NULL,'when',NULL,1,2,0,NULL
1,2,3,4,5,6,NULL,'what','NULL',1,2,0,1
... (1 Reply)
Hi,
I have a requirement like this
Line 1
Line 2
Line 3 Manager
Line 4
Line 5
I have to print like this
Have you done your work on time because I have to forward the work forward.
Any Help is really Appriciated.... (1 Reply)
Hi Guys,
I want to replace last 9 "," delimeters with "|" in a file
Example :-
"ashu,pant",3,5,5,7,7,87,8,8,8
"ashu,pant"|3|5|5|7|7|87|8|8|8
Help would be really appreciated.
Thanks guys,
Please use CODE tags as required by forum rules! (7 Replies)
Discussion started by: himanshupant
7 Replies
LEARN ABOUT CENTOS
git-column
GIT-COLUMN(1) Git Manual GIT-COLUMN(1)NAME
git-column - Display data in columns
SYNOPSIS
git column [--command=<name>] [--[raw-]mode=<mode>] [--width=<width>]
[--indent=<string>] [--nl=<string>] [--padding=<n>]
DESCRIPTION
This command formats its input into multiple columns.
OPTIONS
--command=<name>
Look up layout mode using configuration variable column.<name> and column.ui.
--mode=<mode>
Specify layout mode. See configuration variable column.ui for option syntax.
--raw-mode=<n>
Same as --mode but take mode encoded as a number. This is mainly used by other commands that have already parsed layout mode.
--width=<width>
Specify the terminal width. By default git column will detect the terminal width, or fall back to 80 if it is unable to do so.
--indent=<string>
String to be printed at the beginning of each line.
--nl=<N>
String to be printed at the end of each line, including newline character.
--padding=<N>
The number of spaces between columns. One space by default.
AUTHOR
Written by Nguyen Thai Ngoc Duy <pclouds@gmail.com[1]>
GIT
Part of the git(1) suite
NOTES
1. pclouds@gmail.com
mailto:pclouds@gmail.com
Git 1.8.3.1 06/10/2014 GIT-COLUMN(1)