Talend community forum / extracting substrings from a tSystem output using a regular expression

matthieu_r · 2010-03-24 00:31:25

Hello,

I've got a tSystem which gives me the following output:
Extent 134 9786.676,654 07097.98
The current pattern is the following one:
Extent xmin ymin xmax ymax

I connect a tJavarow to the tSystem in order to treat the result
I'd like to know how to extract xmin, ymin, xmax and ymax using regular expressions in the tJavaRow.

Thanks!

shong · 2010-03-24 07:07:52

Hello
Output the result of tSystem to a global var, and then get the output result and extract the substring on tJava.

Best regards
Shong

Uploaded Images

mathieu_r · 2010-03-24 09:35:46

hello shong

I thank you for the imaged answer!
Sorry for not having being clear enough..

the output is only:
Extent 134 9786.676,654 07097.98

But the pattern is the following one:
Extent xmin ymin,xmax ymax
The schema of my tJavaRow will be with 4 columns
xmin
ymin
xmax
ymax

So I'd like to know how to extract the first float number, the second one and so forth, using a regular expression.

Thanks again!

Announcement

Unanswered posts

#1 2010-03-24 00:31:25

extracting substrings from a tSystem output using a regular expression

#2 2010-03-24 07:07:52

Re: extracting substrings from a tSystem output using a regular expression

#3 2010-03-24 09:35:46

Re: extracting substrings from a tSystem output using a regular expression

Board footer