Jump to content
Macro Express Forums

Change Lower Case To Upper Case


Recommended Posts

My macro copy this city name ballerup into T7


In another program it text type TRF.DEN.%T7%


But this program want the city name with the first letter in upper case like this Ballerup.


Is there a function that can change the first letter in T7 from lower to upper??


T7 can have many dif. city names.

some are with the first letter as upper and some with lower.

So this function should determine and change if it's lower.

Link to comment
Share on other sites

Hi koden


I dont have a sollution for the lower or uppercase i ME but perhaps this could help you instead. If you have a list of the citynames, maybe you could import this to excel and use the function INITIAL, then use you're (T7) macro to text type it from excel into the other program. Just don't forget to copy the result in excel from the B-column and paste it into the C-column, use paste special and value, this is just to get rid off the formula in the B-column.


I hope this can help.

Link to comment
Share on other sites

There is not a specific command to change the first letter to upper case. However, you can use existing macro commands to accomplish the same thing. Something like this may work.

// Copy the first letter of T1 into T91
Variable Modify String: Copy Part of %T1% to %T91%
// Set the first letter contained in T91 to upper case
Variable Modify String: Uppercase %T91%
// Copy from the second letter through the 99999999th letter
Variable Modify String: Copy Part of %T1% to %T92%
// Overwrite T1 with the T91 and T92
Variable Set String %T1% "%T91%%T92%"

You will, however, have to write additional macro commands to determine when to leave the first letter lower-case.

Link to comment
Share on other sites

Another problem in same fields...


The program where i paste TRF.Den.%T7% won't accet this.


I have to paste the full text TRF.Den.Ballerup before it accept.




I have a set variabel string T8 > TRF.Den.


I copy the city name into T7. The city name can be several city names.

In this example I use Ballerup.


Then I need to modify T8 so it will end out with TRF.Den.Ballerup

(modify T8 with T7 at the end of T8, and then use T8 to paste in my program)


But how do I do that and which modify command do I use??

Right trim??

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...