How to handle in File Content Conversion

[monikandan_p]

Hi Experts,

        Please help to skip the last two lines from source data using file content conversion.

Sample source data:

"Actual_date_time;""31-10-2013 22:14:19"";""1-1-1990 22:14:18"";1;41578926611",3542,

"Cycle_time;""31-10-2013 22:14:19"";5",529833;1;41578926611,3542

"Cycle_number;""31-10-2013 22:14:19"";14;1;41578926611",3542,

"Total_act_Butter;""31-10-2013 22:19:19"";784;1;41578930082",8819,

"Total_act_Liquor;""31-10-2013 22:19:19"";1600;1;41578930082",8819,

"Actual_date_time;""31-10-2013 22:19:19"";""1-1-1990 22:19:18"";1;41578930082",8819,

"Cycle_time;""31-10-2013 22:19:19"";5",42285;1;41578930082,8819

"Cycle_number;""31-10-2013 22:19:19"";15;1;41578930082",8819,

"$RT_OFF$;""31-10-2013 22:22:01"";0;2;41578931957",9861,

$RT_COUNT$;44;;;;,,

Best Regards,

Monikandan.

[former_member184720]

we have an option to ignore the first few lines but not the last lines

may be in your case you can impliment the conversion for the entire file instead of writing a module/java mapping/executing OS commands..

If the RT_OFF &RT_COUNT are fixed values then read those lines into different segements and do not map those segments..

[Former Member]

Hi Monikandan

Please use content conversion for the whole file and then inside the mapping ignore the last two records. This will be the easiest approach.

Or else don't go for a content conversion, read the text file and use java mapping to populate the output structure.