Need comand or script for append text after searching for the desired string


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need comand or script for append text after searching for the desired string
# 15  
Old 07-30-2014
hi Rudic,
please find the below input file
Code:
   47.85,10
   0124,42.35,8
   0125

My output should be

Code:
amount 0124:42.35
amount 0125: 0.00
count 0124 : 8
count 0125 : 0

# 16  
Old 07-30-2014
What about your specification in post#7? And where are the totals?
# 17  
Old 07-30-2014
sorry ... rest of all the things are same....
Code:
 amount  0124:42.35
 amount  0125:0.0
   count  0124 : 8
   Count  0125: 0
  total amount :42.35
  total count : 8

# 18  
Old 07-30-2014
Try this:
Code:
awk -F, 'NF==2  {next}
                {ITM[++c]=$1
                 AMT[c]=$2+0
                 CNT[c]=$3+0
                 TOTA+=$2
                 TOTC+=$3}
         END    {for (i=1;i<=c;i++) print "amount " ITM[i] ":" AMT[i]
                 for (i=1;i<=c;i++) print " count " ITM[i] ":" CNT[i]
                 print "total amount:" TOTA
                 print "total count:" TOTC}
        ' file
amount    0124:42.35
amount    0125:0
 count    0124:8
 count    0125:0
total amount:42.35
total count:8

This User Gave Thanks to RudiC For This Post:
# 19  
Old 07-30-2014
u Rocked man.... thanks for helping me from the starting ... due to you iam getting kinda knowledge in unix....

Rudic... one more help do u have any idea on SFTP from windows to unix...?
# 20  
Old 07-30-2014
I've seen your other thread - please give way more details and provide some attempts that you have done.
# 21  
Old 07-30-2014
actually i dnt have idea on this SFTP

wat i did is

i had the windows remote path and unix path
so at first i checked for the existing file in the widows server using if statement...

after that i dnt have any idea on this SFTP i googled it but i dnt get any exact solution for this thing... i know that i did nothing ... but i have no idea on how to kick start this..... SmilieSmilieSmilie

---------- Post updated at 11:58 AM ---------- Previous update was at 11:54 AM ----------

i had something on my mind like this...
Code:
sftp ${REMOTE_USER}@${REMOTE_MACHINE} <<EOF
cd ${REMOTE_DIR}
if [[ -f "$REMOTE_DIR"/"$FILE_NAME_TO_CHECK" ]]; then     
    get *

then how to move this to the unix local path...?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Needed shell script to append desired text to each line in a file

Hi, I had generated a report in my tool as followsoutput.txt 43.35 9 i needed the script to generate a new file like below i want to append the text to each of these lines of my filenewoutputfile.txt should be Total Amount : 43.35 Record Count:9 Regards, Vasa Saikumar. ... (2 Replies)
Discussion started by: hemanthsaikumar
2 Replies

2. Shell Programming and Scripting

sed - Find a String and append a text end of the Line

Hi, I have a File, which have multiple rows. Like below 123456 Test1 FNAME JRW#$% PB MO Approver XXXXXX. YYYY 123457 Test2 FNAME JRW#$% PB MO Super XXXXXX. YYYY 123458 Test3 FNAME JRW#$% PB MO Approver XXXXXX. YYYY I want to search a line which contains PB MO Approver and append... (2 Replies)
Discussion started by: java2006
2 Replies

3. Shell Programming and Scripting

Help Needed! - Cut characters after a text string and append to end of filename

Hi all.. I have several unique files that contain one thing in common, and that is acct#. For all files in the directory, I want to append the 10 characters following the word "ACCOUNT:" to the end of the filename. for example: I have file 111_123 that contains ACCOUNT:ABC1234567 The file... (5 Replies)
Discussion started by: cinderella1
5 Replies

4. Shell Programming and Scripting

Trying to search for a string and append text only once

Hi I am trying to search for a particular occurrence of a string in a file, and if found, append another string to the end of that line. Here is my file contents: column1 userlist default nowrite=3 output=4 column2 access default nowrite=3 Here is the code: A="user=1... (1 Reply)
Discussion started by: bludhemn
1 Replies

5. Shell Programming and Scripting

Searching for a particular string and modifying text within block of data

Hi Forum. Is there a quick way to do the following search/replace within a block of data? I tried to google the solution but didn't really know what to look for. I have the following text file (I want to search for a particular string "s_m_f_acct_txn_daily_a1" and replace the... (5 Replies)
Discussion started by: pchang
5 Replies

6. Shell Programming and Scripting

searching a text string for n'th :

hello, i'm a novice on bsh scripting so thanks for any help here basically i have a shell var $x that looks like this > echo $x nabc1234:!:73394:17155:Gary Mason:/home/garym:/bin/ksh and i'm trying to keep the first 8 characters and the text from the 4th : to the 5th : i've been trying... (9 Replies)
Discussion started by: sasglm
9 Replies

7. Shell Programming and Scripting

String searching and output to a file in a formatted text

Hi, I'm very new to UNIX scripting and find quite difficult to understand simple UNIX syntax. Really appreciat if somebody could help me to give simple codes for my below problems:- 1) I need to search for a string "TTOH 8031950001" in a files which filename will be "*host*'. For example, the... (3 Replies)
Discussion started by: cuji
3 Replies

8. Shell Programming and Scripting

Search a string and append text after the string

Hi, I have a file like this... <o t="Batch" id="8410" p="/" g="32"> <a n="name"> <v s="DBBA1MM"/> </a> <a n="owner"> <v r="/Administrator"/> </a> <a n="rights"> <v s="95"/> </a> <a n="debugLevel"> <v s="3"/> </a> <a n="avsStoreLoc"> <v... (8 Replies)
Discussion started by: kesu2k
8 Replies

9. Shell Programming and Scripting

PERL: Searching for a string in a text file problem

Looking for a bit of help. I need to search for a string of words, but unfortunately these words are located on separate lines. for example the text output is: United Chanmpions Ronaldo Liverpool Losers Torres and my script code is print("DEBUG - checking file message"); while... (15 Replies)
Discussion started by: meevagh
15 Replies

10. UNIX for Dummies Questions & Answers

Hi! Searching for a text string in UNIX

Hi! I'm new here and glad to meet everyone! I've been wrestling with a problem lately however! How do I recursively (recursive means to keep going through the subdirectories until no more are there) search a bunch of textfiles in a long directory structure for a specific string.. but only... (1 Reply)
Discussion started by: skwadim
1 Replies
Login or Register to Ask a Question