Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replace blanks with | (pipe)
Top Forums Shell Programming and Scripting Replace blanks with | (pipe) Post 302459897 by Scrutinizer on Tuesday 5th of October 2010 02:44:01 PM
Old 10-05-2010
Code:
awk '{for(i=1;i<=NF;i++){s=(i<12)?"|":FS;if(i==NF)s=RS;printf $i s}}' file

Last edited by Scrutinizer; 10-05-2010 at 03:53 PM..
This User Gave Thanks to Scrutinizer For This Post:
bd_joy
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace a Pipe with tab

i have a file which contains text as shown below.... aaa|bbb|ccc|ddd| cccc|ddddd|eeeee|ffffff want to convert pipe symbol to tab like aaaa bbbb cccc ddddd ccccc ddddd eeeee ffffffffff i tried with sed sed 's/|/\t/g' file_name ...but i could not... (1 Reply)
Discussion started by: srikanthus2002
1 Replies

2. Shell Programming and Scripting

Replace multiple blanks within double quotes

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

3. Shell Programming and Scripting

Replace pipe with Broken Pipe

Hi All , Is there any way to replace the pipe ( | ) with the broken pipe (0xA6) in unix (1 Reply)
Discussion started by: saj
1 Replies

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

5. Shell Programming and Scripting

Replace trailing whitespaces with pipe symbol using perl

I want to replace the whitespace with Pipe symbol to do a multiple pattern matching for the whole text "mysqld failed start" and same as for other text messages Below are the messages stored in a file seperate by whitespace mysqld failed start nfsd mount failed rpcbind failed to start for... (6 Replies)
Discussion started by: kar_333
6 Replies

6. Programming

Psql replace blanks with character

Well as the title describes, its a pretty straight forward problem. I have a series of psql tables where there are lots of blanks. However there is at least one column, called name, that will never be blank. I want to write a select statement to get all of the contents of the table and then turn... (3 Replies)
Discussion started by: wxornot
3 Replies

7. Shell Programming and Scripting

Replace space and tab to pipe delimeter

I have file like below abc 12 34 45 code abcdef 451 1 4 code ghtyggg 4 56 3 code I need to change this to abc|12|34|45|code| abcdef|451|1|4|code| ghtyggg|4|56|3|code| I tried replace space with | in sed ... but in the middle some row has... (7 Replies)
Discussion started by: greenworld123
7 Replies

8. How to Post in the The UNIX and Linux Forums

How to replace value of password tag in xml with blanks when special characters are there?

Hi All, I am trying to replace the values inside <password> tag in an xml file but it doesn't replace certain passwords: For eg: Server/home/sperinc>cat TextXML.txt <appIds> <entry name="AccountXref"> <type id="ldap"> <realm>nam</realm> ... (7 Replies)
Discussion started by: saroopkris85
7 Replies

9. Shell Programming and Scripting

Replace CRLF between pipe (|) delimiter with LF

Hi Folks! Need a solution for the following :- Source data ------------- 123|123|<CRLF><CRLF><CRLF>|321<CRLF> Required output ------------------ 123|123|<LF><LF><LF>|321<CRLF> <CRLF> represents carriage return <LF> represents line feed Being hunting high and low for a... (10 Replies)
Discussion started by: hishamzz
10 Replies

10. Shell Programming and Scripting

How to replace the first and last character which is pipe symbol in all files within a folder?

with in my files i have the data like this, starting with a pipe and ending the line with a pipe. all i want is to replace the first and last pipe , remove those trying to use following sed command, but it is only showing on the screen the entire data of the file as if it removed, but when i... (4 Replies)
Discussion started by: cplusplus1
4 Replies

LEARN ABOUT DEBIAN

lltag_config

lltag_config(5) 						File Formats Manual						   lltag_config(5)

NAME

       config - Configuration file for lltag

DESCRIPTION

       The following options may be stored in /etc/lltag/config or the user's $HOME/.lltag/config, or in any file passed with --config.

       Such a configuration file may also be generated with --gencfg.

Obtaining tags
       format = "string"
	      Add  a user-defined format [-R].	Might be used multiple times.  Default is to guess if no user-defined formats and no default field
	      values are given.
       guess = <0/1>
	      Try to guess if user-defined formats do not match [-G].  Default is 0 (disabled) when no user-defined formats and no explicit values
	      are given.
       tag = <TAG=value>
	      Add an explicit tag [--tag].  Might be used multiple times.

Tweaking filename parsing
       no_path = <0/1>
	      Do not use file path when matching filename [-p].  Default is 0 (disabled).
       spaces = <0/1>
	      Allow no or multiple spaces [--spaces].  Default is 0 (disabled).

Cleaning obtained tags
       edit = <0/1>
	      Edit tags immediately [--edit].  Default is 0 (disabled).
       maj = <0/1>
	      Upcase first letters of words in tags [--maj].  Default is 0 (disabled).
       regexp = "s/from/to/"
	      Replace  from  with  to  in all tags.  title,number:s/from/to/ replaces in title and number tags only.  Might be used multiple times
	      [--regexp].  Default is to not apply any regexp.
       sep = "string"
	      Replace |-separated strings with space in tags.  Default is to not replace any separator.

Configuration of tag application
       type = <mp3|ogg|flac|none>
	      Force mp3, ogg of flac instead of by-extension detection [--mp3, --ogg and --flac].  Default is none.
       clear_tags = <0/1>
	      Clear all tags of audio files.  [--clear].  Default is 0 (disabled).
       append_tags = <0/1>
	      Append tags only instead of replacing old ones.  [--append].  Default is 0 (disabled).
       no_tagging = <0/1>
	      Do not actually tag files [--no-tagging].  Default is 0 (disabled).
       preserve_time = <0/1>
	      Preserve file modification time during tagging [--preserve-time].  Default is 0 (disabled).

Renaming
       rename_format = "string"
	      Rename file according to format [--rename].  Default is to not rename.
       rename_min = <0/1>
	      Lowcase tags before renaming [--rename-min].  Default is 0 (disabled).
       rename_regexp = "s/from/to/"
	      Replace from with to in all tags before renaming.  title,number:s/from/to/ replaces in title and number tags only.   Might  be  used
	      multiple times [--rename-regexp].  Default is to not apply any regexp.
       rename_sep = "string"
	      Replace spaces with a string in tags before renaming [--rename-sep].  Default is to not replace any separator.
       rename_slash = "string"
	      Replace slashes with a string in tags before renaming [--rename-slash].  Default is to replace with a dash.
       rename_ext = <0/1>
	      Assume the rename format provides an extension [--rename-ext].  Default is 0 (disabled).

Miscellaneous
       dry_run = <0/1>
	      Do nothing but show what would have been done [--dry-run].  Default is 0 (disabled).
       yes = <0/1>
	      Tag without asking for confirmation when guessing and rename without asking for confirmation [--yes].  Default is 0 (disabled).
       ask = <0/1>
	      Always ask for confirmation before tagging [--ask].  Default is 0 (disabled).
       recursive = <0/1>
	      Recursively traverse all given subdirectories [-R].  Default is 0 (disabled).
       verbose = <integer>
	      Message  verbosity  level [-v and -q].  Default is 0 (only important messages).  Other possible values are 1 (show usage information
	      when a menu is displayed for the first time) and 2 (always show usage information before a menu appears).

CDDB configuration
       cddb_server_name = hostname
	      Change the CDDB server name.  Default is www.freedb.org.
       cddb_server_port = <port>
	      Change the CDDB server port.  Default is 80 (HTTP).

SEE ALSO

       lltag(1)

       The config template file provided within the documentation directory.

AUTHOR

       Brice Goglin

								   NOVEMBER 2006						   lltag_config(5)
All times are GMT -4. The time now is 02:42 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy