topic Re: LPAD/RPAD in tMap expression in Talend Studio

LPAD/RPAD in tMap expression

Anonymous — Sat, 16 Nov 2024 12:23:45 GMT

Hi,
I want to reproduce the lpad and rpad functions of SQL in a tMap expresion but I can't find the correct way to do that.
Any help would be apreciated,
Regards,
Khor

Re: LPAD/RPAD in tMap expression

Anonymous — Thu, 09 Feb 2012 09:41:54 GMT

Hi Khor
You can try StringHandling.LEFT() and StringHandling.RIGHT().
Or create routine and define custom method in TOS.
Regards,
Pedro

Re: LPAD/RPAD in tMap expression

Anonymous — Thu, 09 Feb 2012 09:49:07 GMT

Hi pedro,
with lpad, for example if the number of characters is higher than the length of the string, it will put spaces (that's what I'm using it for). Like in this example:
lpad('ASD',9) -> 'ASD '
Would this java functions do the same, or just throw me a exception because the string is not long enough?
Thanks,
Khor.

Re: LPAD/RPAD in tMap expression

Anonymous — Thu, 09 Feb 2012 09:51:50 GMT

  public static String lpad(String s, int n, String replace) {
                while (s.length() < n) {
                        s = replace+s;
                }
                return s;
        }
            public static String rpad(String s, int n, String replace) {
                while (s.length() < n) {
                        s = s+replace;
                }
                return s;
        }

Type this into custom routine.
Regards,
Pedro

Re: LPAD/RPAD in tMap expression

Anonymous — Thu, 09 Feb 2012 09:58:44 GMT

Hi pedro,
How to call this routine in tMap expression?
Regards,
Khor

Re: LPAD/RPAD in tMap expression

Anonymous — Thu, 09 Feb 2012 10:00:00 GMT

Hi Khor
You can find it in Expression Builder.
Regards,
Pedro

Re: LPAD/RPAD in tMap expression

Anonymous — Thu, 09 Feb 2012 10:02:27 GMT

Hi,
This is the first place where I lookd it for, but the routines are not there.
I have to do something to import the routines in the tMap?
Regards,
Khor

Re: LPAD/RPAD in tMap expression

Anonymous — Thu, 09 Feb 2012 10:03:46 GMT

Hi Khor
That means you didn't create routine correctly.
You can get more info about custom routine in document.
Regards,
Pedro

Re: LPAD/RPAD in tMap expression

Anonymous — Thu, 09 Feb 2012 10:06:28 GMT

Hi,
Thank for you help.
Regards,
Khor