topic Re: Transform a time into seconds in Talend Studio

Transform a time into seconds

_AnonymousUser — Sat, 16 Nov 2024 13:44:37 GMT

Hi!
I am trying in the tMap to transform a time that I get out from a data source in string like this "12:13:55" to seconds (43200 + 720 + 55 = 43975) in this case.
How can I do that with the expressions given to me in the tMap Expressions?
Thanks
Joakim

Re: Transform a time into seconds

Anonymous — Tue, 06 Oct 2009 00:10:52 GMT

Hi,
Create a routine :-
public static String CalculateTotalSeconds(String timein) {
String[] date_string = timein.split(":");
int hours = Integer.parseInt(date_string);
int mins = Integer.parseInt(date_string);
int seconds = Integer.parseInt(date_string);

int totalsec = (hours * 3600)+ (mins* 60) + seconds;

return "" + totalsec;
}
Call from tmap :-
Date_Converter.CalculateTotalSeconds(variable);
Returns a string with total seconds.
HTH

Re: Transform a time into seconds

_AnonymousUser — Tue, 06 Oct 2009 10:08:01 GMT

tnewman: Thanks for the example. I just don´t know how to create a routine, I am in the Navigator mode of the Repository but I dont understand how to create it.
// Joakim

Re: Transform a time into seconds

_AnonymousUser — Tue, 06 Oct 2009 10:25:29 GMT

I dont have the "code" section in my Repository that is shown on examples I have seen... How do I get that visible?

Re: Transform a time into seconds

Anonymous — Tue, 06 Oct 2009 21:41:15 GMT

Hi,
I am using TIS and I see the Code branch in the standard view. I have looked around the various menus and cannot see anywhere we you can include/exclude from the repo view.
I am not sure if TOS is different.
Sorry I can't be much more help - maybe someone else can answer.

Re: Transform a time into seconds

Anonymous — Wed, 07 Oct 2009 03:24:45 GMT

It's in TOS too, at least for java projects.

Re: Transform a time into seconds

Karuetl — Tue, 12 Feb 2019 20:34:55 GMT

Got an error when creating routine

Re: Transform a time into seconds

vapukov — Wed, 13 Feb 2019 00:43:23 GMT

@Karuetl wrote:

Got an error when creating routine

you just need chose array element for parse

0 - hours

1 - minutes

2 - seconds

	public static String CalculateTotalSeconds(String timein) {
		String[] date_string = timein.split(":");
		int hours = Integer.parseInt(date_string[0]);
		int mins = Integer.parseInt(date_string[1]);
		int seconds = Integer.parseInt(date_string[2]);

		int totalsec = (hours * 3600)+ (mins* 60) + seconds;

		return "" + totalsec;
		}

P.S.

keep in mind - original routine return String, if you need have a long or integer - you need modify it or convert into integer in tMap/tJava

Re: Transform a time into seconds

Karuetl — Wed, 13 Feb 2019 00:51:36 GMT

Thanks

Re: Transform a time into seconds

vapukov — Wed, 13 Feb 2019 01:27:31 GMT

thanks - it is too much ... kudu is enough 😉

welcome to community