How can a date variable contain the value 'N/A'?  If you mean that's the value in your file, then you need to read the file with that column defined as a String in the tFileInputDelimited schema, then use an expression like you've already discovered to remove the 'N/A' values and convert the result to a Date using Lijo's expression to write to MS SQL e.g. row1.myDate.equals("N/A")?null:TalendDate.parseDate("dd/MM/yyyy",row1.myDate).

Hi

You can use TalendDate.parseDate for parsing the date column to your required format
eg
TalendDate.parseDate("yyyy-MM-dd HH:m:ss",Date)
You can change the format according to your use

Hi Shong,

I used row1.City.equals("N/A") ? null : row1.City for the varchar column ,
but for the date column its not working , also the date column is in  dd-MMM format

Thanks
Vikram

There are 2 columns with the same problem , One has Varchar and the second one has date.
Source is a csv , which has rows containing 'N/A' along with data ...
i am using version 3.2.1 .....

Should i use any other function ??

Thanks
Vikram

If a row has 'N/A' , how do i convert it into NULL using tmap or for that matter any other function
Can we apply some IF condition ??