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 302470642 by bharathappriyan on Wednesday 10th of November 2010 05:11:09 PM
Old 11-10-2010
Replace the | with Comma
Hi,

The input file structure is given below: The Col1 and Col2 will be there always. But from Col3 there can be more columns.
And Col3 will be always Col4 and Col5 will always be with Col6. I need to replace the | with comma. There are scnearios where there
wont be no data.Below, the row 2 does not have data for col5,col6,col6,col8. I am using the command
Code:
cat Testin1|sed -e 's/||/,,,/g' -e 's/|/,/g'

How i use this command to achieve my requirement Or what is the best way to handle this?

Input:
Code:
Col1,Col2|Col3,Col4|Col5,Col6|Col7,Col8
Market1,"Chain1"|3,3|3,3|3,3|3,3
Market1,"Chain1"|3,3|||
Market1,"Chain1"||3,3||
Market1,"Chain1"|||3,3|
Market1,"Chain1"||||3,3

Expected Output:
Code:
Market1,"Chain1",3,3,3,3,3,3,3,3
Market1,"Chain1",3,3,,,,,,,
Market1,"Chain1",,,3,3,,,,,
Market1,"Chain1",,,,,3,3,,,
Market1,"Chain1",,,,,,,3,3

Current Output:
Code:
Market1,"Chain1",3,3,3,3,3,3,3,3
Market1,"Chain1",3,3,,,,
Market1,"Chain1",,,3,3,,,
Market1,"Chain1",,,,3,3,
Market1,"Chain1",,,,,,3,3

Thanks,
bharathappriyan
Last edited by Scott; 11-10-2010 at 06:18 PM.. Reason: Code tags, please...
 

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 DEBIAN

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 03:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy