Sponsored Content
Top Forums Shell Programming and Scripting manipulating csv to add extra row Post 302127090 by neil546 on Monday 16th of July 2007 07:11:56 AM
Old 07-16-2007
thanks all
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help Manipulating Large Csv File

Hello everyone, I am trying to manipulate a large .csv file where I have output similar to the following - http://imgur.com/TEXD8.png The result that I am looking for would be to consolidate the first column, but combine the second and third column so it still relates to the first. I... (8 Replies)
Discussion started by: xxwohxx
8 Replies

2. Shell Programming and Scripting

Manipulating csv file

We need to convert a field in a csv file which is in cents to dollars.(divide by 100) in our shell script. Can some body help me? (3 Replies)
Discussion started by: Deepthz
3 Replies

3. Shell Programming and Scripting

shell script to remove extra commas from CSV outp file

Name,,,,,,,,,,,,,,,,,,,,Domain,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Contact,Phone,Email,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Location -----------------------,------------------------------------------------,-------,-----,---------------------------------,------------------------------------ ----... (1 Reply)
Discussion started by: sreenath1037
1 Replies

4. Shell Programming and Scripting

Ascii Mode appending extra records to csv file

I am relatively new to this forum and Unix scripting. ksh script: part 1 :will call a PL\SQL program will create 3 CSV file at the unix directory. part 2 : will sftp the files to the EFT server. Once the EFT server receives these file , it will transfer them to a shared windows folders. ... (3 Replies)
Discussion started by: developerpa
3 Replies

5. Shell Programming and Scripting

Adding Extra Commas to a CSV file

Trying in this forum. Not sure if it is permitted.... but in need of help. Please find the requirements in the below link. https://www.unix.com/unix-dummies-questions-answers/191503-add-extra-commas-csv-file-2.html#post302665179 Thanks in Advance. (1 Reply)
Discussion started by: chillblue
1 Replies

6. UNIX for Dummies Questions & Answers

To Add extra commas to a CSV file using 2 files...

Hi , Based on my previous requirement the code works fine for comma as delimiter. Now my Req is widened up a bit .. There will be two set of files .. one with comma as delimiter and other with semi-colon ; as delimiter. Second Sample file. With Double Quotes (Semi-Colon... (1 Reply)
Discussion started by: chillblue
1 Replies

7. UNIX for Dummies Questions & Answers

To Add extra commas to a CSV file.

Hi All, I got this requirement to process a complex CSV file. Eg File. Line 1: Name:,XYz Line 2: Age:,15 Line 3: Grade:,7 Line 4: Line 5: English, Maths, Science,Spanish Line 6:10,11,13,14 As you can see the maximum column is 4 . The file i need to make is Line 1: Name:,XYz,,... (12 Replies)
Discussion started by: chillblue
12 Replies

8. Shell Programming and Scripting

Randomly inserting extra columns into csv file

Hi Tech Guru, I have a test file as below , which needs some more fields to be populated randomly : dks3243;12;20130823;1420;25m;0;syt dks3243;rocy;10 dks3243;kiop;18 sde21p4;77;20151210;8479;7py;9;vfr sde21p4;temp;67 sfq6i01;12;20120123;3412;4rd;7;jui sfq6i01;uymk;90 sfq6i01;kiop;51 ... (8 Replies)
Discussion started by: Lokesha
8 Replies

9. Shell Programming and Scripting

Have problem with extra EOLs in my CSV - need help cleaning out

Hi Everyone, Searching the forum, I came across another closed thread, that appears to be either the same problem, or very close to what I'm experiencing. Closed thread for reference is at: https://www.unix.com/shell-programming-and-scripting/241664-removing-cr-lf-till-number-fields-full.html ... (4 Replies)
Discussion started by: richardsantink
4 Replies

10. Shell Programming and Scripting

Need to Insert three extra columns in csv file

Hello Experts, I got a requirement i have a input file which am getting from different source,Now i want to add extra 3 columns to this file like BASE,ACTUAL and DATE. Input File Looks like QUAL CHGE TYP LAW COM1 COM2 A 1 X SED HO ASE B 3 Z CDE SE ... (5 Replies)
Discussion started by: ahmed.vaghar
5 Replies
virt-filesystems(1)					      Virtualization Support					       virt-filesystems(1)

NAME
virt-filesystems - List filesystems, partitions, block devices, LVM in a virtual machine or disk image SYNOPSIS
virt-filesystems [--options] -d domname virt-filesystems [--options] -a disk.img [-a disk.img ...] DESCRIPTION
This tool allows you to discover filesystems, partitions, logical volumes, and their sizes in a disk image or virtual machine. It is a replacement for virt-list-filesystems(1) and virt-list-partitions(1). One use for this tool is from shell scripts to iterate over all filesystems from a disk image: for fs in $(virt-filesystems -a disk.img); do # ... done Another use is to list partitions before using another tool to modify those partitions (such as virt-resize(1)). If you are curious about what an unknown disk image contains, use this tool along with virt-inspector(1). Various command line options control what this program displays. You need to give either -a or -d options to specify the disk image or libvirt guest respectively. If you just specify that then the program shows filesystems found, one per line, like this: $ virt-filesystems -a disk.img /dev/sda1 /dev/vg_guest/lv_root If you add -l or --long then the output includes extra information: $ virt-filesystems -a disk.img -l Name Type VFS Label Size /dev/sda1 filesystem ext4 boot 524288000 /dev/vg_guest/lv_root filesystem ext4 root 10212081664 If you add --extra then non-mountable (swap, unknown) filesystems are shown as well: $ virt-filesystems -a disk.img --extra /dev/sda1 /dev/vg_guest/lv_root /dev/vg_guest/lv_swap /dev/vg_guest/lv_data If you add --partitions then partitions are shown instead of filesystems: $ virt-filesystems -a disk.img --partitions /dev/sda1 /dev/sda2 Similarly you can use --logical-volumes, --volume-groups, --physical-volumes, --block-devices to list those items. You can use these options in combination as well (if you want a combination including filesystems, you have to add --filesystems). Notice that some items fall into several categories (eg. "/dev/sda1" might be both a partition and a filesystem). These items are listed several times. To get a list which includes absolutely everything that virt-filesystems knows about, use the --all option. UUIDs (because they are quite long) are not shown by default. Add the --uuid option to display device and filesystem UUIDs in the long output. --all --long --uuid is a useful combination to display all possible information about everything. $ virt-filesystems -a win.img --all --long --uuid -h Name Type VFS Label Size Parent UUID /dev/sda1 filesystem ntfs System Reserved 100M - F81C92571C92112C /dev/sda2 filesystem ntfs - 20G - F2E8996AE8992E3B /dev/sda1 partition - - 100M /dev/sda - /dev/sda2 partition - - 20G /dev/sda - /dev/sda device - - 20G - - For machine-readable output, use --csv to get Comma-Separated Values. OPTIONS
--help Display brief help. -a file --add file Add file which should be a disk image from a virtual machine. If the virtual machine has multiple block devices, you must supply all of them with separate -a options. The format of the disk image is auto-detected. To override this and force a particular format use the --format=.. option. --all Display everything. This is currently the same as specifying these options: --filesystems, --extra, --partitions, --block-devices, --logical-volumes, --volume-groups, --physical-volumes. (More may be added to this list in future). See also --long. --blkdevs --block-devices Display block devices. -c URI --connect URI If using libvirt, connect to the given URI. If omitted, then we connect to the default libvirt hypervisor. If you specify guest block devices directly (-a), then libvirt is not used at all. --csv Write out the results in CSV format (comma-separated values). This format can be imported easily into databases and spreadsheets, but read "NOTE ABOUT CSV FORMAT" below. -d guest --domain guest Add all the disks from the named libvirt guest. Domain UUIDs can be used instead of names. --echo-keys When prompting for keys and passphrases, virt-filesystems normally turns echoing off so you cannot see what you are typing. If you are not worried about Tempest attacks and there is no one else in the room you can specify this flag to see what you are typing. --extra This causes filesystems that are not ordinary, mountable filesystems to be displayed. This category includes swapspace, and filesystems that are empty or contain unknown data. This option implies --filesystems. --filesystems Display mountable filesystems. If no display option was selected then this option is implied. With --extra, non-mountable filesystems are shown too. --format=raw|qcow2|.. --format The default for the -a option is to auto-detect the format of the disk image. Using this forces the disk format for -a options which follow on the command line. Using --format with no argument switches back to auto-detection for subsequent -a options. For example: virt-filesystems --format=raw -a disk.img forces raw format (no auto-detection) for "disk.img". virt-filesystems --format=raw -a disk.img --format -a another.img forces raw format (no auto-detection) for "disk.img" and reverts to auto-detection for "another.img". If you have untrusted raw-format guest disk images, you should use this option to specify the disk format. This avoids a possible security problem with malicious guests (CVE-2010-3851). -h --human-readable In --long mode, display sizes in human-readable format. --keys-from-stdin Read key or passphrase parameters from stdin. The default is to try to read passphrases from the user by opening "/dev/tty". -l --long Display extra columns of data ("long format"). A title row is added unless you also specify --no-title. The extra columns displayed depend on what output you select, and the ordering of columns may change in future versions. Use the title row, --csv output and/or csvtool(1) to match columns to data in external programs. Use -h if you want sizes to be displayed in human-readable format. The default is to show raw numbers of bytes. Use --uuid to display UUIDs too. --lvs --logvols --logical-volumes Display LVM logical volumes. In this mode, these are displayed irrespective of whether the LVs contain filesystems. --no-title In --long mode, don't add a title row. Note that the order of the columns is not fixed, and may change in future versions of virt-filesystems, so using this option may give you unexpected surprises. --parts --partitions Display partitions. In this mode, these are displayed irrespective of whether the partitions contain filesystems. --pvs --physvols --physical-volumes Display LVM physical volumes. --uuid --uuids In --long mode, display UUIDs as well. -v --verbose Enable verbose messages for debugging. -V --version Display version number and exit. --vgs --volgroups --volume-groups Display LVM volume groups. -x Enable tracing of libguestfs API calls. COLUMNS
Note that columns in the output are subject to reordering and change in future versions of this tool. Name The filesystem, partition, block device or LVM name. For device and partition names these are displayed as canonical libguestfs names, so that for example "/dev/sda2" is the second partition on the first device. If the --long option is not specified, then only the name column is shown in the output. Type The object type, for example "filesystem", "lv", "device" etc. VFS If there is a filesystem, then this column displays the filesystem type if one could be detected, eg. "ext4". Label If the object has a label (used for identifying and mounting filesystems) then this column contains the label. MBR The partition type byte, displayed as a two digit hexadecimal number. A comprehensive list of partition types can be found here: http://www.win.tue.nl/~aeb/partitions/partition_types-1.html <http://www.win.tue.nl/~aeb/partitions/partition_types-1.html> This is only applicable for DOS (MBR) partitions. Size The size of the object in bytes. If the --human option is used then the size is displayed in a human-readable form. Parent The parent column records the parent relationship between objects. For example, if the object is a partition, then this column contains the name of the containing device. If the object is a logical volume, then this column is the name of the volume group. If there is more than one parent, then this column is (internal to the column) a comma-separated list, eg. "/dev/sda,/dev/sdb". UUID If the object has a UUID (used for identifying and mounting filesystems and block devices) then this column contains the UUID as a string. The UUID is only displayed if the --uuid option is given. NOTE ABOUT CSV FORMAT
Comma-separated values (CSV) is a deceptive format. It seems like it should be easy to parse, but it is definitely not easy to parse. Myth: Just split fields at commas. Reality: This does not work reliably. This example has two columns: "foo,bar",baz Myth: Read the file one line at a time. Reality: This does not work reliably. This example has one row: "foo bar",baz For shell scripts, use "csvtool" (<http://merjis.com/developers/csv> also packaged in major Linux distributions). For other languages, use a CSV processing library (eg. "Text::CSV" for Perl or Python's built-in csv library). Most spreadsheets and databases can import CSV directly. SHELL QUOTING
Libvirt guest names can contain arbitrary characters, some of which have meaning to the shell such as "#" and space. You may need to quote or escape these characters on the command line. See the shell manual page sh(1) for details. EXIT STATUS
This program returns 0 if successful, or non-zero if there was an error. SEE ALSO
guestfs(3), guestfish(1), virt-cat(1), virt-df(1), virt-list-filesystems(1), virt-list-partitions(1), csvtool(1), <http://libguestfs.org/>. AUTHOR
Richard W.M. Jones <http://people.redhat.com/~rjones/> COPYRIGHT
Copyright (C) 2010 Red Hat Inc. This program 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 2 of the License, or (at your option) any later version. This program 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 this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. libguestfs-1.18.1 2013-12-07 virt-filesystems(1)
All times are GMT -4. The time now is 08:09 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy