Pulling infor from one line and putting it in front

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
davidmarnold

Pulling infor from one line and putting it in front

Post by davidmarnold »

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
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Post by DataMystic Support »

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.
Post Reply