substring

[Former Member]

hi all,

i have a dilemma regarding substring. i need to cut a value based on the first character. foe example, file-123888. I need to get the characters after the - symbol. Result should be 123888. I know I have to use a UDF but I'm not that good in JAVA. Please help

Thanks!

IX

[Former Member · Accepted solution]

I'd go for an even more "flexible" way :

String substr = str.substring(str.indexOf("-")+1,str.length());

so you do not need to declare static position and length and if the begin pattern changes, it will deal with it

Chris

[Former Member]

Hi,

I need to get the characters after the - symbol.

Means u want all the things after "-".

and the length may vary also after "-".

So please use the

String k = "abc-addd";

System.out.println(k.substring(k.indexOf("-")+1));

Thanks & Regards

Babu

[rajasekhar_reddy14]

Hi,

Search in sdn,you wil find the code for the same,

it is very easy pass input to the udf and use substig function

str is here your input

String str = string.substring(6,11);

retunr str;

Regards,

Raj