22 Replies Latest reply: Aug 14, 2015 4:55 AM by tarun bisen RSS

    String which should start from the alphabetic

    tarun bisen

      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,