Skip to Content
avatar image
Former Member

UDF for remove leading Alphabets,special charter and leading zeros from an Input field

Hi Experts,

Could you please help me for

UDF for remove leading Alphabets,special charter and leading zeros from an Input field

Example:

Input: ABC/0000000001234

Output:1234

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 03, 2017 at 06:02 AM

    Hi,

    Is your Input fixed??

    If the Input you are getting is always of 17 characters fixed ..you can remove the the leading zeroes,special characters with Substring function

    as follows

    Otherwise you have to go for UDF

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 03, 2017 at 06:12 AM

    Rajesh,

    Try this :

    Input variable : var1
    return ((var1.replaceAll("[^0-9]", "")).replaceAll("^0+", ""));

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded