VI command for File Please


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers VI command for File Please
# 1  
Old 08-31-2005
VI command for File Please

I have a file with numbers like:

2235900
2234500
2220000
22300
235700
2200
0

and I need a search and replace to
change the number to a 3 place decimal...
like this :

2235.900
2234.500
2220.000
22.300
235.700
2.200
.000

Can someone please help me with the command
I need to use in the VI editor to get these results
of a file that has 3724 lines of numbers I need
to make into 3 place decimal numbers?

Thanks so much.
# 2  
Old 08-31-2005
I dont think you can do this in VI. Unless someone who knows vi macros can knock something together .... if you only have 1 number per line and you dont mind 0.000 instead of .000 then the following will work:

perl -e 'while($line=<>) { printf ("%.3f\n",($line/1000));}' inputfile.txt > outputfile.txt

Or if you had multiple numbers on each line then maybe:

perl -e 'while($line=<>){$line =~ s{(\d+)}{sprintf("%.3f",$1/1000)}eg; print "$line";}' inputfile.txt > outputfile.txt

Last edited by vgersh99; 08-31-2005 at 05:26 PM..
# 3  
Old 08-31-2005
Quote:
Originally Posted by Unbeliever
if you only have 1 number per line and you dont mind 0.000 instead of .000 then the following will work:
Unbeliever, Thanks for the reply. I will need to
get Perl loaded and give this a try.... running
windoz ... would really like to get back to the REAL OS but have too many apps that only run under windoz Smilie ....

Thanks,
# 4  
Old 08-31-2005
Code:
sed -e 's/\(.*\)\([0-9]\{3\}\)/\1.\2/;ta' -e 's/\(.*\)\([0-9]\{2\}\)/\1.0\2/;ta' -e 's/\(.*\)\([0-9]\{1\}\)/\1.00\2/;ta' -e ':a' fileName

# 5  
Old 08-31-2005
Quote:
Originally Posted by Unbeliever
...
perl -e 'while($line=<>) { printf ("%.3f\n",($line/1000));}' inputfile.txt > outputfile.txt ...
Unbeliever, I am getting a
" > was unexpected at this time. " when I try this command at a command prompt.

Any suggestions? Smilie
# 6  
Old 08-31-2005
Unbeliever's code works perfectly for me. *shrug*
# 7  
Old 08-31-2005
Quote:
Originally Posted by Perderabo
Unbeliever's code works perfectly for me. *shrug*
... although his SECOND sample has a missing single-quote....
lemme add it in.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Create a text file and a pdf file from Linux command results.

Hello. The task : Using multiple commands like : gdisk -l $SOME_DISK >> $SOME_FILEI generate some text file. For readiness I must insert page break. When the program is finished I want to convert the final text file to a pdf file. When finished, I got two files : One text file and One pdf... (1 Reply)
Discussion started by: jcdole
1 Replies

2. Shell Programming and Scripting

Unable to attach a .txt file or .log file to mail and mailx command

Hi, I am trying to attach a .log file or .txt file to mail command to send an email once my ksh script executed. I am unable to use mutt command as it has been not installed and i am not supposed to install it. I have tried many ways by googling which has not helped me to succeed. Here is my... (5 Replies)
Discussion started by: Samah
5 Replies

3. Shell Programming and Scripting

Speed : awk command to count the occurrences of fields from one file present in the other file

Hi, file1.txt AAA BBB CCC DDD file2.txt abc|AAA|AAAabcbcs|fnwufnq bca|nwruqf|AAA|fwfwwefwef fmimwe|BBB|fnqwufw|wufbqw wcdbi|CCC|wefnwin|wfwwf DDD|wabvfav|wqef|fwbwqfwfe i need the count of rows of file1.txt present in the file2.txt required output: AAA 2 (10 Replies)
Discussion started by: mdkm
10 Replies

4. UNIX for Advanced & Expert Users

File command return wrong filetype while file holds group separator char.

hi, I am trying to get the FileType using the File command. I have one file, which holds Group separator along with ASCII character. It's a Text file. But when I ran the File command the FileType is coming as "data". It should be "ASCII, Text file". Is the latest version of File... (6 Replies)
Discussion started by: Arpitak29
6 Replies

5. Shell Programming and Scripting

How to use awk command(file) with file command?

how can i call awk file "average.awk" (code as follows) with file commands like ls -s... #!/bin/awk -f BEGIN { # How many lines lines=0; total=0; } { # this code is executed once for each line # increase the number of files # lines++; # increase the total size, which is field #1... (2 Replies)
Discussion started by: JayDoshi
2 Replies

6. Shell Programming and Scripting

find specific file names and execute a command depending on file's name

Hi, As a newbie, I'm desperate ro make my shell script work. I'd like a script which checks all the files in a directory, check the file name, if the file name ends with "extracted", store it in a variable, if it has a suffix of ".roi" stores in another variable. I'm going to use these two... (3 Replies)
Discussion started by: armando110
3 Replies

7. Shell Programming and Scripting

Splitting a file in to multiple files and passing each individual file to a command

I have an input file with contents like: MainFile.dat: 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 ... (4 Replies)
Discussion started by: rkrish
4 Replies

8. Shell Programming and Scripting

sed command for copying the contents of other file replacing it another file on specifc pattern

We have 2 file XML files - FILE1.XML and FILE2.xml - we need copy the contents of FILE1.XML and replace in FILE2.xml pattern "<assignedAttributeList></assignedAttributeList>" FILE1.XML 1. <itemList> 2. <item type="Manufactured"> 3. <resourceCode>431048</resourceCode> 4. ... (0 Replies)
Discussion started by: balrajg
0 Replies

9. Shell Programming and Scripting

File mgt: Do you know the command line command

I need a commnad to modify a file's contents from: 2009-06-18 14:14:38 CST INF Thread-114 rlo.aaf_ - MASSHANDLE: Got a valid message<Location=""><bob>2</bob><carol>61</carol><ted>54</ted><alice>1m</alice> to this : 2009-06-18 14:14:38 CST INF Thread-114 rlo.aaf_ - MASSHANDLE: Got a... (4 Replies)
Discussion started by: linux_lou
4 Replies

10. Shell Programming and Scripting

awk/sed Command : Parse parameter file / send the lines to the ksh export command

Sorry for the duplicate thread this one is similar to the one in https://www.unix.com/shell-programming-scripting/88132-awk-sed-script-read-values-parameter-files.html#post302255121 Since there were no responses on the parent thread since it got resolved partially i thought to open the new... (4 Replies)
Discussion started by: rajan_san
4 Replies
Login or Register to Ask a Question