Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here




Where my wife works they take name lists from colleges and develop them for printing diplomas...importing them into Quark Express v4.0 as *.txt name lists.  Some of them come in tables in Word97...which of course break down too much and come in with formatting all messed up when you convert them to .txt files.  They need to come in as "Bob Gene Allen" and so on all on separate lines...they come in with each name on separate lines...and if the person didn't have a middle name that even messes it up more.  
With a group like this there are sure to be folks for whom this is a cakewalk.  For my inexperienced mind it's a catwalk.
I'm trying to edit the nonprintable characters BEFORE conversion to .txt files to see if I can enable the transition to straighten up like I need.
Meanwhile, I'll monitor this thread and see if someone can sew this up for me...and post the same thread in the Quark forum.  

RE: Word97

It sounds like you are trying to import ASCII text files into Quark that are delimited by different characters.  Some may be delimited by commas, some by quotes and others by tabs.  You need to get all of these text files into the same ASCII delimited format.  This may be a chore, especially at first.  Probably the easiest was is to either require (or request) that each college submit theirs in the same format, like maybe Excel, and then convert those  for use with Quark.
Well, that's for the future.  Meanwhile, lets solve you immediate problem.

Probably the easiest way to go about this is:
1. Copy and paste all Word lists into Excel.  They should paste without loss, especially if you match the columns before you copy them.  (The columns only need to match in quantity not in width.)
2. Any other text files can be imported into Excel and then copy/pasted onto your master sheet.
3. Export the files from your Excel sheet to a format that Quark likes.

Let me know if this works.


RE: Word97

Your tip was right on the money...there's still a little cleaning up to do, but it's a much better result than what I was getting.
As for getting the colleges to comply with what we need...that's one of those situations that breaks down into WE work for THEM...so they expect US to comply with what THEY send.  (If we want their business) Some of them even send them in as .eps/Mac files and the translation better not get lost along the way.
Actually, much progress HAS been made in the last several years as far as getting them to standardize...some of them actually even use the templates provided.
Where the rubber meets the road, though, is when you introduce the deadlines into the equation...and if they're late with their name list in the first place, you wind up going WAH WAH and getting it done the best you can.
That'll be accomplished easier with your suggestion.       A thousand thanks!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close