Pulling infor from one line and putting it in front

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

davidmarnold

Pulling infor from one line and putting it in front

Postby davidmarnold » Thu May 13, 2004 8:24 am

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: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Postby DataMystic Support » Mon May 17, 2004 12:44 pm

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 3 guests