Loop Script for .txt files

[evansabres]

I have roughly 120 .txt files in a folder, each with three fields,'Name,' 'Male' and 'Female'

I want to load all 120 files into an application.

I have done a loop script for an excel file with multiple sheets, but not for .txt files.

What is the syntax for this script.

Thank you

[m_woolf]

why use a loop?

Load Path\*.txt

.......

[evansabres]

What would the structure of the script look like to load all of the files in the folder?

[Anonymous · Accepted solution]

Something like this.

Load

Name,

Male,

Female

From YourFIlePath\YourFolder\*.txt;

Use the wizard to pull in one and change your From string to end with *.txt