How to check the first three position in a input data are alpha or numeric

[Anonymous]

I need to check some condition to satisfy before inserting a data into target.
- First three position in a input should be alpha or numeric & if it is alpha should be uppercase.
-the first letter can be alpha or a special character '.'

[Anonymous]

Hi,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

[TRF]

Hi, 

You need a regex in such a case.

Suppose you have the following data flow (here in a tFixedFlowInput):

Connect the tFixedFlowInput with a tMap and configure it as:

The tMap contains 2 output flows called "accepted" and "rejected" (see "Catch out rejected" option for the 2nd flow).

A filter is set for the "accepted" flow using the following regex:

row1.value.matches("^\\..*") || row1.value.matches("^[0-9|A-Z]{3}.*")

This filter accept 2 kind of rows:

- rows starting with a "." followed by any sequence of characters

- rows starting by a sequence of 3 characters composed by digits (0-9) or uppercase letters (A-Z) followed by any sequence of characters

And the result is:

Hope this is what you expect.