topic Re: How to split a String into two columns in Data Quality

How to split a String into two columns

Lara_Zuern — Sat, 16 Nov 2024 00:06:53 GMT

Hello,

I'm from Germany and a real newbie on Talend.

For my bachelor thesis I am supposed to test the tool Talend Open Studio for Big Data. Part of my data is stored in a MongoDB. I want to split the string of the attribute machineTime into one column with Date and one with Time. For example, a string looks like this: machineTime: "14.05.2018 : 12:35". How can I implement this?

Thanx for your help.

Lara

Re: How to split a String into two columns

Prakhar1 — Wed, 26 May 2021 13:53:24 GMT

So you have to write a code like this in tJavaFlex ( main code )

index = machineTime.indexOf(":");

machineDate = machineTime.substring(0,index);

machineNewTime = machineTime .substring(index+1,machineTime.length());

Now you can create two columns in tJavaFlex schema like machineDate and machineNewTime or whatever you like

and then whatever the output link name is the code will be like this

row2.machineDate = machineTime.substring(0,index);

row2.machineNewTime = machineTime .substring(index+1,machineTime.length());

Let me know in case you need more help

Re: How to split a String into two columns

Lara_Zuern — Thu, 27 May 2021 06:08:23 GMT

Hello Prakhar,

Thank you very much for your help. I have now tried the code and every time I get the message that the series machineTime can not be resolved. Any suggestions on this?

Re: How to split a String into two columns

Anonymous — Thu, 27 May 2021 07:19:57 GMT

Please upload some screenshots to show us where you write the code and which components the job contains.

Re: How to split a String into two columns

Lara_Zuern — Thu, 27 May 2021 08:59:35 GMT

This is where I wrote the code. I've also tried to write it at the end but it doesn't work.

Re: How to split a String into two columns

Anonymous — Fri, 28 May 2021 09:10:53 GMT

See below screenshots, here are the Java codes on tJavaFlex.

index = row1.machineTime.indexOf(":");

row2.machineDate = row1.machineTime.substring(0,index);

row2.machineNewTime = row1.machineTime .substring(index+1,row1.machineTime.length());

Re: How to split a String into two columns

Lara_Zuern — Mon, 31 May 2021 06:22:00 GMT

Hello again,

I tried it the way you said.

With your setup, it worked. Then I tried it with my data from MongoDB (screenshots follow). First I only read the variable machineTime from MongoDB. Now I always get the following error message after running the job:Here is the complete structure of my job:

Re: How to split a String into two columns

Anonymous — Mon, 31 May 2021 11:55:44 GMT

What is the error message? You forgot to upload the screenshots.

Re: How to split a String into two columns

Lara_Zuern — Mon, 31 May 2021 12:16:41 GMT

Thank you, I had not even noticed.

Here we go.