Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Adding EMPTY columns to Tab-delimited txt file Post 302292490 by Banni on Saturday 28th of February 2009 06:15:07 AM
Old 02-28-2009
See here's the problem with being a total newbie - don't know what defines the fieldseperator.
I just now that the ^| indicates tabs and the $ is the end-of-line-indicator or something like that. Never used -vet with cat before so only just found that out this morning. :-)

But the input file is saved as tab-delimited txt from an excel file meaning I have four columns like:

A*0201 Ireland Northern 46.8 0.274
A*0101 Ireland Northern 36.4 0.202

and I wan't

A*0201 Ireland Northern 46.8 xx xx xx xx 0.274
A*0101 Ireland Northern 36.4 xx xx xx xx 0.202

The position and content of the extra four columns(or the middle 6 columns) doesn't matter - I just need to create a Tab-delimited txt-file with A*0201 in column 1 and 0.274 in column 8.
I could start from the beginning and add the extra columns in the original excel file but I wan't to know how to do it using only Unix.

Really want to learn this but have zero experience with programming of any kind....
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Reading columns in tab delimited file

I want to read only one column in "|" delimited file and write that column to a new file. For Ex: Input File 1|abc|324|tt 2|efd|11|cbcb 3||1|fg 4|ert|23|88 Output : I want to read column 3 in diff file. 324 11 1 88 Can anyone give me inputs on this ? (2 Replies)
Discussion started by: net
2 Replies

2. UNIX for Dummies Questions & Answers

nth Columns in a Tab delimited file

Hi Can anyone help me to identify the nth field from a Tab delimited file? Thanks Subrat (8 Replies)
Discussion started by: subrat
8 Replies

3. UNIX for Dummies Questions & Answers

How to convert text to columns in tab delimited text file

Hello Gurus, I have a text file containing nearly 12,000 tab delimited characters with 4000 rows. If the file size is small, excel can convert the text into coloumns. However, the file that I have is very big. Can some body help me in solving this problem? The input file example, ... (6 Replies)
Discussion started by: Unilearn
6 Replies

4. UNIX for Dummies Questions & Answers

Deleting columns from a tab delimited text file?

I have a tab limited text file with 10000+ columns. I want to delete columns 6 through 23, how do I go about doing that? Thanks! (1 Reply)
Discussion started by: evelibertine
1 Replies

5. UNIX for Dummies Questions & Answers

Removing empty lines at the end of a Tab-delimited file

I'm trying to remove all of the empty lines at the end of a Tab delimited file. They have no data just tabs. I've tried may things, here are a couple: sed /^\t.\t/d File1 > File2 sed /^\t{44}/d File1 > File2 What am I missing? (9 Replies)
Discussion started by: SirHenry1
9 Replies

6. UNIX for Dummies Questions & Answers

How to add a header to a tab delimited .txt file?

Hi, I have a tab delimited document with 18 columns. My file looks like: comp1000201_c0_seq1 comp1000201_c0 337 183.51 0.00 0.00 0.00 0.00 ---NA--- 337 0 0 - comp1000297_c0_seq1 comp1000297_c0 612 458.50 ... (1 Reply)
Discussion started by: alisrpp
1 Replies

7. Shell Programming and Scripting

Remove blank columns from a tab delimited text file

Hello, I have some tab delimited files that may contain blank columns. I would like to delete the blank columns if they exist. There is no clear pattern for when a blank occurs. I was thinking of using sed to replace instances of double tab with blank, sed 's/\t\t//g' All of the examples... (2 Replies)
Discussion started by: LMHmedchem
2 Replies

8. Shell Programming and Scripting

Insert empty columns inside a pipe delimited file

Hi All , I have pipe delimiter file with 11 columns . I need to insert 4 empty columns after column 10 . and After 11 column I need to insert a column which is having the same value for all the rows . My file 1|2|3|4|5|6|7|8|9|10|11 New file ... (11 Replies)
Discussion started by: Hypesslearner
11 Replies

9. Shell Programming and Scripting

Delete and insert columns in a tab delimited file

Hi all , I have a file having 12 columns tab delimited . I need to read this file and remove the column 3 and column 4 and insert a word in column 3 as "AVIALABLE " Is there a way to do this . I am trying like below Thanks DJ cat $FILENAME|awk -F"\t" '{ print $1 "\t... (3 Replies)
Discussion started by: Hypesslearner
3 Replies

10. UNIX for Beginners Questions & Answers

Replace a column in tab delimited file with column in other tab delimited file,based on match

Hello Everyone.. I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files FileP.txt ... (2 Replies)
Discussion started by: YogeshG
2 Replies
Geo::HelmertTransform(3pm)				User Contributed Perl Documentation				Geo::HelmertTransform(3pm)

NAME
Geo::HelmertTransform VERSION
1.14 SYNOPSIS
use Geo::HelmertTransform; my ($lat, $lon, $h) = ...; # from OS map my $airy1830 = Geo::HelmertTransform::datum('Airy1830'); my $wgs84 = Geo::HelmertTransform::datum('WGS84'); ($lat, $lon, $h) = Geo::HelmertTransform::convert_datum($airy1830, $wgs84, $lat, $lon, $h); DESCRIPTION
Perform transformations between geographical coordinates in different datums. It is usual to describe geographical points in terms of their polar coordinates (latitude, longitude and altitude) referenced to a "datum ellipsoid", which is used to approximate the Earth's geoid. The latitude, longitude and altitude of a given physical point vary depending on which datum ellipsoid is in use. Unfortunately, a number of ellipsoids are in everyday use, and so it is often necessary to transform geographical coordinates between different datum ellipsoids. Two different datum ellipsoids may differ in the locations of their centers, or in their shape; and there may be an angle between their equatorial planes or the meridians relative to which longitude is measured. The Helmert Transform, which this module implements, is a linear transformation of coordinates between pairs of datum ellipsoids in the limit of small angles of deviation between them. CONVENTIONS
Latitude is expressed in degrees, positive-north; longitude in degrees, positive-east. Heights (ellipsoid) and cartesian coordinates are in meters. FUNCTIONS
rad_to_deg RADIANS Convert RADIANS to degrees. deg_to_rad DEGREES Convert DEGREES to radians. geo_to_xyz DATUM LAT LON H Return the Cartesian (X, Y, Z) coordinates for the geographical coordinates (LAT, LON, H) in the given DATUM. xyz_to_geo DATUM X Y Z Return the geographical (LAT, LON, H) coordinates for the Cartesian coordinates (X, Y, Z) in the given DATUM. This is an iterative procedure. convert_datum D1 D2 LAT LON H Given geographical coordinates (LAT, LON, H) in datum D1, return the corresponding coordinates in datum D2. This assumes that the transformations are small, and always converts via WGS84. datum NAME Return the datum of the given NAME. Currently implemented are: Airy1830 The 1830 Airy ellipsoid to which the British Ordnance Survey's National Grid is referenced. Airy1830Modified The modified 1830 Airy ellipsoid to which the Irish Grid (as used by Ordnance Survey Ireland and Ordnance Survey Northern Ireland); also known as the Ireland 1975 datum. WGS84 The global datum used for GPS. SEE ALSO
A guide to coordinate systems in Great Britain, http://www.gps.gov.uk/guidecontents.asp Making maps compatible with GPS, http://www.osni.gov.uk/downloads/Making%20maps%20GPS%20compatible.pdf AUTHOR AND COPYRIGHT
Written by Chris Lightfoot, team@mysociety.org Copyright (c) UK Citizens Online Democracy. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.12.4 2011-08-29 Geo::HelmertTransform(3pm)
All times are GMT -4. The time now is 09:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy