Replace space and tab to pipe delimeter

Tags

shell scripts

Top Forums Shell Programming and Scripting Replace space and tab to pipe delimeter

04-25-2013

Registered User

16, 0

Join Date: Mar 2007

Last Activity: 25 April 2013, 8:11 AM EDT

Location: Bangalore,India

Posts: 16

Thanks Given: 0

Thanked 0 Times in 0 Posts

Quote:

Originally Posted by hanson44

Here's the correct way:

Code:

$ sed "s/ *$//; s/[[:space:]]\+/|/g; s/$/|/" file
abc|12|34|45|code|
abcdef|451|1|4|code|
ghtyggg|4|56|3|code|

How about this one? simple and easy to understand

Code:

cat a1.dat|tr -s ' ' '|'| sed 's/$/|/'
abc|12|34|45|code|
abcdef|451|1|4|code|
ghtyggg|4|56|3|code|

Last edited by Franklin52; 04-25-2013 at 08:23 AM.. Reason: Please use code tags

bishnu.bhatta

View Public Profile for bishnu.bhatta

Find all posts by bishnu.bhatta

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk with tab delimeter

Hi Team below test file contains tab delimeter file and i am excepting the number of files 3. File : test.txt a b c awk -vFPAT='\t' -vOFS="\t" -v a="0" -v b="10" ' NR>a {if (NF != b ) print NR"@"NF }' test.txt current output is 1@2 required output is 1@3 Cloud you please help...

2. UNIX for Beginners Questions & Answers

Replace space by tAB

My file looks like 3 33 210.01.10.0 2.1 1211 560 26 45 1298 98763451112 15412323499 INPUT OK 3 233 40.01.10.0 2.1 1451 780 54 99 1876 78787878784 15423210199 CANCEL OK Aim is to replace the spaces in each line by tab Used: sed -e 's/ */\t/g' But I get output like this...

3. Shell Programming and Scripting

Replace every second instance of delimeter

Hi, Need help on replacing every second instance of delimeter. Scenario: var="Name1,Value1,Name2,Value2,Name3,Value3,Name4,Value" I want every second "," to replace with "|" I tried like below echo $var| sed 's/,/|/2' But, it's not working. Expected output: ...

4. UNIX for Dummies Questions & Answers

[Solved] Replace first two set of space(s) with tab

My data is jumbled up in the following way. I want to replace only the first two occurrences of space sets (may be a single space also) in every line with a single tab, please help. I want to be able to import the tab delimited columns into excel. Input a b c d e f g h i line1 j k ...

5. UNIX for Dummies Questions & Answers

Changing only the first space to a tab in a space delimited text file

Hi, I have a space delimited text file but I only want to change the first space to a tab and keep the rest of the spaces intact. How do I go about doing that? Thanks!

6. Shell Programming and Scripting

how to display column value in a row with space as delimeter

Hi I need to write a small script to kill the process id of particular job in one shot , Example > ps PID TTY TIME COMMAND 16280 pts/70 0:00 sh 16278 pts/70 0:00 rlogind 16197 pts/70 0:00 ps 1234 pts/70 0:00 runflow 2341 pts/70 0:00 runflow 12673 pts/70 ...

7. Shell Programming and Scripting

how to replace new line ( \n ) with space or Tab in Sed

Hi, how to replace new line with tab in sed ... i used sed -e 's/\n/\t/g' <filename > but its not working

8. Shell Programming and Scripting

Replace a Pipe with tab

9. UNIX for Dummies Questions & Answers

How do you represent a field delimeter that is a space???

you know like if you want to work on a specified field in the password file. you would specify the field your interested in my telling the script that the fields are separated by a colon. now, my problem is that I want to specify a field that is not separated by a colon but by a space or tab...

10. UNIX Desktop Questions & Answers

replace tab with space

How do I replace a tab with a space in scripts using sed/awk ?

Shell Programming and Scripting