Jump to content
Macro Express Forums

danm

Members
  • Posts

    1
  • Joined

  • Last visited

danm's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Hello Forum, I just recently discovered this excellent tool and have a rather complex requirement that I'm hoping it can handle. I need to loop through all lines of a pipe-delimited text file. The goal is to parse out each of the 6 data fields per line, insert each of those 6 data fields into an interface, go to the next line, and repeat. The pipe-delimited text file includes a Header and would look like this: PersonID|FirstName|LastName|Age|Gender|Active P0100|John|Smith|20|M|Y P0200|Ashley|Williams|21|F|Y P0300|Robert|Adams|37|M|Y I started playing around with the "Text File Begin/End Process" command but wasn't able to get very far. I should be able to handle the steps for navigating to the interface field and inserting the data, but I'm stuck on how to read the file and assign each field to a variable that can be inserted. I greatly appreciate your help! Thanks
×
×
  • Create New...