DataMystic

Hello,

I have a text file that I need a little help in rearranging. Here is the sample.

"00000", "Issue NOV, 2003", "Circle No: 120", "2 of 02 Responses", "Dave Arnold", "Harrington", "Inst Div", "Box 123456", "Pittsburghl", "MN", "55164", "UNITED STATES"
"Name","Title","Street","Address2","City","State","Zip","Country","Phone","Fax","Email","Codes"
"S WOLFF", "WOLFF GROUP", "", "5 BLOSSOM RD", "PLAISTOW", "NH", "03865", "UNITED STATES", "(000) 000-0000", "", "", ""
"LARRY PENNY", "EAST HAMPTON TOWN", "SUITE 107", "300 PANTIGO PLACE", "EAST HAMPTON", "NY", "11937", "UNITED STATES", "(631) 324-0496", "(631) 324-1476", "", ""
"00000", "Issue NOV, 2003", "Circle No: 12", "2 of 02 Responses", "Dave Arnold", "Harrington", "Inst Div", "Box 123456", "Pittsburghl", "MN", "55164", "UNITED STATES"
"LARRY PENNY", "EAST HAMPTON TOWN", "SUITE 107", "300 PANTIGO PLACE", "EAST HAMPTON", "NY", "11937", "UNITED STATES", "(631) 324-0496", "(631) 324-1476", "", ""
"JOHN WOODWARD", "J&W CONSULTING", "PO BOX 343", "104 S OGDON ST", "OSSIAN", "IN", "46777", "UNITED STATES", "(219) 622-4393", "( ) -", "", ""

I can remove the row title line "Name","Title","Street"... easily enough. What I want to do is to pull the "00000", "Issue NOV, 2003", "Circle No: 12" fields and put on the next x lines. The number of lines will vary.

Any help would be apprieciated.

David Arnold

Hi David,

Try the filter
vbscript\find text and then include it on every line.fll

You'll need to use a Restrict to lines filter to capture matching 'heading' lines.