Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Blank spaces missing in the file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Blank spaces missing in the file
# 1  
Old 02-15-2010
Blank spaces missing in the file
I have a file which has blank spaces($) and the blank spaces at the end of the file are not coming up while cutting the files.. please find the following file, desired output..

file1:
Code:
001_AHaris$$$$$020$$$$$$$$$
001_ATony$$$$$$030$$$$$$$$$
002_AChris$$$$$090$$$$$$$$$
002_ASmit$$$$$$060$$$$$$$$$
003_AJhon$$$$$$001$$$$$$$$$

$ indicates blank space

code

Code:
while read "LINE"; do
  echo "$LINE" | cut -c6- >> $(echo "$LINE" | cut -c1-5).txt
done < file1

current output as per the above code...

Code:
$ cat 001_A.txt 
001_AHaris$$$$$020
001_ATony$$$$$$030

$ cat 002_A.txt 
002_AChris$$$$$090
002_ASmit$$$$$$060

$ cat 003_A.txt 
003_AJhon$$$$$$001

I am not getting the blank space in the individual files which are at the end of the line but getting the spaces with in the line...please give your ideas to resolve this...

Desired Output:-

Code:
$ cat 001_A.txt 
001_AHaris$$$$$020$$$$$$$$$
001_ATony$$$$$$030$$$$$$$$$

$ cat 002_A.txt 
002_AChris$$$$$090$$$$$$$$$
002_ASmit$$$$$$060$$$$$$$$$

$ cat 003_A.txt 
003_AJhon$$$$$$001$$$$$$$$$

Thanks
Last edited by techmoris; 02-16-2010 at 10:05 AM.. Reason: Please use code tags!
# 2  
Old 02-15-2010
Code:
while read line;do echo "${line#*_}" >> ${line:0:5}.txt;done < infile

# 3  
Old 02-15-2010
didn't worked
while read line;do echo "${line#*_}" >> ${line}.txt;done < file.txt

still not getting the blank spaces...after the end of the line in the file..
Last edited by techmoris; 02-15-2010 at 11:25 PM..
# 4  
Old 02-15-2010
Try:

Code:
awk '{ str=substr($0,0,5); print >str; }' file

I/p & o/p ($ is the LF)
Code:
/home/usr1 >cat -e file
001_AHaris     020          $
001_ATony      030          $
002_AChris     090          $
002_ASmit      060          $
003_AJhon      001          $
/home/usr1 >cat -e 001_A
001_AHaris     020          $
001_ATony      030          $
/home/usr1 >cat -e 002_A
002_AChris     090          $
002_ASmit      060          $
/home/usr1 >cat -e 003_A
003_AJhon      001          $

# 5  
Old 02-15-2010
My solution work for bash , see Bash under AIX 5.3 - The UNIX and Linux Forums

---------- Post updated at 10:29 PM ---------- Previous update was at 10:29 PM ----------

Please use [code] tags when you post code or data sample.
# 6  
Old 02-15-2010
didn't worked in AIX
CODE: awk '{ str=substr($0,0,5); print >str; }' file.txt

Please find the following error..

awk: A print or getline function must have a file name

The input line number is 6. The file is file.txt.
The source line number is 1.

---------- Post updated at 10:57 PM ---------- Previous update was at 10:38 PM ----------
Quote:
Originally Posted by techmoris
file1:
001_AHaris$$$$$020$$$$$$$$$
001_ATony$$$$$$030$$$$$$$$$
002_AChris$$$$$090$$$$$$$$$
002_ASmit$$$$$$060$$$$$$$$$
003_AJhon$$$$$$001$$$$$$$$$

$ indicates blank space

code

while read "LINE"; do
echo "$LINE" | cut -c6- >> $(echo "$LINE" | cut -c1-5).txt
done < file1

current output as per the above code...

$ cat 001_A.txt
001_AHaris$$$$$020
001_ATony$$$$$$030

$ cat 002_A.txt
002_AChris$$$$$090
002_ASmit$$$$$$060

$ cat 003_A.txt
003_AJhon$$$$$$001

I am not getting the blank space in the individual files which are at the end of the line but getting the spaces with in the line...please give your ideas to resolve this...

Desired Output:-

$ cat 001_A.txt
001_AHaris$$$$$020$$$$$$$$$
001_ATony$$$$$$030$$$$$$$$$

$ cat 002_A.txt
002_AChris$$$$$090$$$$$$$$$
002_ASmit$$$$$$060$$$$$$$$$

$ cat 003_A.txt
003_AJhon$$$$$$001$$$$$$$$$

Thanks
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Detect blank spaces in a CSV file

I'm monitoring a WLAN network to keep track of new SSIDs popping up. The SSIDs are stored along with the AP MAC address and a few other parameters in a CSV file. A typical line could look like this: 18:70:9f:e3:80:aa 10:11:15 MyNetwork 2437 Now, the problem is that some networks use SSIDs... (4 Replies)
Discussion started by: Zooma
4 Replies

2. 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

3. 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 Replies)
Discussion started by: carlr
9 Replies

4. Shell Programming and Scripting

Help with removal of blank spaces in a file

Hello.. I have a text file. I want to remove all the blank spaces(except tab) from the file.. I tried using sed command as shown below sed 's/ //g' file1 But the problem with the above command is that it also eliminates 'tab' which is between the columns.. For example if the contents... (7 Replies)
Discussion started by: abk07
7 Replies

5. 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.. (1 Reply)
Discussion started by: shubhig15
1 Replies

6. AIX

missing blank spaces while cutting the file to individual files

$ indicates blank space file1.txt: 001_AHaris$$$$$020$$$$$$$$$ 001_ATony$$$$$$030$$$$$$$$$ 002_AChris$$$$$090$$$$$$$$$ 002_ASmit$$$$$$060$$$$$$$$$ 003_AJhon$$$$$$001$$$$$$$$$ $ indicates blank space code while read "LINE"; do echo "$LINE" | cut -c6- >> $(echo "$LINE" | cut... (1 Reply)
Discussion started by: techmoris
1 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

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

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

10. Shell Programming and Scripting

Removing blank spaces from a file?

Guys, I need some help... how can I remove the blank spaces between the lines below? (between the date and the hour fields) 21/05/07 00:05:00 99 21/05/07 00:10:01 99 21/05/07 00:15:00 99 21/05/07 00:20:00 99 21/05/07 00:25:00 99 I want to make the file... (4 Replies)
Discussion started by: dfs
4 Replies
Login or Register to Ask a Question