Sponsored Content
Top Forums Shell Programming and Scripting remove space in front or end of each field Post 302111596 by happyv on Thursday 22nd of March 2007 12:36:02 AM
Old 03-22-2007
remove space in front or end of each field

Hi,

I have a txt file called a.txt which contain over 10,000 records and I would like to remove space before comma or after comma....like below:

The input (for example two record 00001,00002):
00001,client,card limited ,02292,N ,162:41 , 192, 94.589000, 0.000000, 94.589000, 0.000000,0 , 0, 0.000000, 0.000000, 0.000000, 0.000000,162:41 , 192, 94.589000, 0.000000, 94.589000, 0.000000,SIG ,SIN
00002,client2,hello Corporation Limited ,02507,N ,1594:23 , 193, 332.890000, 0.000000, 332.890000, 0.000000,0 , 0, 0.000000, 0.000000, 0.000000, 0.000000,1594:23 , 193, 332.890000, 0.000000, 332.890000, 0.000000,AUS ,AUD

output:
00001,client,card limited,02292,N,162:41,192,94.589000,0.000000,94.589000, 0.000000,0,0,0.000000,0.000000,0.000000,0.000000,162:41,192,94.589000, 0.000000,94.589000,0.000000,SIG,SIN
00002,client2,hello Corporation Limited,02507,N,1594:23,193,332.890000,0.000000,332.890000,0.000000,0 ,0,0.000000,0.000000,0.000000,0.000000,1594:23,193,332.890000,0.000000,332.890000,0.000000,AUS,AUD


condition:
- the 3nd field is a company name which may have space between each word. However, I just need to delete space at front and end split by ","
- the last field like record no#1 "SIN" may contain a few space after "SIN", I also need to delete it as well.

Please help and thanks!!!!!
 

8 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Front end on Unix

Hi, I would like to develop a user interface on Solaris. Can anybody throw some light on currently available software utilities/ packages..? Thanks in Advance .. JS (4 Replies)
Discussion started by: shibz
4 Replies

2. Programming

Running exe's from front end

Hi, I have created a tool which analyses and debugs cobol programs on Unix environment usin the C files. I now want to create a frontend for the tool in windows. For this i need to establish some kinda communication between the front the end and the back end. I know pipes in one way of... (0 Replies)
Discussion started by: Sinbad
0 Replies

3. Shell Programming and Scripting

awk get rid of space in end of field

Hello. I'm using a file to "grep" in a 2nd one (with awk) cat file1 2 first user 9 second user 1 third user (with a space after user) I want to get the line except the 1st field so I do : field=$(gawk '{$1 =""; print $0}' file | sed 's/^ //') It works but it deletes... (5 Replies)
Discussion started by: xanthos
5 Replies

4. UNIX for Dummies Questions & Answers

Sed $ appending to front, not to the end

I keep trying to append some astrix to the end of a line, but it keeps overwriting at the front of the line. These are the originals Fred Fardbarkle:674-843-1385:20 Parak Lane, Duluth, MN 23850:4/12/23:780900 Fred Fardbarkle:674-843-1385:20 Parak Lane, Duluth, MN 23850:4/12/23:780900 ... (5 Replies)
Discussion started by: DrSammyD
5 Replies

5. UNIX for Dummies Questions & Answers

Communicate to the OS(linux) using front end.

Hi guys , I want to develop a web page which is capable of executing the command on os and show the output on the browser.(Which involves reading and writing too.) I m using jsp language to develop the web page. How would i use it to communicate with my linux server? Any... (3 Replies)
Discussion started by: pinga123
3 Replies

6. Shell Programming and Scripting

Remove line starting from space till end.

Hi, I have a code tag, from which i have the below snippet: intelrpt.GetCMB_FB type=ODBC> intelrpt.GetCMB_FB type=SYBASE> I want the output like: intelrpt.GetCMB_FB intelrpt.GetCMB_FB That is remove the lines starting from WHITESPACE till end. Please help. I am new to... (7 Replies)
Discussion started by: anupdas
7 Replies

7. Shell Programming and Scripting

How to remove alphabets/special characters/space in the 5th field of a tab delimited file?

Thank you for 4 looking this post. We have a tab delimited file where we are facing problem in a lot of funny character. I have tried using awk but failed that is not working. In the 5th field ID which is supposed to be a integer only of that file, we are getting corrupted data as below. I... (12 Replies)
Discussion started by: Srithar
12 Replies

8. Programming

Publish notification via application front end

hi All I use tomcat server to publish war file. How to send an notification to users via the application screen and it should dismiss once user clicks X mark. Any suggestions ? (0 Replies)
Discussion started by: anil529
0 Replies
gdalinfo(1)						      General Commands Manual						       gdalinfo(1)

NAME
gdalinfo - gdalinfo lists information about a raster dataset SYNOPSIS
gdalinfo [--help-general] [-mm] [-stats] [-hist] [-nogcp] [-nomd] [-noct] [-nofl] [-checksum] [-proj4] [-mdd domain]* [-sd subdataset] datasetname DESCRIPTION
The gdalinfo program lists various information about a GDAL supported raster dataset. -mm Force computation of the actual min/max values for each band in the dataset. -stats Read and display image statistics. Force computation if no statistics are stored in an image. -hist Report histogram information for all bands. -nogcp Suppress ground control points list printing. It may be useful for datasets with huge amount of GCPs, such as L1B AVHRR or HDF4 MODIS which contain thousands of them. -nomd Suppress metadata printing. Some datasets may contain a lot of metadata strings. -noct Suppress printing of color table. -checksum Force computation of the checksum for each band in the dataset. -mdd domain Report metadata for the specified domain -nofl (GDAL >= 1.9.0) Only display the first file of the file list. -sd subdataset (GDAL >= 1.9.0) If the input dataset contains several subdatasets read and display a subdataset with specified number (starting from 1). This is an alternative of giving the full subdataset name. -proj4 (GDAL >= 1.9.0) Report a PROJ.4 string corresponding to the file's coordinate system. The gdalinfo will report all of the following (if known): o The format driver used to access the file. o Raster size (in pixels and lines). o The coordinate system for the file (in OGC WKT). o The geotransform associated with the file (rotational coefficients are currently not reported). o Corner coordinates in georeferenced, and if possible lat/long based on the full geotransform (but not GCPs). o Ground control points. o File wide (including subdatasets) metadata. o Band data types. o Band color interpretations. o Band block size. o Band descriptions. o Band min/max values (internally known and possibly computed). o Band checksum (if computation asked). o Band NODATA value. o Band overview resolutions available. o Band unit type (i.e.. 'meters' or 'feet' for elevation bands). o Band pseudo-color tables. EXAMPLE
gdalinfo ~/openev/utm.tif Driver: GTiff/GeoTIFF Size is 512, 512 Coordinate System is: PROJCS["NAD27 / UTM zone 11N", GEOGCS["NAD27", DATUM["North_American_Datum_1927", SPHEROID["Clarke 1866",6378206.4,294.978698213901]], PRIMEM["Greenwich",0], UNIT["degree",0.0174532925199433]], PROJECTION["Transverse_Mercator"], PARAMETER["latitude_of_origin",0], PARAMETER["central_meridian",-117], PARAMETER["scale_factor",0.9996], PARAMETER["false_easting",500000], PARAMETER["false_northing",0], UNIT["metre",1]] Origin = (440720.000000,3751320.000000) Pixel Size = (60.000000,-60.000000) Corner Coordinates: Upper Left ( 440720.000, 3751320.000) (117d38'28.21"W, 33d54'8.47"N) Lower Left ( 440720.000, 3720600.000) (117d38'20.79"W, 33d37'31.04"N) Upper Right ( 471440.000, 3751320.000) (117d18'32.07"W, 33d54'13.08"N) Lower Right ( 471440.000, 3720600.000) (117d18'28.50"W, 33d37'35.61"N) Center ( 456080.000, 3735960.000) (117d28'27.39"W, 33d45'52.46"N) Band 1 Block=512x16 Type=Byte, ColorInterp=Gray AUTHORS
Frank Warmerdam warmerdam@pobox.com, Silke Reimer silke@intevation.de GDAL
Tue Sep 18 2012 gdalinfo(1)
All times are GMT -4. The time now is 03:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy