Hi Bryant,
You can use the script below to accomplish your task:
function Test()
{
var driver = DDT.CSVDriver("Path_to_the_CSV_file");
while(!driver.EOF()) {
Log.AppendFolder(driver.Value(0));
var tempCSVPath = Project.Path + "\\Temp.csv";
var file = aqFile.OpenTextFile(tempCSVPath, aqFile.faReadWrite, aqFile.ctUTF8, true);
file.Write(driver.Value(1));
file.Close();
var internalDriver = DDT.CSVDriver(tempCSVPath);
while(!internalDriver.EOF()) {
Log.Message(internalDriver.Value(0), internalDriver.Value(1));
internalDriver.Next();
}
aqFileSystem.DeleteFile(tempCSVPath);
Log.PopLogFolder();
driver.Next();
}
}
The script works with the CSV file that contains the following data:
Item; Associated Entries
Item1; "Entries; Values
Entry1; Value1
Entry2; Value2"
Item2; "Entries, Values
Entry3; Value3
Entry4; Value4
Entry5; Value5"