koden

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?

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 ??

OK I got it..

I did not know that

Variable Modify String: Trim

automaticly is deleting all spaces left and right

Thanks...

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...

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.

Thanks... Have tried all the suggestions.

I have resolved it with double command <alt>e

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

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.....

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?

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??

Thanks I will try... .-)

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.

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

why will it only see numbers in <>0???

anything is diff. from 0

Also letters.

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..

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???

Okay..thanks..will try this.

aarrrhhhh....simple as that ...thanks :-)

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???

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?

Uhhh..thats advanced. I don't understand much of it.

If you have time please comment what happens in the macro.

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???

thanks for help...

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 ??

off course...thanks..