mid function

[leighmills33]

hi guys,
i have this information where i have to pull the code, but i dont know which is the best way to do it, here it is:

'Job:C:\Program Files\Thermwood\eCabinet Systems\Jobs\20732_1 Tester.esj

what i want to do is get the number out of it so 20732_1, so really i want to come from the right and search for ("\"), so is this possible using a mid search function or can i only come from the left. is there a way i can use the right function to do this.

Thanks

Leigh Mills

[Richard Buttrey]

hi guys,
i have this information where i have to pull the code, but i dont know which is the best way to do it, here it is:

'Job:C:\Program Files\Thermwood\eCabinet Systems\Jobs\20732_1 Tester.esj

what i want to do is get the number out of it so 20732_1, so really i want to come from the right and search for ("\"), so is this possible using a mid search function or can i only come from the left. is there a way i can use the right function to do this.

Thanks

Leigh Mills

Hi,

If the Job number is always 7 characters, and it always follows the 5th occurrence of a '\" then use:

Please Login or Register  to view this content.

If not this will need modifying, in which case post back.

Rgds

[leighmills33]

thanks great thanks