Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replace the | with Comma
Top Forums Shell Programming and Scripting Replace the | with Comma Post 302470651 by anbu23 on Wednesday 10th of November 2010 05:35:32 PM
Old 11-10-2010
-F"|" Input field delimiter is pipe

OFS="," Output field delimiter is comma

if($2==""){$2=","} Using pipe as delimiter, if second field is empty then assign comma to it

$1=$1"" This helps to set output field separator to comma if none of fields are blank

1 Means true. So the entire line is printed
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace , (comma) with space

Hi, what is the better way to replace the , (comma) with a space char? Example:STRING=dir1,dir2,dir3 toSTRING=dir1 dir2 dir3 And.. how to find if in the string there is a comma? Thanks :) (6 Replies)
Discussion started by: mbarberis
6 Replies

2. Shell Programming and Scripting

replace comma(,) with Tab

hi all, i have a file with commas(,). i want to replace all the commas with tab(\t). Plz help...its urgent... (3 Replies)
Discussion started by: vikas_kesarwani
3 Replies

3. Shell Programming and Scripting

Replace comma with newline

Hi, for some reason I cant seem to figure this out. I have a file which looks something like this word word word word word,word,word word word word,word,word,word,word word word Basically I want this whole thing to be a list with 1 word on each line like this... word word word... (1 Reply)
Discussion started by: eltinator
1 Replies

4. Shell Programming and Scripting

replace space with comma in perl

arr_Ent_NameId variable holds 'Prakash pawar' 'sag' '23' '50000' this value 'Prakash pawar' 'sag' '23' '50000' I want to replace space( ) with comma (,) There are 4 fields here. I don't want to replace first field with comma. output should be: 'Prakash,pawar','sag','23','50000' ... (2 Replies)
Discussion started by: pritish.sas
2 Replies

5. Shell Programming and Scripting

Replace newline with comma.

I have output from a file like this: 15,01,11,14:06 235 I would like to change this to: 15,01,11,14:06,235 Removing newline and change to "," I now this can be done with tr cat OUT | tr '\n' ','' My problem is that tr is not implemented in this shell. sed is, show it should be... (7 Replies)
Discussion started by: Jotne
7 Replies

6. Shell Programming and Scripting

Replace pipe <|> with comma <,> in a column

Hi All Gurus, I need to replace a pipe <|> with a comma <,> in a few columns with pipe delimited file. The column name are fixed for the replacement of comma <,>. For below example, Col3, Col6 and Col8 are columns need to replace with comma <,> if any pipe encountered. example:... (14 Replies)
Discussion started by: agathaeleanor
14 Replies

7. UNIX for Dummies Questions & Answers

How to replace two or more spaces with one comma?

I'm using sh on hp-ux. I've got a file that looks like this. -5.65 175 -16.17 160 -13.57 270 -51.72 260 -8.30 360 -42.71 460 -.38 375 -.20 375 -4.15 170 -21.53 560 -18.84 360 I'd like to replace all the whitespace between the columns with one comma. I can't... (4 Replies)
Discussion started by: Scottie1954
4 Replies

8. Shell Programming and Scripting

Command to replace newline with comma

Hi Experts, I need an urgent help in replacing newline characters in my single column file by a comma. I am using following command for this purpose: sed -n -e 'H;${x;s/\n/,/g;s/^,//;p;}' parameter.rtf | rev | cut -c 4- | revMy input file has: TABLE_1 TABLE_2 TABLE_3 What I need:... (11 Replies)
Discussion started by: neerndg123
11 Replies

9. Shell Programming and Scripting

Replace comma and blank with comma and number

I, I have a file and i need to replace comma and blank space with comma and 0. cat file.txt a,5 b,1 c, d, e,4 I need the output as cat file.txt a,5 b,1 c,0 d,0 (4 Replies)
Discussion started by: jaituteja
4 Replies

10. Shell Programming and Scripting

Replace spaces with underscores up to first comma but not after the comma

I have a comma delimited file of major codes and descriptions. I want to replace all occurrences of spaces with underscores up to the first comma (only in the first field), but not replace spaces following the comma. For instance I have the following snippet of the file: EK ED,Elementary and... (7 Replies)
Discussion started by: tdouty
7 Replies

LEARN ABOUT OPENSOLARIS

vgs

VGS(8)                                                        System Manager's Manual                                                       VGS(8)

NAME

       vgs - report information about volume groups

SYNOPSIS

       vgs  [-a|--all] [--aligned] [-d|--debug] [-h|-?|--help] [--ignorelockingfailure] [--nameprefixes] [--noheadings] [--nosuffix] [-o|--options
       [+]Field[,Field]] [-O|--sort [+|-]Key1[,[+|-]Key2[,...]]]  [-P|--partial] [--rows] [--separator Separator]  [--unbuffered]  [--units  hHbB-
       sSkKmMgGtTpPeE] [--unquoted] [-v|--verbose] [--version] [VolumeGroupName [VolumeGroupName...]]

DESCRIPTION

       vgs produces formatted output about volume groups.

OPTIONS

       See lvm for common options.

       --all  List all volume groups.  Equivalent to not specifying any volume groups.

       --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.

              Use -o vg_all to select all volume group columns.

              Use -o help to view the full list of columns available.

              Column names include: 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, vg_mda_used_count.

              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.

              The vg_attr bits are:

              1  Permissions: (w)riteable, (r)ead-only

              2  Resi(z)eable

              3  E(x)ported

              4  (p)artial: one or more physical volumes belonging to the volume group are missing from the system

              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 hHbBsSkKmMgGtTpPeE
              All  sizes  are  output  in  these  units: (h)uman-readable, (b)ytes, (s)ectors, (k)ilobytes, (m)egabytes, (g)igabytes, (t)erabytes,
              (p)etabytes, (e)xabytes.  Capitalise to use multiples of 1000 (S.I.) instead of 1024.  Can also specify custom units 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.95(2) (2012-03-06)                                                  VGS(8)
All times are GMT -4. The time now is 05:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy