reject line having Alphanumeric and special caracters

[hechmi]

Hi All;

 i  have tabel input data have   line of name and state i want to reject line having  Alphanumeric  and  special caracters with  tmap or other composant :

input data-------table out put  reject (name and state with  Alphanumeric  and  special caracters and   int)

                        table out put reliable (name and state without   Alphanumeric  and  special caracters)

Thank in advance

[Anonymous]

Hi,

    Could you please try below function in tmap? It will give a boolean output based on the string condtion. Use this boolean value in expression filter of the output schema as condition to reject bad records.

    If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

[hechmi]

thks;
but not good solution are you have other help
best regards

[Anonymous]

Hi,

    Could you please advise the issue you are facing when you tried the above function? If you could provide the screenshots of the error, it will be more helpful to understand the problem in detail.

Warm Regards,

Nikhil Thampi

[TRF]

@hechmi, if you know this is not a good solution, you probably know a better one.

In such a case, why are you asking for a solution?

You should share your own.

[hechmi]

@TRF
sorry ;
but i want to say , i try with yor help but i don t have a solution
i m so sorry
best regard

[hechmi]

thks 

i have only one reject u see in in screen but when i use isalpha  i don t seethe good result 

you can see the attached screen 

best regard

isalph1.PNG
isalpha.PNG
isalpha2.PNG

[TRF]

Don't know which tool you're using to check the data on isalpha2.PNG picture.

Anyway, what about null value?

StringHandling.IS_ALPHA will consider null values as non alpha values, so concerned records will be rejected.

[Anonymous]

I agree with TRF, how do you know that the record you showed did NOT get rejected? Your screenshots show thousands of records being accepted and a significant number not being accepted. This is a bit confusing at the moment. Can you test with 2 records; 1 good one and 1 bad one?

[Anonymous]

I've just noticed, why do you have "Catch output reject" set to True in your tMap? This should be false.