print columns with spaces

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting print columns with spaces
# 1  
Old 08-08-2011
print columns with spaces

Hi All

I've a file which is similar to the one given below
column1	coulmn2	column3	column4
A	            B	            C	            D
		                    X	            Y
F	            	            G	            H

I would like to get it in this format

Is this possible using sed or gawk?

Last edited by Scott; 08-08-2011 at 10:12 AM.. Reason: Code tags
# 2  
Old 08-08-2011

Last edited by yazu; 08-15-2011 at 05:11 AM.. Reason: The original post was changed
# 3  
Old 08-08-2011
gawk 'NF==4{t=gensub(/[^ ]+( +).*/,"\\1",1,$0)}{gsub(t,"|");gsub(/ +/,"|")}1'

# 4  
Old 08-08-2011
Assuming the white space is a tab ...
$ tr "\t" "|" < file

# 5  
Old 08-15-2011
Thanks a lot fpmurphy and yinyuemi.

I got it working by using sed itself.

I was not able to use gawk since i'm running it on Windows, it gave me error

gawk: cmd. line:1: 'NF==4{t=gensub(/[
gawk: cmd. line:1: ^ Invalid char ''' in expression (i think it is because windows don't like ')

tr is not working because the file is having multiple spaces (not tabs, i was thinking it was tab).

Thank you very much for your inputs.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Print between pattern without spaces

I seem to have hit a curious problem where sed and awk based regex do not seem to work. Perhaps I am missing a switch to look within the same line and not across lines. I have input as follows: ... (4 Replies)
Discussion started by: jamie_123
4 Replies

2. Shell Programming and Scripting

awk - print columns with text and spaces

Hi, I'm using awk to print columns from a tab delimited text file: awk '{print " "$2" "$3" $6"}' file The problem I have is column 6 contains text with spaces etc which means awk only prints the first word. How can I tell awk to print the whole column content as column 6? Thanks, (10 Replies)
Discussion started by: keenboy100
10 Replies

3. Shell Programming and Scripting

How to remove spaces between the columns in UNIX script?.

Hi guru's, I am trying to write a script to generate a csv file by connecting to database run a query and put the values into csv file. But the problem i face is i am getting lot of space after one can i remove those values?. Please help. #!/bin/bash export... (2 Replies)
Discussion started by: karingulanagara
2 Replies

4. Shell Programming and Scripting

Triming spaces few columns

File contains 10 columns,i want trim the 2,4,10 columns using single unix command. Please suggest me how to do? Thanks (21 Replies)
Discussion started by: bmk
21 Replies

5. Shell Programming and Scripting

Merge 2 columns/remove specific spaces

Hi, I have a requirement to remove certain spaces from a table of information, but I'm unsure where to start. A typical table will be like this: ABCDE 1 Elton John 25 12 15 9 3 ABCDE 2 Oasis 29 13 4 6 9 ABCDE 3 The Rolling Stones 55 19 3 8 6The goal is to remove only the spaces between... (11 Replies)
Discussion started by: danhodges99
11 Replies

6. Shell Programming and Scripting

convert rows (with spaces) to columns

Hey all, I have a list in the format ; variable length with spaces more variable information some more variable information and I would like to transform that 'column' into rows ; variable length with spaces more variable information some more variable information Any... (8 Replies)
Discussion started by: TAPE
8 Replies

7. UNIX for Dummies Questions & Answers

using tr to print spaces between lines

hi forum i was wondering can you use tr to print out a file like this i see that there is no way you could do that i feel i see that there is no way you could do that i feel i see that there is no way you could do that i feel i see that there is no way you could do that i feel i see that... (2 Replies)
Discussion started by: ShinTec
2 Replies

8. Shell Programming and Scripting

Format data to columns addind spaces

Hi all, I have a problem to format data from different database queries into one look. The input data are as follows, every line has the same number of values but a different number of characters: adata, bdata, cdata, ddata fffdata, gdata, hdata, idata jdata, kdata, ... (6 Replies)
Discussion started by: old_mike
6 Replies

9. Shell Programming and Scripting

Remove spaces from columns

I have a file with only one field something like this : 213.45 220.65 240.47 345.67 320.45 I want to remove all spaces in between. Is there any unix command for that ?Thanks in advance.. (2 Replies)
Discussion started by: jacks
2 Replies

10. Shell Programming and Scripting

removing spaces betweent columns

Hello Friends, Can any one help me with this issue: I would like to format a file: say if I have rows like: 4512 , SMITH , I-28984 ,, 4324 , 4343 42312 , SMITH , I-2EE8984 ,, 432E4E4 , 4343 I would like to have the output diaplayed like : 4512... (8 Replies)
Discussion started by: sbasetty
8 Replies
Login or Register to Ask a Question