11-23-2017
(|) will never appear inside a quoted field. it is the delimiter, so acts like a separator between 2 columns
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have various column names within double quotes, separated by commas.
Example:
"column one", "column number two", "this is column number three", anothercolumn, yetanothercolumn
I need to eliminate the double quotes and replace the blanks within the double quotes by underscores, giving:
... (5 Replies)
Discussion started by: jgrogan
5 Replies
2. Shell Programming and Scripting
Hi,
I have a requirement to replace the comma's inside the double quotes. The comma's inside the double quotes will get changed dynamically.
Input Record:
"Washington, DC,Prabhu,aju",New York
Output Record:
"Washington| DC|Prabhu|aju",New York
I tried with the below command but it... (3 Replies)
Discussion started by: prabhutkl
3 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I am getting the data from text file and it contains comma and double quootes.
Eg: text file like this:
Travelling up Cattai Ridge Rd, going through the "S" bends at the top.
Felt a "pull" and pain in groin area, on right side after lifting at work.
Repeat "twisting" while working manual... (4 Replies)
Discussion started by: rajesh4851
4 Replies
4. Shell Programming and Scripting
Hi,
I have data as
"01/22/97-"aaaaaaaaaaaaaaaaa""aaa""aabbbbbbbbcccccc""zbcd""dddddddddeeeeeeeeefffffff"
I want to remove only the Consequitive double quotes and not the one which occurs single.
My O/P must be ... (2 Replies)
Discussion started by: Bhuvaneswari
2 Replies
5. Shell Programming and Scripting
In bash or perl, I would like to know how to substitute a null character (0x00) for every white space without changing the white spaces inside the block of double quotes and the white space immediately following a backslash.
Suppose that sample.txt consists of the following line.
"b 1" c\ 2
... (2 Replies)
Discussion started by: LessNux
2 Replies
6. Shell Programming and Scripting
Hello experts,
I need to validate a csv file which contains data like this:
Sample.csv
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
"ABCD","I",23,0,9,,"23/12/2012","OK","Street,State, 91135",0
I just need to check if all the records contain exactly the number of... (5 Replies)
Discussion started by: shell_boy23
5 Replies
7. Shell Programming and Scripting
Hi Froum.
I have tried in vain to find a solution for this problem - I'm trying to replace any double quotes within a quoted string with a single quote, leaving everything else as is.
I have the following data:
Before:
... (32 Replies)
Discussion started by: pchang
32 Replies
8. Shell Programming and Scripting
Hi All,
I have been trying to replace a string using the sed command
string value contain blackslash and double quotes. I am not a expert writer of unix script but do try not to ask question. I have almost given up. Hope you all can give me some suggestion
I want to replace a place string... (6 Replies)
Discussion started by: thanush9sep
6 Replies
9. Shell Programming and Scripting
Hi All,
I'm unable to load the data using sql loader where there are double quotes within the double quotes As these are optionally enclosed by double quotes.
Sample Data :
"221100",138.00,"D","0019/1477","44012075","49938","49938/15043000","Television - 22" Refurbished - Airwave","Supply... (6 Replies)
Discussion started by: mlavanya
6 Replies
10. Shell Programming and Scripting
Hi I have a .csv file and when opened in notepad looks like this
gggg,nnnn,"last,first","llll""",nnn
So, Here I would like the ouput as below
gggg,nnnn,"last,first","llll",nnn
i.e replace all two double quotes into one. How could I do that?
This file is being processed by another... (5 Replies)
Discussion started by: dnat
5 Replies
VGS(8) System Manager's Manual VGS(8)
NAME
vgs - report information about volume groups
SYNOPSIS
vgs [--aligned] [-d|--debug] [-h|-?|--help] [--ignorelockingfailure] [--nameprefixes] [--noheadings] [--nosuffix] [-o|--options
[+]Field[,Field]] [-O|--sort [+|-]Key1[,[+|-]Key2[,...]]] [-P|--partial] [--rows] [--separator Separator] [--unbuffered] [--units
hsbkmgtHKMGT] [--unquoted] [-v|--verbose] [--version] [VolumeGroupName [VolumeGroupName...]]
DESCRIPTION
vgs produces formatted output about volume groups.
OPTIONS
See lvm for common options.
--aligned
Use with --separator to align the output columns.
--nameprefixes
Add an "LVM2_" prefix plus the field name to the output. Useful with --noheadings to produce a list of field=value pairs that can
be used to set environment variables (for example, in udev (7) rules).
--noheadings
Suppress the headings line that is normally the first line of output. Useful if grepping the output.
--nosuffix
Suppress the suffix on output sizes. Use with --units (except h and H) if processing the output.
-o, --options
Comma-separated ordered list of columns. Precede the list with '+' to append to the default selection of columns. Column names
are: vg_fmt, vg_uuid, vg_name, vg_attr, vg_size, vg_free, vg_sysid, vg_extent_size, vg_extent_count, vg_free_count, max_lv, max_pv,
pv_count, lv_count, snap_count, vg_seqno, vg_tags, vg_mda_count, vg_mda_free, and vg_mda_size. Any "vg_" prefixes are optional.
Columns mentioned in either pvs (8) or lvs (8) can also be chosen, but columns cannot be taken from both at the same time. Use -o
help to view the full list of fields available.
The vg_attr bits are:
1 Permissions: (w)riteable, (r)ead-only
2 Resi(z)eable
3 E(x)ported
4 (p)artial
5 Allocation policy: (c)ontiguous, c(l)ing, (n)ormal, (a)nywhere, (i)nherited
6 (c)lustered
-O, --sort
Comma-separated ordered list of columns to sort by. Replaces the default selection. Precede any column with - for a reverse sort on
that column.
--rows Output columns as rows.
--separator Separator
String to use to separate each column. Useful if grepping the output.
--unbuffered
Produce output immediately without sorting or aligning the columns properly.
--units hsbkmgtHKMGT
All sizes are output in these units: (h)uman-readable, (s)ectors, (b)ytes, (k)ilobytes, (m)egabytes, (g)igabytes, (t)erabytes. Cap-
italise to use multiples of 1000 (S.I.) instead of 1024. Can also specify custom (u)nits e.g. --units 3M
--unquoted
When used with --nameprefixes, output values in the field=value pairs are not quoted.
SEE ALSO
lvm(8), vgdisplay(8), pvs(8), lvs(8)
Sistina Software UK LVM TOOLS 2.02.44-cvs (02-17-09) VGS(8)