Sponsored Content
Top Forums Shell Programming and Scripting rearrange info of file in a "table" Post 302204733 by csecnarf on Thursday 12th of June 2008 11:06:41 AM
Old 06-12-2008
rearrange info of file in a "table"

Please I need to rearrange data acquired by USB port from a sensor network. The information is mixed and I need to convert it into a kind of table. This is my input file:

Node 4D5A joined
Temperature: 27,5
Humidity: 40
Dew Point: 23
No motion detected
LUX: 389
Temperature: 28
Humidity: 41
Dew Point: 21
Node 58DF joined
Temperature: 28,5
Humidity: 41
Dew Point: 24
LUX: 384
Node 4D5A joined
Temperature: 21,5
Humidity: 43
Dew Point: 20
No motion detected

Realize that every time a node send info, first is sent its ID and later different data without any specific pattern. My idea is to identify every line between Node and Node and arrange them into other file. Any pattern is posible... but I don't have any idea on how to implement it. I have been trying with awk, sed, grep... but with no result.

A possible solution could be like this:

Node:data:value
Node:data:value

or

Node
Data:value
Node
Data:value

please give some ideas or solutions Smilie

Thanks a lot!
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how do I dump "info ls" to a file?

how do I dump "info ls" to a file? I did $info ls >a <ENTER> but it didn't dump the whole thing. It only dumped chapter 10. (4 Replies)
Discussion started by: james hanley
4 Replies

2. UNIX for Advanced & Expert Users

Help, filtering some info. from a file under "()"

I HAVE A FILE "TEXT.TXT" WHICH CONTAINS FOLLOWING : CHANNEL(SYSTEM.DEF.CLUSRCVR) CHLTYPE(CLUSRCVR) CHANNEL(TO.XYZ) CHLTYPE(CLUSRCVR) NOW I WANT THE NAMES WRITTEN BETWEEN THE BRACES () UNDER COLUMN ONE, THAT IS, TO.XYZ and SYSTEM.DEF.CLUSRCVR.... (10 Replies)
Discussion started by: varungupta
10 Replies

3. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies

4. HP-UX

Need to identify the process/app which is triggering the error "vmunix: file: table is full"

Hi, I'm seeing the error vmunix: file: table is full in syslog.log. Although changing the value of the kernel parameter nfile would make this error go away, how would I identify which process/application in the server is triggering this error? The server is a HP-UX B.11.11. Thanks in advance! (1 Reply)
Discussion started by: enchogas
1 Replies

5. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

6. Shell Programming and Scripting

finding the strings beween 2 characters "/" & "/" in .txt file

Hi all. I have a .txt file that I need to sort it My file is like: 1- 88 chain0 MASTER (FF-TE) FFFF 1962510 /TCK T FD2TQHVTT1 /jtagc/jtag_instreg/updateinstr_reg_1 dff1 (TI,SO) 2- ... (10 Replies)
Discussion started by: Behrouzx77
10 Replies

7. UNIX for Advanced & Expert Users

AIX - io info get from "libperfstat" not match "iostat"

Hi, everyone. I need to write a program to get io info based on libperfstat. But the "write time" of a disk is just half of the value get from iostat. I'm confused and can't explain. Help please. How I calculate "write service time per sec": In iostat: write service... (0 Replies)
Discussion started by: jackliang
0 Replies

8. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address and column 3 contains “cc” e-mail address to include with same email. Sample input file, email.txt Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies

9. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies
sysdef(1M)                                                System Administration Commands                                                sysdef(1M)

NAME
sysdef - output system definition SYNOPSIS
/usr/sbin/sysdef [-i] [-n namelist] /usr/sbin/sysdef [-h] [-d] [-i] [-D] DESCRIPTION
The sysdef utility outputs the current system definition in tabular form. It lists all hardware devices, as well as pseudo devices, system devices, loadable modules, and the values of selected kernel tunable parameters. It generates the output by analyzing the named bootable operating system file (namelist) and extracting the configuration information from it. The default system namelist is /dev/kmem. OPTIONS
-i Prints the configuration information from /dev/kmem. This is the default and only needs to be specified if the configura- tion information from both /dev/kmem and the system file specified with the "-n namelist" option is needed. -nnamelist Specifies a namelist other than the default (/dev/kmem). The namelist specified must be a valid bootable operating system. -h Prints the identifier of the current host in hexadecimal. This numeric value is unique across all Sun hosts. -d The output includes the configuration of system peripherals formatted as a device tree. -D For each system peripheral in the device tree, display the name of the device driver used to manage the peripheral. EXAMPLES
Example 1: Sample output format The following example displays the format of the sysdef -d output: example% sysdef -d Node 'SUNW,Ultra-5_10', unit #-1 Node 'packages', unit #-1 (no driver) Node 'terminal-emulator', unit #-1 (no driver) Node 'deblocker', unit #-1 (no driver) Node 'obp-tftp', unit #-1 (no driver) Node 'disk-label', unit #-1 (no driver) Node 'SUNW,builtin-drivers', unit #-1 (no driver) Node 'sun-keyboard', unit #-1 (no driver) Node 'ufs-file-system', unit #-1 (no driver) Node 'chosen', unit #-1 (no driver) Node 'openprom', unit #-1 (no driver) Node 'client-services', unit #-1 (no driver) Node 'options', unit #0 Node 'aliases', unit #-1 (no driver) Node 'memory', unit #-1 (no driver) Node 'virtual-memory', unit #-1 (no driver) Node 'pci', unit #0 Node 'pci', unit #0 Node 'ebus', unit #0 Node 'auxio', unit #-1 (no driver) Node 'power', unit #0 Node 'SUNW,pll', unit #-1 (no driver) Node 'se', unit #0 (no driver) Node 'su', unit #0 Node 'su', unit #1 Node 'ecpp', unit #-1 (no driver) Node 'fdthree', unit #0 Node 'eeprom', unit #-1 (no driver) Node 'flashprom', unit #-1 (no driver) Node 'SUNW,CS4231', unit #0 (no driver) Node 'network', unit #0 Node 'SUNW,m64B', unit #0 Node 'ide', unit #0 Node 'disk', unit #-1 (no driver) Node 'cdrom', unit #-1 (no driver) Node 'sd', unit #1 Node 'dad', unit #1 Node 'pci', unit #-1 (no driver) Node 'SUNW,UltraSPARC-IIi', unit #-1 (no driver) Node 'pseudo', unit #0 [output truncated] FILES
/dev/kmem default operating system image ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcsu | +-----------------------------+-----------------------------+ SEE ALSO
hostid(1), prtconf(1M), nlist(3ELF), attributes(5) SunOS 5.10 4 Oct 2004 sysdef(1M)
All times are GMT -4. The time now is 11:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy