awk to store in a list the values of certain fileds
Dear Group,
I have following input:
first line contains the headers!
I want to create with one pass the following output:
tried following one liner with partial success:
I cannot read and add the 'ma mb mc md me'! The second part:
works as expected. It does produce the following output:
In the first part:
I locate the position of the field 'period' in order to check which fields have to be considered till the end of the record. The number of fields after 'period' can vary!
Thanks for your help.
Moderator's Comments:
Please use code tags next time for your code and data. Thanks
Hi,
Is is possible to get the value using shell script?
x=1
y1 = 10
y2 = 15
y3 = 7
echo $y$x is giving y1 (variable name)
but I need the value of y1 (i.e. 10 dynamically)
Is there any solution?
if so, please mail me at kkodava@maxis.com.my
... (2 Replies)
Hi all.
Well, I have the next code:
I need to make an array with the values I have in the bucle, but just don't get it...
Question is, how can I store in an array that values, and how can I display them with echo? (8 Replies)
Hi,
How to store the values in array from output result,
EG:
I have the result like this,
ps, google, 1.txt, 1
sam, google, 2.txt, 2
These are the four values followed by comma in two sets. I need to store these values set by set. One set contains four values followed by comma.
... (2 Replies)
I am reading a value from a file and want to store the value in a dynamic array as i don't know the number of occurrences of the value in that file.
How can i do that and then later fetch that value from array (25 Replies)
I have following text:
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE , ONLINE , ONLINE , ONLINE
STATE=ONLINE on host1, ONLINE on host2, ONLINE on host3, ONLINE on host4
NAME=ora.LISTENER_1525.lsnr
TYPE=ora.listener.type
TARGET=ONLINE ... (2 Replies)
Hello together!
I have a list like this
1 3
2 5
3 7
4 2
Now I want to take the average of the second column and multiply it by the difference of the first and last value of the first column.
I posted an similar thread, but now I wonder how I can tell awk in an easy way to take specific... (2 Replies)
This is what I was trying but failed to do so need help.
cat 1.sql | awk '{printf("%s",NR%4 ? $0",":$0"\n")}'
Output :-
I want to add 2 more values for each line (hostname,user name) so the output should have hostname & username (testsrv01,test1)
Output should be like... (4 Replies)
Hi everyone,
This is an exemple of inpout.txt file (a "," delimited text file which can be open as csv file):
ID, Code, Value, Store SP|01, AABBCDE, 15, 3 SP|01, AABBCDE, 14, 2 SP|01, AABBCDF, 13, 2 SP|01, AABBCDE, 16, 3 SP|02, AABBCED, 15, 2 SP|01, AABBCDF, 12, 3 SP|01, AABBCDD,... (1 Reply)