Manipulate TEXT file based on Quantity

  • Manipulate TEXT file based on Quantity - I have a text file that I use as a database file to print labels. In this file one row might have 1500 as quantity. I need to then convert this single line to 3 lines as the product comes as 500 in a box so I need 3 labels (one for each box)
    Some rows would need editing some would not.
    I have a spreadsheet with the quantities that are in each product code - is there a way to compose a lookup and amend lines where required?

  • @Stiller-Supervisor

    at lest for me this is confusing. Maybe you wanna clarify what you want to achieve.
    An example is always welcome.


Log in to reply