remove spaces, special character, and also check if lenght is > 5 and <5 then pass null else row1.test in a single expression

[sbxr]

Hi,

In Tmap for row1.test how can can i remove spaces, special character, and also check if lenght is > 5 and <5 then pass null else row1.test in a single expression.

Regards

[Anonymous]

Hi,

    Please refer the below link to add the replace function to remove any characters other than alphanumeric.

https://stackoverflow.com/questions/1805518/replacing-all-non-alphanumeric-characters-with-empty-str...

    For length check, you can use below function.

StringHandling.LEN(row1.data)>5?row1.data:null 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved