- Excel Desktop Client new !
Often a User will need to distill a vast set of data into a few essential findings.
Here we give a few examples of this process.
At present, EASA needs to have output files from software applications be ASCII text files in order to extract desired data. If a software application produces only binary format output files, then an intermediate process that runs a post-processing application will be required to produce the necessary text files.
Once output text files containing the desired information have been produced by processes running software applications, this information can be extracted from the files using the EXTRACT in combination with FIND and REPEAT. By using a DATA PROCESSING under the OUTPUT branch, these objects can be added and defined under the LIST sub-branch. Once the desired data has been extracted from the output files, you can process and reduce this information further into more desirable forms using other data processing objects, such as the COMPUTE, STATISTICS, GET VALUE and CUT.
In this example, the goal will be to extract two numbers from an output text file, the minimum and maximum pressure values. Part of the output file, output.dat, is shown below with a black arrow pointing to the line containing the desired data.
The strategy will be to first locate a unique text string just above the line containing the desired data, and then extract the two numbers of interest. This two-step approach eliminates the possibility of finding the wrong match earlier in the file. The steps for accomplishing this type of data extraction are as follows:
Only single spaces are used between the different words and characters in the Value: parameter, even though there is actually more white space in the file as shown in the figure above.
The result of this example will be that the numbers, -23.8 and 44.5, will be stored under the object names, pmin and pmax.
In this second example, the goals will be to extract columns of node displacement data from an output file called ‘plate.out’ and then to determine the maximum displacement value. The relevant section of this file is shown below.
The steps for accomplishing a multiple line data extraction are as follows: