Multiple Text File To Table

[John]

Any idea how to search specific strings inside a multiple text file and then convert this into a table??

Sample Output

File name | String 1 | String 2 | String 3 | String 4

A.txt          | A.1         |  A.2        | A.3          | A.4

B.txt          | B.1         | B.2          | B.3          | B.4 

[David Boot-Olazabal]

Hi John,

I'm not quite sure what is meant by a specific search string in multiple text files. Are you looking for:

• one search pattern across multiple files?
• multiple search patters for all files?

It looks like this may be possible with the help of TERR or Python code. The loading of multiple txt files into Spotfire, based upon a specific search pattern throughout all files, is doable with TERR (see also your other question https://community.spotfire.com/forums/topic/16230-text-file-to-data-table/#comment-44885).

Depending on what you are looking for, and the number of files to search through, it may also be an option to duplicate the code and change the search pattern for each loop you do. 

You can find some examples of Python code here.

Kind regards,

David