Hi,
We are saving our string data into database after handling Escaped Character.https://www.talendforge.org/exchange/?eid=360&product=tos&action=view&nav=1,0,0
in above note the row 5-
'Rajul', '3240 Mahindra Park\n behind hdfc bank'
'Rajul', '3240 Mahindra Park\n behind hdfc bank'
Use expression below in tScriptRules-
"input_row.address_street =~ '.*(\\n).*'"
Note: Rules -- expressions that evaluate to true or false -- are created using a Javascript-like language called JEXL.
"input_row.address_street =~ '.*(\\n).*'"
Note: Rules -- expressions that evaluate to true or false -- are created using a Javascript-like language called JEXL.
We can also handle email validation like finding string having yahoo.com at last by-
"input_row.field_name =~ '.*yahoo.com$'"
"input_row.field_name =~ '.*yahoo.com$'"
We can also use && and || expression in tScriptRules.
No comments:
Post a Comment