Full Version: Import Text (Names)

From: Dave Jones (DAVERJ) [#10]
 1 Aug 2006
To: logojohn [#9] 1 Aug 2006

quote:
For example if someone sends you a list and it is Lastname, Firstname, and an initial they don't want and they want it lasered in all caps and the list is Upper/Lower....


Sounds like a good place for a macro. ;-) 

From: Carl (CSEWELL) [#11]
 1 Aug 2006
To: Dave Jones (DAVERJ) [#10] 1 Aug 2006

Naw, you could probably do it quicker by importing it into Excel as comma delimited file, deleting the middle initial column, changing the column order, and converting all to upper-case. Far too easy for a macro.

From: logojohn [#12]
 1 Aug 2006
To: Dave Jones (DAVERJ) [#10] 1 Aug 2006

Even I thought that was a stretch.
Luckily it doesn't happen real often, mostly names on a sports team so there are usually under 20.

Corel x3 can change the case.


.

From: Carl (CSEWELL) [#13]
 1 Aug 2006
To: logojohn [#9] 1 Aug 2006

LogoJohn;

So your satisfied with the way the Cut-n-Paste macro works? Have you tried it in v12 and X3?

From: logojohn [#14]
 1 Aug 2006
To: Carl (CSEWELL) [#11] 1 Aug 2006

I have copied and pasted a whole excel column to a different place before processing. Worked pretty good.

I really meant the times where it is just typed in a single column like they did before computers.

Lastname, Firstname I.

.

From: logojohn [#15]
 1 Aug 2006
To: Carl (CSEWELL) [#13] 1 Aug 2006

quote:
So your satisfied with the way the Cut-n-Paste macro works? Have you tried it in v12 and X3?



It works great in ver 11 and x3.

.

EDITED: 1 Aug 2006 by LOGOJOHN

From: MR C (MOSHE) [#16]
 1 Aug 2006
To: Dave Jones (DAVERJ) [#10] 1 Aug 2006

If a customer calls and wants to come in, I ask them to first email the text.

If a customer is in the shop, I ask them to email the file when they get back to their computer

I tell them that it is more accurate, there is no room for typos

If a customer is in a rush, I have them email the text.
If we are too busy and they are in a big rush, I have them type it on the front computer.

It is very easy to convert all caps to caps and small in the Xenetech or in Word

From: Carl (CSEWELL) [#17]
 1 Aug 2006
To: logojohn [#15] 1 Aug 2006

quote:
It works great in ver 11 and x3.


And it was developed on v12.

Thanks for the excellent idea on which the macro is based! I'll tidy it up a bit and post it for the forum. It's definitely not a replacement for Print Merge, but I think it's a couple of steps closer. If nothing else, it's an improvement over manual methods.

From: Mike (MIKEN) [#18]
 2 Aug 2006
To: Carl (CSEWELL) [#17] 3 Aug 2006

Carl:

Just got around to trying your import text macro--by necessity--I might add.

If you want to know how it worked--next time you're in St. Louie dinner's on me.

Thanks very much.

From: Carl (CSEWELL) [#19]
 3 Aug 2006
To: Mike (MIKEN) [#18] 3 Aug 2006

Excellent. You're very welcome. Thanks for the feedback.

Now, just out of curiosity, would that dinner be McD's, TGI Friday's, or someplace that I'd have to buy new clothes to go to? ;^)

From: Mike (MIKEN) [#20]
 3 Aug 2006
To: Carl (CSEWELL) [#19] 3 Aug 2006

Carl:

I'm more of a good food, old clothes guy.

Show messages: All  1-9  10-20

Back to thread list | Login

© 2024 Project Beehive Forum