Jump to content
Macro Express Forums

koden

Members
  • Posts

    248
  • Joined

  • Last visited

Everything posted by koden

  1. Thanks.... variable set integer %N1% from position in %T20% search text BCK and the variable modify string... This I understand... But waht happens in the IVAR command?? And where do I find that? Is this the modify string copy part of command? If yes then I will use: Variable modify string: copy part of text from T20 to T20 Starting at N1 But where to end ?? I can tell that the end always is a time stamp, if that can be used?
  2. hello... I copy some text from a mail into T20 The first 3 or 4 lines I don't need. But I never know how much I don't need. BUT I know that I need all after a job number. This job nr. is BCKXXXXX xxx= a number thats never the same, but BCK is always there. How do I go to/find BCK and copy BCK and all text/numbers after BCK ??? Here you can see the mail: ---------------------------------------------------------------------------------------- Subject: Backup problem - please create trouble ticket oooo oooo Below information is autocollected backup problem information. oooo Please create the appropriate trouble ticket oooo Ticket description should NOT include these lines oooo BCK0036E TSS,tssinf4,2,TOLDSKAT_SQL_translog_tssinf4 Sch: translog Mstr: nbucph2ma Create trouble ticket severity 5 Dont call Storage guard. Failed 1 time(s). 2007/01/22 10:32:21 ------------------------------------------------------------------------------------------- as you can see i don't need all lines that have oooo in front. but i'm not sure that oooo always is there. Can I use COPY PART OF A TEXT ??
  3. OK I got it.. I did not know that Variable Modify String: Trim automaticly is deleting all spaces left and right Thanks...
  4. CODE Replace "0" with "" in %T1% Replace "1" with "" in %T1% Replace "2" with "" in %T1% Replace "3" with "" in %T1% Replace "4" with "" in %T1% Replace "5" with "" in %T1% Replace "6" with "" in %T1% Replace "7" with "" in %T1% Replace "8" with "" in %T1% Replace "9" with "" in %T1% I'm not quit sure what you mean. do you mean that I copy the first number and text into T1 Then i replace 0-9 with "" and I have only text left. But what if there have been only text, and no numbers?? What will macro then do? What about the space between number and text? Space also have not to be copyed...
  5. Thanks a lot...but I can't get it working. I can see what your code is doing, but I would like to understand it :-) If you have the time to explain what the code does with this: firstname middlename1 middlename2 lastname The copy should result in T1 = firstname T2 = middlename1 and 2 T3 = lastname If there is only 1 middlename or none, then T2 should be 1 name or none.
  6. Thanks... Have tried all the suggestions. I have resolved it with double command <alt>e
  7. Thanks again... I love this program which I use every day. I just need a "ME for dummies" :-)))And if it's in danish it would be nice
  8. In my program <alt>e is opening menu in the top of program. But today when i run the macro the window comes up but the command <alt>e is not working and macro stops. I have restarted the computer. But the same happens. have you ever expired this before???? is there a log or something that can be full and has to be deleted? If i press alt+e manual there is no problem. I have tryed to change text type <alt>e to alt down e alt up and altdownaltup e but the funne is that it has been working in months whit no problem.....
  9. I have this line that I copy into T6 20120 Malmö I have to use only the city name malmö Sometimes the city name is the only thing that is been copyed. How do I do so, that only city name/or text is back in T6? can i tell the macro to look for text and only copy text and not copy space and numbers?
  10. 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. So..... 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??
  11. 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.
  12. Hello.... I use this attached IF macro in my Macro. As you can see there is a lot of IF commands. It runs okay and with no problem. BUT when T3 contains something thats not in one of the if commands it stops. can I but in a if command that does this: IF T3 contains anything else then text type XXXXXXXXX Thanks carsten IF_macro.mex
  13. why will it only see numbers in <>0??? anything is diff. from 0 Also letters.
  14. there was no backup. But my company takes backup from the common drive where it was placed. Puh...lucky me..... But now I have a backup... Thanks..
  15. I was right clicking on unassigned and choose new category. It thinks in 3 minutes and then tells me that the file is no macro file. Then i go to my macro file and can see it's 0 byte??? What has happend???
  16. aarrrhhhh....simple as that ...thanks :-)
  17. Is there a function that can see the diff. between this: I have a prompt where I write G12345 or GRPFTRE to a variable If the variable contains G and 5 numbers then the macro always should run 1. If the variable contains anything else it should run 2. How do i do that???
  18. new problem... I need a prompt like this above, but where the field has a default text. In the prompt i then can change the text, if it's not the default that has to be used. is that possible?
  19. Uhhh..thats advanced. I don't understand much of it. If you have time please comment what happens in the macro.
  20. I have this problem that I can't find the best way to solve. I get a notepad dokument with names. Those names I have to copy and then fill in to another program. This other program has fields for: first name middle name last name But in notepad I can get names in all kind of variants. Ex. Firstname middlename middlename lastname or firstname lastname or firstname middlename lastname or firstname-firstname middlename lastname or firstname lastname-lastname and so on....... In the program where I have to paste, I always have the 3 fields first,middle and lastname. The problem is to get the right names into T1,T2 and T3 from the notepad. My own surgestion is that I check for space and. First copy firstname until a space and put this in T1. Then copy the rest of the line into T10. Check T10 for spaces and copy text after last spaces into T3 Copy all. between first space and last space into T2. Then I always get firstname in T1 and all middlenames into T2 and last name into T3. Am I right or have anyone a better idea? If I'm right then my problem is how to do it the easy way. I would use arrow to jump around and ctrl+shift+arrow to mark a name. But then - does not come with. How do i get the macro to identify the spaces???
  21. I use diff. macros. All macros use the same program, where it sometimes has to type a password. This password changes every month. Instead of reset password in all my macros, can I then store the password in a variable, that never will be empty? Then I only have to change this variable 1 time every month. Or do I have to use a notepad.txt ??
×
×
  • Create New...