Forum Discussion
tristaanogre
15 years agoEsteemed Contributor
What I would suggest is using a different separator to separate "fields" in your CSV so that the first "field" is the order number and the second "field" is the product designators. Something like the following:
In the above example, the two fields are separated by a comma. The second field is actually two records separated by a semi-colon. Each record is then separated into it's individual components by the vertical pipes.
Your DDT loop will then operate on the CSV file and return the two fields. You'll then need to use the List Item methods of the aqString object to first parse out the two different records using the semi colon and then parse out the components of the records using the vertical pipe.
Check out the article on aqString.GetListItem found here http://smartbear.com/support/viewarticle/13275/
"Ord1","Product1|Size1|Qty1;Product2|Size2|Qty2"
In the above example, the two fields are separated by a comma. The second field is actually two records separated by a semi-colon. Each record is then separated into it's individual components by the vertical pipes.
Your DDT loop will then operate on the CSV file and return the two fields. You'll then need to use the List Item methods of the aqString object to first parse out the two different records using the semi colon and then parse out the components of the records using the vertical pipe.
Check out the article on aqString.GetListItem found here http://smartbear.com/support/viewarticle/13275/