topic Re: substring in a string in Talend Studio

substring in a string

lmit — Wed, 20 Mar 2019 17:33:42 GMT

Hi All,

I have a input data which has a special character like

"maths*science*English"

my ouput should have data like

science

English

the position of the special character is not fixed and I should consider the occurrence of special character based on the other column i.e., if the other column has data like 3 I should consider the 3rd occurrence of the special character.

Thanks in Advance,

Lmit

Re: substring in a string

Anonymous — Wed, 20 Mar 2019 17:55:02 GMT

If there is only one special string *

row7.test.contains ("*")
?
StringHandling.EREPLACE(row7.test, "*", "")
:row7.test

if you have multiple special characters use the code in routines. so it will and , gives you good result.

Manish

Re: substring in a string

manodwhb — Thu, 21 Mar 2019 04:25:59 GMT

@lmit ,check the below example. works fine for your case.

Re: substring in a string

lmit — Thu, 21 Mar 2019 04:45:20 GMT

@manodwhb thanks for your reply

I cant use tnormalize component because I have to sometimes consider the data before the special character or in between special character I need only part of the string Like

if my data is "ma*thsSci*eng"

for some cases I need to consider my output to be only thsSci or eng

I don't want to increase the records

Thanks,

lmit

Re: substring in a string

lmit — Thu, 21 Mar 2019 04:49:34 GMT

Hi Manish,

I tried your code but it will replace special character or will displace the string.but I need part of the string based on special character

Thanks,

lmit

Re: substring in a string

manodwhb — Thu, 21 Mar 2019 05:13:14 GMT

@lmit,check this.

input data:-

maths*science*English
ma*thsSci*eng

output data:-

science
thsSci

Re: substring in a string

lmit — Thu, 21 Mar 2019 06:25:33 GMT

@manodwhb thanks for your code its displaying "thsSci"

but how about "eng" in the string

Code displays data from first occurrence to second occurrence how can I make it generic ?

Thanks,

lmit

Re: substring in a string

manodwhb — Thu, 21 Mar 2019 06:28:09 GMT

@lmit ,can you explain with data what exactly do you want?

Re: substring in a string

manodwhb — Thu, 21 Mar 2019 06:41:56 GMT

@lmit ,are you looking for below way?

Re: substring in a string

lmit — Thu, 21 Mar 2019 08:33:42 GMT

@manodwhb , my requirement is

source file :

id, data, position field

1, abc*dfec*eng, 1

2, abc*dfec*eng*math, 3

output should be

1,dfec

2,math

Based on the position field value , the data column should have the data

for example 2 id , the position field is 3 which means the data in data column should start from 3 occurrence of the special character and should end till the next occurrence

Hope I explained your properly

Thanks,

lmit

Re: substring in a string

akumar2301 — Thu, 21 Mar 2019 13:16:45 GMT

Another simple solution

Input -- tjavarow -- Output

input

id,newColumn,pos

1,abc*dfec*eng,1
2, abc*dfec*eng*math,3

tjavarow

output_row.id = input_row.id;

try {
output_row.result = input_row.newColumn.split("\\*")[input_row.pos];

}
catch ( Exception e ){
output_row.result = "Err - Not found";
}

Output

id|result

1|dfec
2|math