Sponsored Content
Top Forums Shell Programming and Scripting spaces to tabs - group with IP Post 302484271 by gc_sw on Thursday 30th of December 2010 10:15:41 AM
Old 12-30-2010
Data spaces to tabs - group with IP

hi buddies;

i have a file.txt:
Note: All the seperators are SPACE.
Code:
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     DelayTime i[15] = 1248 1248 1248
FeederCable=2C     DelayTime i[15] = 1248 1248 1248
FeederCable=2D     DelayTime i[15] = 1248 1248 1248

192.168.1.1

192.168.1.1

192.168.1.1
Function=1     MeanTime     i[24] = 0 0 0 0 0

192.168.1.1
FileLocation=1     Address     /c/user/

...
...

192.168.2.1
ParameterObject=1     Speech     2
ParameterObject=2     Speech     2

192.168.2.1
ParamFunction=1     UserID     1 (DEACTIVATED)
Sector=1,Device=2,Unit=3     DeviceId     1

192.168.2.1
FeederCable=2A     DelayTime i[25] = 3248 1248 1248
FeederCable=2A     DelayTime i[25] = 3248 1248 1248
FeederCable=2A     DelayTime i[25] = 3248 1248 1248

192.168.2.1

192.168.2.1
Function=1     MeanTime     i[24] = 0 0 0 0 0

192.168.2.1
FileLocation=1     Address     /c/user/

192.168.2.1

...

i need help to;

- search lines under same IP and get them. (values are seperated by SPACE and some IP lines have no attributes)
- write it as (values must be seperated by TABS:
Code:
IP1\tab$1\tab$2\tab$RemainingEverything...
\tab$1\tab$2\tab$RemainingEverything...

IP2\tab$1\tab$2\tab$RemainingEverything...
\tab\$1\tab$2\tab$RemainingEverything...

so; i want to organise this file as:
Code:
192.168.1.1	ParameterObject=1	Speech	1
	ParameterObject=2	Speech	1
	ParamFunction=1	UserID	1 (DEACTIVATED)
	Sector=1,Device=2,Unit=3	DeviceId	1
	FeederCable=2B	DelayTime	i[15] = 1248 1248 1248
	FeederCable=2C	DelayTime	i[15] = 1248 1248 1248
	FeederCable=2D	DelayTime	i[15] = 1248 1248 1248
	Function=1	MeanTime	i[24] = 0 0 0 0 0
	FileLocation=1	Address	/c/user/

...
...

192.168.2.1	ParameterObject=1	Speech	2
	ParameterObject=2	Speech	2
	ParamFunction=1	UserID	1 (DEACTIVATED)
	Sector=1,Device=2,Unit=3	DeviceId	1
	FeederCable=2A	DelayTime	i[25] = 3248 1248 1248
	FeederCable=2A	DelayTime	i[25] = 3248 1248 1248
	FeederCable=2A	DelayTime	i[25] = 3248 1248 1248
	Function=1	MeanTime	i[24] = 0 0 0 0 0
	FileLocation=1	Address	/c/user/

...
...


hope to tell it clearly. it's quite complex Smilie
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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 :D and the question I had in mind is now no longer the question I... (3 Replies)
Discussion started by: indo1144
3 Replies

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

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

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

5. Shell Programming and Scripting

clear extra spaces and tabs in a file

Any help appreciated Thanks sample input: > (extra spaces&tabs in here) test1 (extra spaces&tabs in here) 123.123.123.123 (extra spaces&tabs in here) abc (extra spaces&tabs in here) 123 --- < (extra spaces&tabs in... (3 Replies)
Discussion started by: goofist
3 Replies

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

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

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

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

10. Shell Programming and Scripting

Grab line regardless of if it ends with tabs or spaces

so i have a data file that has various lines which may or may not end with spaces or tabs. data.file: , \t \t {sample} <spaces> <spaaces> several more spaces.... {"resemble"}, <nospaces> Command i'm using: sed -n 8p data.file | egrep "\],$|\],\ $" or egrep "\],$|\],\ $"... (1 Reply)
Discussion started by: SkySmart
1 Replies
TABS(1) 						    BSD General Commands Manual 						   TABS(1)

NAME
tabs -- set terminal tabs SYNOPSIS
tabs [-n|-a|-a2|-c|-c2|-c3|-f|-p|-s|-u] [+m[n]] [-T type] tabs [-T type] [+[n]] n1[,n2,...] DESCRIPTION
The tabs utility displays a series of characters that first clears the hardware terminal tab settings and then initializes the tab stops at the specified positions and optionally adjusts the margin. The phrase "tab-stop position N" means that, from the start of a line of output, tabbing to position N shall cause the next character output to be in the (N+1)th column on that line. The following options are supported: -n Specifies repetitive tab stops separated by a uniform number of columns, n, where n is a single digit decimal number. The default usage of tabs with no arguments is equivalent to tabs -8. When -0 is used, the tab stops are cleared and no new ones set. -a Assembler, applicable to some mainframes. Equivalent to tabs 1,10,16,36,72 . -a2 Assembler, applicable to some mainframes. Equivalent to tabs 1,10,16,40,72 -c COBOL, normal format. Equivalent to tabs 1,8,12,16,20,55 -c2 COBOL, compact format (columns 1 to 6 omitted). Equivalent to tabs 1,6,10,14,49 -c3 COBOL, compact format (columns 1 to 6 omitted), with more tabs than -c2. Equivalent to tabs 1,6,10,14,18,22,26,30,34,38,42,46,50,54,58,62,67 -f FORTRAN. Equivalent to tabs 1,7,11,15,19,23 -p PL/1. Equivalent to tabs 1,5,9,13,17,21,25,29,33,37,41,45,49,53,57,61 -s SNOBOL. Equivalent to tabs 1,10,55 -T type Indicates the type of terminal. -u Assembler, applicable to some mainframes. Equivalent to tabs 1,12,20,44 EXIT STATUS
The tabs utility exits 0 on success, and >0 if an error occurs. ENVIRONMENT
The COLUMNS and TERM environment variables affect the execution of tabs as described in environ(7). The -T option overrides TERM. If neither TERM nor the -T option are present, tabs will fail. SEE ALSO
expand(1), stty(1), tput(1), unexpand(1), termcap(5) STANDARDS
The tabs utility conforms to IEEE Std 1003.1 (``POSIX.1''). HISTORY
A tabs utility first appeared in PWB UNIX. This implementation was introduced in NetBSD 6.0. AUTHORS
Roy Marples <roy@NetBSD.org> BUGS
The current termcap(5) database does not define the set left soft margin 'ML' capability for any terminals. BSD
December 9, 2008 BSD
All times are GMT -4. The time now is 03:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy