Import Text (Names) - Engraving Etc. Forum

<body> <h1>Full Version: <a href="https://www.engravingetc.org:443/archive/index.php?webtag=EE&msg=4435.10">Import Text (Names)</a></h1><a name="a4435_10"></a><p><b>From: Dave Jones (DAVERJ)</b> [<a href="lmessages.php?webtag=EE&msg=4435.10">#10</a>]<br /> 1 Aug 2006<br /><b>To: logojohn</b> [<a href="lmessages.php?webtag=EE&msg=4435.9">#9</a>] 1 Aug 2006</p> <div class="quotetext" id="quote"><b>quote: </b></div><div class="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....</div><br /> <br /> Sounds like a good place for a macro. <span class="e_wink" title=";-)"><span class="e__">;-)</span> </span><hr /><a name="a4435_11"></a><p><b>From: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4435.11">#11</a>]<br /> 1 Aug 2006<br /><b>To: Dave Jones (DAVERJ)</b> [<a href="lmessages.php?webtag=EE&msg=4435.10">#10</a>] 1 Aug 2006</p> 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. <hr /><a name="a4435_12"></a><p><b>From: logojohn</b> [<a href="lmessages.php?webtag=EE&msg=4435.12">#12</a>]<br /> 1 Aug 2006<br /><b>To: Dave Jones (DAVERJ)</b> [<a href="lmessages.php?webtag=EE&msg=4435.10">#10</a>] 1 Aug 2006</p> Even I thought that was a stretch.<br /> Luckily it doesn't happen real often, mostly names on a sports team so there are usually under 20.<br /> <br /> Corel x3 can change the case.<br /> <br /> <br /> . <hr /><a name="a4435_13"></a><p><b>From: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4435.13">#13</a>]<br /> 1 Aug 2006<br /><b>To: logojohn</b> [<a href="lmessages.php?webtag=EE&msg=4435.9">#9</a>] 1 Aug 2006</p> LogoJohn;<br /> <br /> So your satisfied with the way the Cut-n-Paste macro works? Have you tried it in v12 and X3? <hr /><a name="a4435_14"></a><p><b>From: logojohn</b> [<a href="lmessages.php?webtag=EE&msg=4435.14">#14</a>]<br /> 1 Aug 2006<br /><b>To: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4435.11">#11</a>] 1 Aug 2006</p> I have copied and pasted a whole excel column to a different place before processing. Worked pretty good.<br /> <br /> I really meant the times where it is just typed in a single column like they did before computers.<br /> <br /> Lastname, Firstname I.<br /> <br /> . <hr /><a name="a4435_15"></a><p><b>From: logojohn</b> [<a href="lmessages.php?webtag=EE&msg=4435.15">#15</a>]<br /> 1 Aug 2006<br /><b>To: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4435.13">#13</a>] 1 Aug 2006</p> <div class="quotetext" id="quote"><b>quote: </b></div><div class="quote">So your satisfied with the way the Cut-n-Paste macro works? Have you tried it in v12 and X3?</div><br /> <br /> <br /> It works great in ver 11 and x3.<br /> <br /> .<p class="edit_text">EDITED: 1 Aug 2006 by LOGOJOHN</p> <hr /><a name="a4435_16"></a><p><b>From: MR C (MOSHE)</b> [<a href="lmessages.php?webtag=EE&msg=4435.16">#16</a>]<br /> 1 Aug 2006<br /><b>To: Dave Jones (DAVERJ)</b> [<a href="lmessages.php?webtag=EE&msg=4435.10">#10</a>] 1 Aug 2006</p> <p>If a customer calls and wants to come in, I ask them to first email the text.</p> <p>If a customer is in the shop, I ask them to email the file when they get back to their computer</p> <p>I tell them that it is more accurate, there is no room for typos</p> <p>If a customer is in a rush, I have them email the text. <br /> If we are too busy and they are in a big rush, I have them type it on the front computer.</p> <p>It is very easy to convert all caps to caps and small in the Xenetech or in Word</p><hr /><a name="a4435_17"></a><p><b>From: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4435.17">#17</a>]<br /> 1 Aug 2006<br /><b>To: logojohn</b> [<a href="lmessages.php?webtag=EE&msg=4435.15">#15</a>] 1 Aug 2006</p> <div class="quotetext" id="quote"><b>quote: </b></div><div class="quote">It works great in ver 11 and x3.</div><br /> <br /> And it was developed on v12.<br /> <br /> 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. <hr /><a name="a4435_18"></a><p><b>From: Mike (MIKEN)</b> [<a href="lmessages.php?webtag=EE&msg=4435.18">#18</a>]<br /> 2 Aug 2006<br /><b>To: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4435.17">#17</a>] 3 Aug 2006</p> Carl:<br /> <br /> Just got around to trying your import text macro--by necessity--I might add.<br /> <br /> If you want to know how it worked--next time you're in St. Louie dinner's on me.<br /> <br /> Thanks very much. <hr /><a name="a4435_19"></a><p><b>From: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4435.19">#19</a>]<br /> 3 Aug 2006<br /><b>To: Mike (MIKEN)</b> [<a href="lmessages.php?webtag=EE&msg=4435.18">#18</a>] 3 Aug 2006</p> Excellent. You're very welcome. Thanks for the feedback.<br /> <br /> 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? ;^) <hr /><a name="a4435_20"></a><p><b>From: Mike (MIKEN)</b> [<a href="lmessages.php?webtag=EE&msg=4435.20">#20</a>]<br /> 3 Aug 2006<br /><b>To: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4435.19">#19</a>] 3 Aug 2006</p> Carl:<br /> <br /> I'm more of a good food, old clothes guy. <hr /><p align="center">Show messages: <a href="lmessages.php?webtag=EE&msg=4435.1">All</a>  <a href="lmessages.php?webtag=EE&msg=4435.1">1-9</a>  10-20</p> <h4><a href="lthread_list.php?webtag=EE">Back to thread list</a> | <a href="llogout.php?webtag=EE">Login</a></h4> <h6>© 2025 <a href="http://www.beehiveforum.net/" target="_blank">Project Beehive Forum</a></h6> </body>