String which should start from the alphabetic

[tabisen1]

Dear All,

Very good after noon to all i am Creating the QVW for the count of truck round in which i am facing some issues for example.

truck no. should be

mh04ab1234

mwv123

ect,

I data base the truck no. is not as per the format. I want to create it like above format. I have  cleared the special charater in between the truck no and created the single string which show like this

Previous

mh04/ ab 1234

123 mwv-123

mh-04 ab1234 / 5678

mwv 123 (9876)

9876 / mwv123

mwv 123 (9876/234)

9876/ 234- mwv123

current by using the

PurgeChar([Truck no],'/, ,-,(,)')

mh04ab1234

123mwv123

mh04ab12345678

mwv1239876

9876mwv123

mwv1239876234

9876234mwv123

I want the above current to modify which will take the starting alphabet and remove the starting numbers and also want to remove the end extra number which is extra number for the reference in give at the end and begining of the truck no.

Regards,

[tabisen1]

Dear Manish,

Thank's to you the given function is working fine but in some it is not working

mh04ab1234 cd1234      = mh04ab1234

mh04ab1234bt               = mh04ab1234

[MK_QSL]

Tarun,

Whatver we will do, the logic itself is not in general, so you would be having difficulties!

Until we dont have specific logic, not possible to give you firm solution...

Sorry but can't help further on this! Hope someone will come with better solution.

[tabisen1]

Dear Manish,

One more

123 mh04 a 123 abcd = mh04a123