topic Re: String Format rows in Talend Studio

String Format rows

Anonymous — Thu, 19 Mar 2015 11:13:49 GMT

Hi Guys,
I have a small function to achieve i.e, I want add leading Zero's to the input which have Long as Datatype:
Output:
0000007865
0002333342
0022373461
0000236327

Input:
7865
2333342
22373461
236327

Re: String Format rows

Anonymous — Thu, 19 Mar 2015 12:47:10 GMT

Try this:

String.format("%10d",row1.field1)

Just remember to replace 'row1.field1' by your value.

Re: String Format rows

Anonymous — Thu, 19 Mar 2015 13:40:09 GMT

@Tom4sz thanx for ur reply, i had already tried this one earlier and my output after applying string.format is some what like this :

Re: String Format rows

Anonymous — Mon, 23 Mar 2015 04:12:46 GMT

any one ??? :0

Re: String Format rows

Anonymous — Mon, 23 Mar 2015 05:23:59 GMT

Hi,
try with below one:
StringHandling.LEN(row1.Input)==9?("0"+row1.Input):
StringHandling.LEN(row1.Input)==8?("00"+row1.Input):
StringHandling.LEN(row1.Input)==7?("000"+row1.Input):
StringHandling.LEN(row1.Input)==6?("0000"+row1.Input):
StringHandling.LEN(row1.Input)==5?("00000"+row1.Input):
StringHandling.LEN(row1.Input)==4?("000000"+row1.Input):
StringHandling.LEN(row1.Input)==3?("0000000"+row1.Input):
StringHandling.LEN(row1.Input)==2?("00000000"+row1.Input):
StringHandling.LEN(row1.Input)==1?("000000000"+row1.Input):
StringHandling.LEN(row1.Input)==0?("0000000000"+row1.Input):row1.Input
Regards,
kumar.talend

Re: String Format rows

Anonymous — Mon, 23 Mar 2015 08:21:18 GMT

Hi,
We can achieve the same thing in different ways. I thought this solution could be very precise and simple.
Use the fallowing expression:
("0000000000" +row1.Test).substring(row1.Test.length())
here row1.Test would be your input & based on the size u can increase/decrease the zeros.
-Bhanu

Re: String Format rows

Anonymous — Tue, 24 Mar 2015 04:15:20 GMT

Thanks Kumar.talend & BhanuChandar For u r kind suggestions but, i have already performed using ternary expression based on length, can u suggest me using String format.

Re: String Format rows

Anonymous — Tue, 24 Mar 2015 04:24:44 GMT

Hi Kiran,
could you pls share us your ternary expression..
Thanks,
kumar.talned

Re: String Format rows

yashwanth1 — Tue, 24 Mar 2015 05:45:34 GMT

Thanks bhanu chandar

Re: String Format rows

Anonymous — Tue, 24 Mar 2015 05:50:48 GMT

Earlier I tried this one:
StringHandling.LEN(Var.var1)==5?"00000"+Var.var1:
StringHandling.LEN(Var.var1)==6?"0000"+Var.var1:
StringHandling.LEN(Var.var1)==8?"00"+Var.var1:
Var.var1
Output:

Re: String Format rows

Anonymous — Tue, 24 Mar 2015 05:52:49 GMT

Thanks bhanu chandar

Re: String Format rows

Anonymous — Tue, 24 Mar 2015 05:57:14 GMT

this one is simple which was suggested by bhanuchandar: Var.var1!=""?("0000000000"+Var.var1 ).substring(Var.var1.length()):""
Output:

Re: String Format rows

Anonymous — Tue, 24 Mar 2015 06:05:50 GMT

Good solution bhanu.