Pick the column value based on another column from .csv file
My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated.
Main imp point, in my .csv file, third column is having price value with comma (1,20,300), it has to be considered 1,000 as single column.
Please someone help me to resolve this issue.
Source file format Target output
Last edited by Scott; 01-18-2013 at 05:54 AM..
Reason: Please use code tags
Hi all,
in my csv file it'll look like this, and of course it may have more columns
US to UK;abc-hq-jcl;multimedia
UK to CN;def-ny-jkl;standard
DE to DM;abc-ab-klm;critical
FD to YM;la-yr-tym;standard
HY to MC;la-yr-ytm;multimedia
GT to KJ;def-ny-jrt;critical
I would like to group... (4 Replies)
Hi All,
I am newbie to Unix I ve got assignment to work in unix
can you please help me in this regard
There is a sample CSV file
"Username", "Password"
"John1", "Scot1"
"John2", "Scot2"
"John3", "Scot3"
"John4", "Scot4"
If i give the column name as Password and row number as 4 the... (3 Replies)
My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated.
Please someone help me to resolve this issue.
Source
column1 column2 column3 column4... (2 Replies)
Source 1
column1 column2 column 3 column4
1,ganesh,1,000,1
222,ram,2,000,5
222,ram,50,000,5
33,raju,5,000,7
33,raju,5,000,7
33,raju,5,000,8
33,raju,5,000,4
33,raju,5,000,1
In my .csv file, third column is having price value with comma (20,300), it has to be considered 1,000 as... (1 Reply)
Hi all,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (3 Replies)
I have a .CSV file with the below format:
"column 1","column 2","column 3","column 4","column 5","column 6","column 7","column 8","column 9","column 10
"12310","42324564756","a simple string with a , comma","string with or, without commas","string 1","USD","12","70%","08/01/2013",""... (2 Replies)
input.csv:
Field1,Field2,Field3,Field4,Field4
abc ,123 ,xyz ,000 ,pqr
mno ,123 ,dfr ,111 ,bbb
output:
Field2,Field4
123 ,000
123 ,111
how to fetch the values of Field4 where Field2='123'
I don't want to fetch the values based on column position. Instead want to... (10 Replies)
cat sample.csv
ID,Name,no
1,AAA,1
2,BBB,1
3,AAA,1
4,BBB,1
cut -d',' -f2 sample.csv | sort | uniq
this gives only the 2nd column values
Name
AAA
BBB
How to I get all the columns of CSV along with this? (1 Reply)
Hello everyone,
I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this:
20170628-23:25:01,1,0,0,1,1,1,1,55,55,1
20170628-23:30:01,1,0,0,1,1,1,1,56,56,1
20170628-23:35:00,1,0,0,1,1,2,1,57,57,2
20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Hi,
I tried filtering the records in a csv file using "awk" command listed below.
awk -F"~" '$4 ~ /Active/{print }' inputfile > outputfile
The output always has all the entries.
The same command worked for different users from one of the forum links.
content of file I was... (3 Replies)
Discussion started by: sunilmudikonda
3 Replies
LEARN ABOUT DEBIAN
cfdisk
CFDISK(8) GNU cfdisk Manual CFDISK(8)NAME
GNU cfdisk - a curses-based partition table manipulation program
SYNOPSIS
cfdisk [options] [device]
DESCRIPTION
cfdisk is a disk partition manipulation program, which allows you to create, destroy, resize, move and copy partitions on a hard drive
using a simple menu-driven interface. It is useful for organising the disk space on a new drive, reorganising an old drive, creating space
for new operating systems, and copying data to new hard disks. For a list of the supported partition types, see the --list-partition-types
option below.
OPTIONS -h, --help
displays a help message.
-v, --version
displays the program's version.
-a, --arrow-cursor
use an arrow cursor, instead of reverse video highlighting, in case your terminal doesn't support it.
-z, --new-table
create a new partition table on the disk. This is useful if you want to change the partition table type or want to repartition you
entire drive. Note that this does not delete the old table on the disk until you commit the changes.
-u, --units=UNIT
sets the default display units to UNIT. A list of possible units is given below.
-t, --list-partition-types
displays a list of supported partition types and features.
UNITS
You can choose in what unit cfdisk should display quantities like partition sizes. You can choose from sectors, percents, bytes, kilobytes,
etc. Note that one kilobyte is equal to 1,000 bytes, as this is consistent with the SI prefixes and is used by hard disk manufacturers. If
you prefer to see the sizes in units with binary prefixes, you should instead select one kilo binary byte (kibibyte), which is equal to
1,024 bytes. Whatever display unit you have chosen, you can always enter the quantities in the unit of your choice, for example 1000000B or
1000kB.
compact
display each size in the most suitable unit from B, kB, MB, GB and TB.
B one byte
kB one kilobyte (1,000 bytes)
MB one megabyte (1,000,000 bytes)
GB one gigabyte (1,000,000,000 bytes)
TB one terabyte (1,000,000,000,000 bytes)
KiB one kilo binary byte (1,024 bytes)
MiB one mega binary byte (1,048,576 bytes)
GiB one giga binary byte (1,073,741,824 bytes)
TiB one tera binary byte (1,099,511,627,776 bytes)
s one sector. It depends on the sector size of the disk. You can use it if you want to see or choose the exact size in sectors.
% one percent from the size of the disk
cyl one cylinder. It depends on the cylinder size.
chs use CHS display units.
BUGS
There are no known bugs. We are in early stages for development, so be careful.
SEE ALSO fdisk(8), mkfs(8), parted(8) The cfdisk program is fully documented in the info(1) format GNU cfdisk User Manual manual.
fdisk 16 June, 2006 CFDISK(8)