I have one file on each machine from which i need to pull data.
Format attached :-
x.x.x.x,definst,DEFP_NEW,Standby,Peer,25000166,2016-12-21-14.06.31,21-12-2016
x.x.x.x,definst1,DEFP*NEW,Standby,main,25000166,2016-12-21-14.06.31,21-12-2016
x.x.x.x,deinst1,DEFP-NEW,Standby,primary,25000166,2016-12-21-14.06.31,21-12-2016
x.x.x.x,defins1,DEFPNEW,Standby,secondary,25000166,2016-12-21-14.06.31,21-12-2016
I want data to be fetched in below mentioned format
Separate data from each line.
I am able to get data if i have one line output but need help to modify the analysis to an extent that it can pull up data from multiple lines if available in output file.
I’m not sure I fully understand what you are trying to achieve? Are you trying to re-order the ‘fields’ that are returned?
That said, the reason your relevance returned “Singular expression refers to non-unique object” is that in its current form, you’ll have to pluralize ‘preceding texts’ and ‘firsts’ like so:
preceding texts of firsts "," of lines of files whose ...
( see Common Relevance Error Messages for useful information on diagnosing/addressing common relevance error messages )
You can also leverage the ‘it without a whose’ form (see https://developer.bigfix.com/relevance/tutorial.html) to maintain singular inspectors (and allow for singular treatment of items in a list):
(preceding text of first "," of it) of lines of files whose ...
This form would then allow you to manipulate each line separately, such as:
(preceding text of first "," of it & "||" & following text of last "," of it) of lines of files whose ...
Thanks Aram for your response.
I was able to use the it clause to get required data.
Thanks again !!
Wish you a very happy 2017 in advance mate !!
