hello,
i need some help.
does anyone know how to remove "{ }" from the array output from a "collector"?
when saving array output of the collector to file, those {}s are coming along with the data, so
i can't use the saved data with "MS Excel".
thank you in advance.
yoshihiko
Those brackets are not being added by the collector, but are instead almost certainly part of the data that you are feeding to the collector. Trace the data path back to the source and you'll find where they come from. Or go the other direction: collectors don't write data to a file, so trace the collector output to where your file is being written and then look at the formatting specified in the WRITE transaction(s). Although, if your data is text as I suspect, then formatting later won't help and I'm back to the original suggestion: trace back to where the data is created. If you are collecting text then fix this by collecting numeric data so that you can later write in any format you like. Another possibility is that the data is in the form of a record, in which case the brackets aren't part of the data at all- but are rather an artifact of how the data is displayed or written. In which case "plan b" is the way to go- format the data as you like when it gets written to the file.
Bottom line though- the brackets are not related to the collector, though may or may not be part of the data itself. You need to look elsewhere in your program.
Stan