We help IT Professionals succeed at work.
Get Started

Output Control

faithless1
faithless1 asked
on
341 Views
Last Modified: 2012-05-11
Hello,

I have a tab delimited file containing following example records (no specific characters or row length)

word word word word word word
word word
word word word word
word word word word word
word word word
word

I'm looking for a way to only output 3 words per line. If a line contains more than 3 words, move the rest to a new line. In case a line contains 5 words and 2 words are moved to a new line, then any line with one word in the original file should be appended at the end or beginning of the line to make a 3 word record. In case there is 1 record, then any line from the original file containing 2 words should be appended. In case there are not enough 1 or 2 word records left then ANY 1 or 2 word combinations from either the original or the new file can be appended.

Thank you!
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE