Skip to Content
0

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

Aug 02, 2017 at 11:42 AM

81

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

gurudatta d Aug 03, 2017 at 06:02 AM
0

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


substring.jpg (17.8 kB)
substring1.jpg (12.5 kB)
Share
10 |10000 characters needed characters left characters exceeded
Manoj K Aug 03, 2017 at 06:12 AM
0

Rajesh,

Try this :

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

Br,

Manoj

Share
10 |10000 characters needed characters left characters exceeded