My data is like this
Column1 Column2 Column3 Total
I am using the below command
|foreach Column* [ eval Answer <> = Total - <> ]
|table Column1, Column2, Column3 Answer1, Answer2, Answer3
but I getting the below error
Error in 'foreach' command: The last argument must be a search pipeline
Kindly Help me with this issue.
Try this
host=1 | tabel Column* Total
| foreach Column* [ eval Answer<<MATCHSTR>>=Total-<<FIELD>>]
Try this
host=1 | tabel Column* Total
| foreach Column* [ eval Answer<<MATCHSTR>>=Total-<<FIELD>>]
I am still getting the error as given below,
No results found.
Try this
host=1 | tabel Column* Total
| foreach Column* [ | eval "Answer<<MATCHSTR>>"=Total-'<<FIELD>>']
Thanks a lot for your support but still getting the same error.
Strange. The same syntax works for me. See this runanywhere search.
| gentimes start=-1 | eval Column1=10 | eval Column2=20 | eval Column3=30 | table Column* | addtotals
| foreach Column* [eval "Answer<<MATCHSTR>>"=Total-'<<FIELD>>']
If above works for you, please check closely if there is syntax error on your side (no extra space or anything).
Yes your code is working just fine, but I am still stuck. I will share the code which I am using,Please guide me if there is any error in that.
When I am using below command it is showing data.
| table V* Voice
V1 V2 V3 Voice
1000 0 0 1000
1000 0 0 1200
1000 0 0 1300
But after the below command it is showing no results.
| table V* Voice
| foreach V* [ eval "Answer<>"=Voice-'<>']
No Results