I'm having a problem with the way awk is interperting a space between double quotes in a for loop. Below is the code and output from running the script:
AWK for loop:
for i in $(awk 'BEGIN{FS=","}{print "Probe Name:" $1};{print "Probe Temp:" $2};{
print "\n--------------------------------"}' < "edgewater-temps.csv" )
do
echo $i
done
it's a not 'awk' introducing an issue here - it's the surrounding 'for' loop parsing the output from 'awk'.
The 'for' loop iterates through through the list (specified in the 'in' clause) using the InternalFieldSeparator (aka IFS). By default the IFS is set to space, tab and new-line.
Your awk produces lines with the embedded spaces 'Probe Name' and 'Probe Temp'. The 'for' loop treats those embedded space and field separators - therefore you get new lines with your 'echo'.
You can either change your awk removing the embedded spaces from its output like so 'Probe Name' -> 'ProbeName' and leave the rest of the code unchanged.
Reset the IFS to something that you wouldn't expect from awk's output. Something along these lines:
BTW, why are you printing the '\n---' in awk? Would it be more intuitive to do it in the wrapper loop AFTER the 'echo' is done?
The alternative would be to do it all in shell
Pick your poison! (as someone recently said).
Hello;
I have a simple loop filtering a log:
for LU in $(< LU-list-Final)
do
OUT=$(grep -B1 $LU cibc-src-ip.cap |egrep 'IP 16|IP 19|IP 15' |awk -F">" '{print $1}')
if ; then
echo " LU $LU was accessed by ===============> $OUT "
echo ""
fi
done
The current output snippet looks like... (2 Replies)
Hi,
I was trying to dos2unix a file that has some special characters but dos2unix converted those into different format. I am working on sun server.
I guess the default for dos2unix on sun server is ISO format .
Can i change the format so that it does the conversion in UTF format?
Because I... (3 Replies)
Hello; having an annoying issue:
I wish to have the same formatting in:
awk '{print $1}' LOCAL
f30f31be17a236378ac896639cc1b996
bff4c460f601444db6ef7f6ad6ca44b9
347a399b6fe9c2f21e6a7f55911c1483
ce3f8fdd4919e891090ca27872f4f983
c00098663f064d14065d0ef248a4db44... (2 Replies)
Hi,
I was trying to format my number like i=1 to 000001 using the below method.
typeset -Z6 i (sorry, corrected)
My shell is K, is not doing, it is supposed to do
Thanks in advance (6 Replies)
I want the following output:
User ID: 4071
Last Name: Gills
First Name: Roberts
Address: Maple Dr.
Phone#: 702346789
from this command:
grep "$uId" database.txt | awk -F":" '{print "User ID:\t"$uId"\nLast Name:\t"$lname"\n...etc. }'
But all I get is this:
User ID:... (3 Replies)
I would like to keep the complete lines in the output, but my script adds carriage returns for each space (e.g. keep BRITISH AIRWAYS on one line in the output):
File1=
BAW
BRITISH AIRWAYS
RYR
RYAN AIR
for i in $(cat File1)
do
echo $i
done
Output:
BAW
BRITISH
AIRWAYS
RYR... (4 Replies)
Hi
Suppose we have a file consisting of nos in following format
123 - 789
123 - 828
345 - 989
345 - 792
I require the following output
123, 789,828
345, 989,792
Means Unique nos in 1st Column and Corresponding two nos in comma separated 2nd Column
Please help me out... (6 Replies)
I am facing a very challenging task here but can't finish it.I request all of you to help me please.
I have one file which contain some data i need to format it.
data file contain data like
54321|item-68|owner|yes||||$
00-10|invoice|3221|||#
00-11|invoice|3221|||#... (1 Reply)