Sponsored Content
Full Discussion: Data from table to column
Top Forums UNIX for Advanced & Expert Users Data from table to column Post 302415184 by Nila on Thursday 22nd of April 2010 02:07:43 AM
Old 04-22-2010
Try this,

Code:
sed -re "s/[ ]{2,}/\n/g" test_file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

file in to the column of the table

Hi I am ETL person. I have a table in Oracle having one of its column defined as BLOB where it can hold huge data. When i generate a file in DataStage and place it in a path. and i would like dump the file in to the column of the table having datatype as BLOB. (0 Replies)
Discussion started by: sant_leo
0 Replies

2. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

3. UNIX for Dummies Questions & Answers

average of a column in a table

Hello, Is there a quick way to compute the average of a column data in a numerical tab delimeted file? Thanks, Gussi (2 Replies)
Discussion started by: Gussifinknottle
2 Replies

4. Shell Programming and Scripting

From column to table

Hi, I have an ascii file containing information. This file is n x m lines. Is there a way to generate an ascii file where the information is stored as n x m table instead? The m columns should be tab separated. Thanks a lot, Sarah (11 Replies)
Discussion started by: f_o_555
11 Replies

5. Shell Programming and Scripting

Construct 3 column table from one column list

Hi all! trying my best to parse a public site for information (ie fiscal year and turnover) about corporations. Doing this by having a file with business name and registration number (search key) the file bolag.txt currently looks like this Burgundy 556732-7217 AcademicSearch 556406-9879... (11 Replies)
Discussion started by: martindebruin
11 Replies

6. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies

7. Shell Programming and Scripting

Compare 2 files and match column data and align data from 3 column

Hello experts, Please help me in achieving this in an easier way possible. I have 2 csv files with following data: File1 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:35:47,JOB_5330 08/23/2012 12:36:09,JOB_5340 08/23/2012 12:36:14,JOB_5340 08/23/2012 12:36:22,JOB_5350 08/23/2012... (5 Replies)
Discussion started by: asnandhakumar
5 Replies

8. Shell Programming and Scripting

Split column data if the table has n number of column's

please write a shell script Table -------------------------- 1 2 3 a b c 3 4 5 c d e 7 8 9 f g h Output should be like this --------------- 1 2 3 3 4 5 7 8 9 a b c c d e f g h (1 Reply)
Discussion started by: Priti2277
1 Replies

9. Shell Programming and Scripting

Split column data if the table has n number of column's with some record

Split column data if the table has n number of column's with some record then how to split n number of colmn's line by line with records Table --------- Col1 col2 col3 col4 ....................col20 1 2 3 4 .................... 20 a b c d .................... v ... (11 Replies)
Discussion started by: Priti2277
11 Replies

10. Shell Programming and Scripting

Change data in one column with data from another file's column

Hello, I have this file outputData: # cat /tmp/outputData __Capacity^6^NBSC01_Licences^L3_functionality_for_ESB_switch __Capacity^2100^NBSC01_Licences^Gb_over_IP __Capacity^1837^NBSC01_Licences^EDGE_BSS_Fnc __Capacity^1816^NBSC01_Licences^GPRS_CS3_and_CS4... (1 Reply)
Discussion started by: nypreH
1 Replies
OUTPUT(5)							File Formats Manual							 OUTPUT(5)

NAME
output - output data file formats DESCRIPTION
This manual page describes the output formats of the files created by the Yagi-Uda project's output program. The files are ASCII file, so can be analysed with any graph plotting program. Example of a .dat File Below is a typical .dat file, for a 4ele 144-146MHz beam, optimised for a huge (and useless) FB. # Driven=1 parasitic=3 total-elements=4 design=145.000MHz # Checked from 144.000MHz to 146.000MHz. f(MHz) E(deg) H(deg) R jX VSWR Gain(dBi) FB(dB) SideLobes(dB) 144.000 54.7 71.5 44.47 -2.35 1.136 9.386 21.944 16.650 144.500 54.0 70.1 41.34 -0.75 1.210 9.553 27.244 17.153 145.000 53.2 68.4 37.55 1.61 1.335 9.742 103.055 17.777 145.500 52.3 66.6 33.26 5.00 1.530 9.947 25.734 18.547 146.000 51.3 64.6 28.77 9.63 1.832 10.149 18.919 18.919 What is what in the .dat file The f(MHz) column is the frequency (MHz) at which the data is evaluated at. The E(deg) column is the approximate 3dB E-plane bandwidth calculated to the nearest 0.1 degree. The H(deg) column is the approximate 3dB H-plane bandwidth calculated to the nearest 0.1 degree. The (R) column is the input resistance in Ohms. The (jX) column is the input reactance in Ohms. The (VSWR) column is the input VSWR, usually refered to a 50 Ohm input, but this may be changed. The Gain (dBi) column is the gain at theta=90 degrees, which is the forward direction of the beam. It is possible that a higher gain occurs at other than 90 degrees, but this is not taken into account. The antenna is seriously at fault if this occurs. The FB(dB) column is the front to back ratio in dB. The Sidelobes(dB) column is the minimum level in dB down from the peak gain of any sidelobe. This is not calculated unless the '-c' option is used, and then only on some optimisation techniques. Example of a .gai File The following is a small section of the .gai file. f(MHz) theta gain-E(dBi) G(E)-peak phi gain-H(dBi) G(H)-peak 144.0000 -90.0000 -12.5584 -21.9444 -180.0000 -12.5584 -21.9444 144.0000 -45.0000 -7.3507 -16.7367 -135.0000 -3.5971 -12.9830 144.0000 0.0000 -999.0000 -1008.3860 -90.0000 -0.9010 -10.2870 144.0000 45.0000 0.1848 -9.2012 -45.0000 4.0261 -5.3599 144.0000 90.0000 9.3860 0.0000 0.0000 9.3860 0.0000 144.0000 135.0000 0.1848 -9.2012 45.0000 4.0261 -5.3599 144.0000 180.0000 -999.0000 -1008.3860 90.0000 -0.9010 -10.2870 144.0000 225.0000 -7.3507 -16.7367 135.0000 -3.5971 -12.9830 144.0000 270.0000 -12.5584 -21.9444 180.0000 -12.5584 -21.9444 What is what in the .gai file The f(MHz) column is the frequency in MHz. The theta column is the angle theta, for which the next two columns refer. The gain-E(dBi) is the gain at theta, relative to an isotropic radiator. This is the E-plane gain. Hence at the peak (theta), this gives the peak forward gain. The G(E)-peak is the gain at theta, relative to the peak gain. Hence at the peak (theta=90 degrees), this is zero. The phi column has nothing to do with the previous 3 columns. It is the angle for which the next two columns refer. The gain-H(dBi) is the gain at phi, relative to an isotropic radiator. This is the H-plane gain. Hence at the peak (phi=0), this gives the peak forward gain. The G(H)-peak is the gain at phi, relative to the peak gain. Hence at the peak (phi=0 degrees), this is zero. Example of a .up File The .up file list the improvements made by optimise to an antenna design. Starting from the original design, the file is appended each time a new better design is found. Here is an example, where the final line is the performance of the 4ele beam with the .dat file shown ear- lier. 1 7.57dBi, 16.93dB F/B, Z=(31.77-56.34j) Ohms, VSWR=3.95, SL=16.95 dB 84 7.58dBi, 16.93dB F/B, Z=(31.78-56.32j) Ohms, VSWR=3.95, SL=16.95 dB 623 7.58dBi, 16.93dB F/B, Z=(31.78-56.28j) Ohms, VSWR=3.95, SL=16.95 dB 89345 9.74dBi, 103.06dB F/B, Z=(37.55 +1.61j) Ohms, VSWR=1.33, SL=17.78 dB What is what in the .up file The first column is an integer specifying the iteration. The other columns, going from left to right are gain(dBi), FB, input impedance, VSWR and level of the most significant sidelobe, in dB down on the peak gain. SEE ALS0 yagi(1), output(1), input(1), optimise(1), first(1) and yagi(5). AUTHORS
Dr. David Kirkby G8WRB (david.kirkby@onetel.net), with help with converting to DOS from Dr. Joe Mack NA3T (mack@fcrfv2.ncifcrf.gov). Version 1.16 24th October 2000 OUTPUT(5)
All times are GMT -4. The time now is 03:55 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy