remove blank spaces from fields Post: 302326000

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting remove blank spaces from fields Post 302326000 by ghostdog74 on Tuesday 16th of June 2009 09:35:51 PM

Old

06-16-2009

Registered User

Code:

awk 'BEGIN{OFS=FS="|"}
{
  for(i=1;i<=NF;i++){
   gsub(/^ +| +$/,"",$i)
  }
}1'  file

ghostdog74

View Public Profile for ghostdog74

Find all posts by ghostdog74

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

remove blank spaces in a string

can any help how to remove blank spaces in a string? STR="GOOD BYE" by removing blank spaces, the string should be GOOD,BYE thanks in advance

2. Shell Programming and Scripting

How can i remove spaces in between the fields in a file

Hey , I have a file and it's having spaces for some of the fields in it. Like the one below. I want to remove the spaces in them through out the file. The spaces occur randomly and i can't say which field is having space. So please help. Here is sample file with spaces after 5th field.

3. UNIX for Dummies Questions & Answers

To remove Continous blank spaces from a file in UNIX

All... I want to remove blank spaces in file . I just leraned that we can use " cat <Input filename> | tr -s � � > <Target file name> " i also know with SED we can replace a blank space by other character by sed s/ /*/g filename. Please let me know how can i do that by...

4. Shell Programming and Scripting

how to remove blank spaces of a file with awk??

hello how to remove blank spaces of a file with awk?? i�m trying awk '{gsub(" ","",$0); print $0;}' filename.txt but it answers syntax error near line first of all i did this for download from netbackup database jobs privilege bpdbjobs -report -M sv88 -gdm -header |cut -c-1024...

5. Shell Programming and Scripting

Remove blank spaces in a text file...

Hi, I have this problem that there are blank spaces in my text file... i want to remove them line 1 line 2 line 3 I want to remove the space between line 2 and line 3... I tried sed... it work but it prints the whole text file at the command prompt which i dont want.... sde i tried was...

6. Shell Programming and Scripting

how to remove blank spaces in file

hi i have a file which store some data.the contents of my file is data1:data2 data3:data4 i have a script which read this file correct="$(cat /root/sh | cut -d: -f1)" i used this syntax..please help me which syntax is used to remove blank spaces..then how to read this file..

7. Shell Programming and Scripting

Request to check:remove entries with blank spaces

Hi I want to remove entries with blank spaces in my input file: 123 234 456 678 56789 345346456 589 3454 345456 3454566............................

8. Shell Programming and Scripting

How to remove all blank spaces in a file

I have a file which contains data such as that shown below. How do i remove all the blcnak spaces, before, during and at the end of each line in one command? 300015, 58.0823212, 230.424728 300016, 58.2276459, 229.141602 300017, 58.7590027, 226.960846 ...

9. Shell Programming and Scripting

Remove blank spaces

Gents, Please can you help me.. to remove blank spaces :) Input ABSOLUTE , ,FALSE ,1035 ,28 ,669 ,1817.0 ,CORREL BEFORE ,1 ABSOLUTE , ,FALSE ,1035 ,28 ,686 ,1817.0 ,CORREL BEFORE ,1 ABSOLUTE , ,FALSE ,1035 ,28 ,670 ,1819.0 ,CORREL BEFORE ,1 ABSOLUTE , ,FALSE ...

10. UNIX for Dummies Questions & Answers

Remove blank spaces

Dear Masters, I want to remove all lines with blank spaces input file: a|abc|0|1 a|abc|2|3 b||3|5 c|def||7 d|def|0|1 Expected: a|abc|0|1 a|abc|2|3 d|def|0|1 I did this awk -F'|' '!/^$/' input

LEARN ABOUT LINUX

makecsd

MAKECSD(1)						  The Canonical Csound Reference						MAKECSD(1)

NAME

       makecsd - Creates a CSD file from the specified input files. .

DESCRIPTION

       Creates a CSD file from the specified input files. The first input file that has a .orc extension (case is not significant) is put to the
       <CsInstruments> section, and the first input file that has a .sco extension becomes <CsScore>. Any remaining files are Base64 encoded and
       added as <CsFileB> tags. An empty <CsOptions> section is always added.

       Some text filtering is performed on the orchestra and score file:

       o   newlines are converted to the native format of the system on which makecsd is being run.

       o   blank lines are removed from the beginning and end of files.

       o   any trailing whitespace is removed from the end of lines.

       o   optionally, tabs can be expanded to spaces with an user specified tabstop size.

SYNTAX

	   makecsd [OPTIONS ... ] infile1 [ infile2 [ ... ]]

INITIALIZATION

       Flags:

       o   - t n = expand tabs to spaces using tabstop size n (default: disabled). This applies only to the orchestra and score file.

       o   - w n = set Base64 line width to n (default: 72). Note: the orchestra and score are not wrapped.

       o   - o fname = output file name (default: stdout)

EXAMPLES

	       makecsd -t 6 -w 78 -o file.csd file.mid file.orc file.sco sample.aif

       This creates a CSD from file.orc and file.sco (tabs are expanded to spaces assuming a tabstop size of 6 characters), and file.mid and
       sample.aif are added as <CsFileB> tags containing Base64 encoded data with a line width of 78 characters. The output file is file.csd.

CREDITS

       Author: Istvan Varga

       Jan 2003

AUTHORS

       Barry Vercoe
       MIT Media Lab

	   Author.

       Dan Ellis
       MIT Media Lab,
		 Cambridge
		 Massachussetts

	   Author.

COPYRIGHT

5.07								    06/23/2009								MAKECSD(1)