Regular expression in Kettle

Question

Does anybody know how to find pattern like ^.^ in Kettle (for example, ^44^, ^!^)?

'.' represents any letters which can be single or multiple.

I found this pattern, >.< (for example, >44!<) through (.*)(>.*<)(.*)

So I applied same way as (.*)(^.*^)(.*). But it never finds it.

Actually I do not know the meaning of (.*) exactly also, if anybody knows about it, could you give some advice?

see [this](http://stackoverflow.com/questions/3075130/what-is-the-difference-between-and-regular-expressions) — m87, Feb 21 '17 at 20:20
Yes, now I understand what (.*) however, the first question is not solved yet. How to find the pattern ^44^ or ^!^? — Anna Lee, Feb 21 '17 at 20:31

m87 · Answer 1 · 2017-02-21T21:00:47.600

1

You can find pattern like ^44^ or ^|^ by using the following regex

(\^.*?\^)

edited Feb 21 '17 at 21:00

answered Feb 21 '17 at 20:43

m87

Kettle is implemented in Java, so your pattern `(\^.*?\^)` will not work as expected. Java has its own RE implementation and there are subtle and not so subtle differences in comparison with PCRE, some restrictions imposed by Kettle on top. – marabu Feb 23 '17 at 10:20

score 0 · Answer 2 · answered Feb 22 '17 at 20:00

0

This is barely about Kettle. It's more about regular expressions in Java. After you have aquired a basic understanding of RE, you will want to lookup the pattern constructs time and again.

answered Feb 22 '17 at 20:00

marabu

2 Answers2