blank spaces getting deleted


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting blank spaces getting deleted
# 1  
Old 05-15-2007
Java blank spaces getting deleted

I have to filter out data from a file based on the value of first three characters of each record I have used the following logic

FIN=$LOC/TEST2.TXT

FEEDFILE=$LOC/TEST1.TXT

while read FDROW
do

FEEDROW=$FDROW;

DTYPE=`echo $FEEDROW |cut -c 1-3`
if [ $DTYPE -eq 300 ] ; then

echo $FEEDROW >> $FIN
fi
done < $FEEDFILE

However there is one problem thats occuring in this caseRecords are shrinking as while reading the file when the data (record) is getting stored in $FDROW variable blank spaces within record are being truncated and this is creating problems as the base file/output file, that I am using is a flat file and hence field positions are getting disturbed in the output file TEST2.txt, is there a way to prevent this or is there any other way this can be done?
# 2  
Old 05-15-2007
Try to modify the Internal Field Separator :
Code:
FIN=$LOC/TEST2.TXT
FEEDFILE=$LOC/TEST1.TXT

while IFS= read FDROW
do
   FEEDROW=$FDROW;
   DTYPE=`echo $FEEDROW |cut -c 1-3`
   if [ $DTYPE -eq 300 ] ; then
      echo $FEEDROW >> $FIN
   fi
done < $FEEDFILE

Jean-Pierre.
# 3  
Old 05-15-2007
Code:
awk ' /^300/ ' $FEEDFILE > $FIN

# 4  
Old 05-15-2007
Java

Quote:
Originally Posted by aigles
Try to modify the Internal Field Separator :
Code:
FIN=$LOC/TEST2.TXT
FEEDFILE=$LOC/TEST1.TXT

while IFS= read FDROW
do
   FEEDROW=$FDROW;
   DTYPE=`echo $FEEDROW |cut -c 1-3`
   if [ $DTYPE -eq 300 ] ; then
      echo $FEEDROW >> $FIN
   fi
done < $FEEDFILE

Jean-Pierre.


Tried using IFS but also it's not working
# 5  
Old 05-15-2007
Add quotes around $FEEDROW in the echo statement;
Code:
FIN=$LOC/TEST2.TXT
FEEDFILE=$LOC/TEST1.TXT

while IFS= read FDROW
do
   FEEDROW=$FDROW;
   DTYPE=`echo $FEEDROW |cut -c 1-3`
   if [ $DTYPE -eq 300 ] ; then
      echo "$FEEDROW" >> $FIN
   fi
done < $FEEDFILE

So, i think that aubu23 solution is the best way to do the work.

Jean-Pierre.
# 6  
Old 05-15-2007
Quote:
Originally Posted by aigles
Add quotes around $FEEDROW in the echo statement;
Code:
FIN=$LOC/TEST2.TXT
FEEDFILE=$LOC/TEST1.TXT

while IFS= read FDROW
do
   FEEDROW=$FDROW;
   DTYPE=`echo $FEEDROW |cut -c 1-3`
   if [ $DTYPE -eq 300 ] ; then
      echo "$FEEDROW" >> $FIN
   fi
done < $FEEDFILE

So, i think that aubu23 solution is the best way to do the work.

Jean-Pierre.
Thanks the use of qoutes has done the trick and also thanks to ABU that thing is also working
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Delete blank spaces and blank lines in a file

Hi Gurus, Somebody can say me how to delete blank spaces and blank lines in a file unix, please. Thank you for advanced. (10 Replies)
Discussion started by: systemoper
10 Replies

2. 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 (4 Replies)
Discussion started by: radius
4 Replies

3. 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 ... (4 Replies)
Discussion started by: jiam912
4 Replies

4. Solaris

Removing blank spaces

Hi , I want to go out of vi editor temporarily and execute a command in command prompt and again going back to the editor . Is it possible . Any help on this is really helpful. 1. Need to open vi 2. Temporarily come out and execute a command and go back to vi editor (6 Replies)
Discussion started by: rogerben
6 Replies

5. Shell Programming and Scripting

how to read blank spaces

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 read blank spaces.and then remove it and after that how to read... (1 Reply)
Discussion started by: shubhig15
1 Replies

6. Shell Programming and Scripting

Problems with Blank Spaces

Hi to all. How can I pass to the stat command a file path with blank spaces? And another question, if I use stat command like this: stat / -name "*.sh" -user $user_name -exec stat -c %n%x {} \; How can I get the result with a ":" into the name of the file and the time of the last... (4 Replies)
Discussion started by: daniel.gbaena
4 Replies

7. Shell Programming and Scripting

Removing blank spaces, tab spaces from file

Hello All, I am trying to remove all tabspaces and all blankspaces from my file using sed & awk, but not getting proper code. Please help me out. My file is like this (<b> means one blank space, <t> means one tab space)- $ cat file NARESH<b><b><b>KUMAR<t><t>PRADHAN... (3 Replies)
Discussion started by: NARESH1302
3 Replies

8. Shell Programming and Scripting

Handling blank spaces

Hi, I am trying to replace a specific column values in a csv file with double quotes when I am find embedded spaces with in the fields. Example: SNO,NAME,ZIPCODE,RANK,SEX,ADDRESS 1,Robert,74538,12,34, M,Robert Street, NY 2,Sam,07564,13,M,12 Main Ave, CA 3,Kim, Ed,12345,14,M,123D ,... (1 Reply)
Discussion started by: techmoris
1 Replies

9. UNIX for Dummies Questions & Answers

string with blank spaces

I have a file that has dates like this: date FINAL_RESULT; 7 date FINAL_RESULT; 2 date FINAL_RESULT; 5 With this command: seira=`cut -f2 -d\; tes.txt` i take the date FINAL RESULTs and i store them on variable seira.then seira look like this: 6 3 8 I want to read seira and make a sum of all... (4 Replies)
Discussion started by: psalas
4 Replies

10. Shell Programming and Scripting

howtodelete blank spaces

sry im new to this...another qns.. if i have a line in the normal shell the file is email.scp. it contains a txt file eg hello.txt that contain this infomation. k@hotmail.com j@jotm.com how do i delete away the blank spaces after the k@hotmail.com..i dun wan any blank spaces after the... (2 Replies)
Discussion started by: forevercalz
2 Replies
Login or Register to Ask a Question