Converting tabs in to spaces.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Converting tabs in to spaces.
# 1  
Old 06-27-2002
Question Converting tabs in to spaces.

Hi!

I'm using SunOS 5.7 w/ Bash 2.01.

Currently, I'm working on a script that will make it possible to find textfiles which match certain criteria. While I write this message, I had some brainfarts, found the answer myself Smilie and the question I had in mind is now no longer the question I needed answered.

I now have another question, related to the first one, therefor I will leave the information below intact.

The output of the grepped 'ls'-output is written in a file (called 'test') like so that the file would contain:

Code:
-rw-r--r--   1 root     other        774 Jun  3 06:53 NRM1023079982241.txt
-rw-r--r--   1 root     other       2451 Jun  6 08:27 NRM1023344865054.txt
-rw-r--r--   1 root     other        516 Jun 13 09:34 NRM1023953690017.txt

How can I cut out everything from the beginning, up until 24 characters, so that it would look like:
Code:
   774 Jun  3 06:53 NRM1023079982241.txt
  2451 Jun  6 08:27 NRM1023344865054.txt
   516 Jun 13 09:34 NRM1023953690017.txt

I have tried to use awk for this, like so:

cat test | awk '{ print $5,$6,$7,$8,$9 }'
Code:
774 Jun 3 06:53 NRM1023079982241.txt
2451 Jun 6 08:27 NRM1023344865054.txt
516 Jun 13 09:34 NRM1023953690017.txt

Which produces (sort of) the desired output, but now the different columns are not aligned. Having them aligned is a requirement.

Next I thought of using cut, which is no problem, but *how* can I perform the cut-command on each line of the file? This was my original question, which I answered myself.

I now know that I can use this command:

cat test | awk '{ print $5,$6,$7,$8,$9 }' | cut -c1-24

Which works on all lines, but still doesn't produce the desired output, because (I just found out) the 'test'-file contains TAB's.

My new question is how to convert TAB's into spaces, so that I can cut out part of the file and still keep things aligned? Smilie
# 2  
Old 06-27-2002
Bug try this

>> cat test | cut -c35-80
# 3  
Old 06-27-2002
To answer the substitute question.....

sed 's/<tab goes in here>/<space goes in here>/g' file_name > new_filename
mv new_filename file_name

if this is dome from the command line - to enter the tab you will probably have to do this......
hold down ctrl
press v (while still holding down ctrl)
press i (while still holding down ctrl)

Doing it in vi - you might be able to just press tab...but the ctrl v i thing works there as well.
# 4  
Old 06-28-2002
Bug Got it worked out!

Thanks guys! Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Vimrc creating tabs instead of spaces

I'm having trouble getting my vimrc to work the way I want it. For some reason after I hit enter it is creating tabs instead of spaces like I would expect. Here is an example of what I am talking about. $ = newline, ^I = tab. On the line of struct EDGETAG* q; I hit enter and it created a tab... (2 Replies)
Discussion started by: cokedude
2 Replies

2. Shell Programming and Scripting

Converting specific Excel file tabs to CSV in Python

Hi list, This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module. I have an excel document with multiple tabs of data and graphs. One of the tabs is just data which I require to have dumped to... (8 Replies)
Discussion started by: landossa
8 Replies

3. Shell Programming and Scripting

Converting huge xls(having multiple tabs) to csv

hello I have browsed for the similar requirement i found this https://www.unix.com/shell-programming-scripting/40163-xls-csv-conversion.html but my problem is i have multiple tabs in xls file having same metadata I want to convert it into single csv file any ways to do it pls... (5 Replies)
Discussion started by: joshiamit
5 Replies

4. Shell Programming and Scripting

Remove spaces / tabs from variable in script

I want to remove extra spaces from variable in aix script. We retrieve the data from oracle database and then print the values. We have a value on 90th position. When we execute the query on sqlplus it shows the length of 90th position as 3, but when we use the same query in aix script it shows... (5 Replies)
Discussion started by: lodhi1978
5 Replies

5. Shell Programming and Scripting

replace spaces/tabs with delimiter |

Hi, I'm looking for a command that replaces spaces/tabs with pipe symbol and store the result to the same file instead of routing it to another file. infile outfile Thanks. (11 Replies)
Discussion started by: dvah
11 Replies

6. Shell Programming and Scripting

spaces to tabs - group with IP

hi buddies; i have a file.txt: Note: All the seperators are SPACE. 192.168.1.1 ParameterObject=1 Speech 1 ParameterObject=2 Speech 1 192.168.1.1 ParamFunction=1 UserID 1 (DEACTIVATED) Sector=1,Device=2,Unit=3 DeviceId 1 192.168.1.1 FeederCable=2B ... (18 Replies)
Discussion started by: gc_sw
18 Replies

7. Shell Programming and Scripting

Replacing tabs with spaces

I want my program to replace tabs with spaces.1tab=4spaces.When i write aa(tab)aaa(tab)(tab)a(tab) it must show me aaxxaaaxxxxxaxxx. I think that my program works corectly but when a write aaa(tab)a it must show aaaxa but it is aaaxxxxxa.Please for help!!! That is my code: #include <stdio.h> ... (3 Replies)
Discussion started by: marto1914
3 Replies

8. UNIX for Dummies Questions & Answers

Problem with White spaces and tabs

Hi All, I am facing issues converting white spaces and tabs together in a file I am reading. Here is the command I am trying: tr -s ' '@ | sort -t@ +1n filename I guess the problem is that it is not converting the tabs to another delimiter. Also, I am supposed to accomplish this only using... (5 Replies)
Discussion started by: sh_kk
5 Replies

9. Shell Programming and Scripting

spaces or Tabs?

When formatting a script let's say for instance the following: case ${choice} in 1) vi ${tmp1}.tmp # overwrite the tmp1 var with any user changes cp ${tmp1}.tmp ${tmp1} ;; ... (2 Replies)
Discussion started by: llsmr777
2 Replies

10. Shell Programming and Scripting

replacing tabs to spaces from files

hi, I have some 50 C files in which for indentation of code some devlopers used tabs, but we dont want any tab used for indentation. I have following 2 need. 1) find tabs from all 50 files (which are in one directory ) 2) replace them with 4 spaces. Thanks Rishi (6 Replies)
Discussion started by: rishir
6 Replies
Login or Register to Ask a Question