topic Re: split column fields into two column using tmap in Talend Studio

split column fields into two column using tmap

Anonymous — Wed, 13 Jan 2016 11:00:11 GMT

Hi
I have two types of file names in column "File" with datatype String
First : A.csv.bad.currentdate
Second: A.csv.good.currentdate
I want to split these filenames into two column, Good and Bad
So from tmap output, would be like this
Good Bad
A.csv.good.currentdate A.csv.bad.currentdate
may I know how I can I set up this config in tmap ?

Re: split column fields into two column using tmap

Anonymous — Thu, 14 Jan 2016 05:05:37 GMT

Can anyone Help ?

Re: split column fields into two column using tmap

Anonymous — Thu, 14 Jan 2016 06:37:37 GMT

Write a small piece of Java code to cut the string, for example,
the expression for the good string:
row1.data.substring(row1.data.lastIndexOf(":")+1)
the expression for the bad string:
row1.data.substring(row1.data.IndexOf(":")+1,row1.data.indexOf("\r\n"))

Re: split column fields into two column using tmap

Anonymous — Thu, 14 Jan 2016 09:15:39 GMT

Hey Shong
Here is my output....Please check
http://prntscr.com/9px09l

I want to split "File" Column into two columns, "Bad" and "Read".
So output would be like this
http://prntscr.com/9px2hy

May I know how can I do this in Tmap ?

Re: split column fields into two column using tmap

Anonymous — Thu, 14 Jan 2016 14:29:54 GMT

Hey Shong, Can you suggest me for the same ?

Re: split column fields into two column using tmap

Anonymous — Fri, 15 Jan 2016 07:06:49 GMT

Anyone ?

Re: split column fields into two column using tmap

Anonymous — Fri, 15 Jan 2016 10:02:37 GMT

Hi
Use a tMap to generate two output tables, add a filter condition to filter the reject rows for reject table or bad rows for bad table, for example:
row1.file.contains("bad")
Add a sequence id for each table for doing join in the next subjob to merge the bad and reject columns, see

Hope it helps.

Re: split column fields into two column using tmap

Anonymous — Tue, 16 Oct 2018 06:43:58 GMT

I have to split the val from this file to two separate files, where 1st file file contains 1,2,3 and 2nd file contains 15,25,34.

dist val

how do I do this?

Can somebody help me?

Re: split column fields into two column using tmap

Anonymous — Tue, 16 Oct 2018 08:01:19 GMT

Hi Shong can you help me?