need a help in shell scripting

chandrakala · #1 (**permalink**) 03-19-2009

Hi Folks,
I need a help in shell scripting.

I have a CSV file which got 1000 records in it..here it goes

KRW71,GAMDE1,D,14656,17909.5,20090217,48324,20090202,22060,K,23897,,,,2,Truck,27.2,,,O,T
KRW71,GAMDE1,D,14656,17909.5,20090217,48325,20090203,22060,K,10430,,,,1,Truck,13.6,,,O,T
KRW71,GAMDE1,D,14656,17909.5,20090217,48326,20090204,22060,K,20376,,,,2,Truck,27.2,,,O,T
KRW71,GAMDE1,D,14656,17909.5,20090217,48327,20090205,22060,K,19338,,,,1,Truck,13.6,,,O,T
KRW71,GAMDE1,D,14656,17909.5,20090217,48328,20090206,22060,K,20682,,,,1,Truck,13.6,,,O,T

I want to add a tag FBINV at the beginning of each line if its not present already.

Can you please help me out in writing a script for above one.

Any help would be apptreciated.

Thanks in advance

dariyoosh · #2 (**permalink**) 03-19-2009

Hello there,

I think that the following KornShell script does the job

Code:

#!/bin/ksh

RESULT=""
TARGET_TOKEN="FBINV,"

while read LINE
do
    if [[ $LINE = TARGET_TOKEN* ]]
    then
        RESULT="$RESULT$LINE\n"
    else
        RESULT="$RESULT$TARGET_TOKEN$LINE\n"
    fi
done < $1

RESULT="$RESULT\n"
print "$RESULT" > $1

Regards,

sunpraveen · #3 (**permalink**) 03-19-2009

Try this:

Code:

cat filename | while read line
do
  fbinv_cnt=$(echo ${line} | grep -i "FBINV" | wc -l)
  if [[ ${fbinv_cnt} -eq 0 ]]; then
    line=$(echo "FBINV,${line}")
  fi
  echo ${line} >> outputfile.csv
done

HTH,

Regards,

Praveen

ghostdog74 · #4 (**permalink**) 03-19-2009

Code:

# awk '!/^FBINV/{print "FBINV,"$0}' file
FBINV,KRW71,GAMDE1,D,14656,17909.5,20090217,48324,20090202,22060,K,23897,,,,2,Truck,27.2,,,O,T
FBINV,KRW71,GAMDE1,D,14656,17909.5,20090217,48325,20090203,22060,K,10430,,,,1,Truck,13.6,,,O,T
FBINV,KRW71,GAMDE1,D,14656,17909.5,20090217,48326,20090204,22060,K,20376,,,,2,Truck,27.2,,,O,T
FBINV,KRW71,GAMDE1,D,14656,17909.5,20090217,48327,20090205,22060,K,19338,,,,1,Truck,13.6,,,O,T
FBINV,KRW71,GAMDE1,D,14656,17909.5,20090217,48328,20090206,22060,K,20682,,,,1,Truck,13.6,,,O,T

chandrakala · #5 (**permalink**) 03-19-2009

Its working dariyoosh.

Many thanks.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
shell scripting	vijray27	Shell Programming and Scripting	4	02-27-2009 09:44 AM
Shell scripting	jack00423	Shell Programming and Scripting	1	09-30-2008 12:48 AM
difference between AIX shell scripting and Unix shell scripting.	haroonec	Shell Programming and Scripting	2	04-12-2006 08:12 AM
Shell scripting	dipanrc	Shell Programming and Scripting	4	10-27-2005 03:53 AM
something else on shell scripting	master_6ez	Shell Programming and Scripting	1	11-21-2004 11:42 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: