Originally posted by: Ejay
Hi ,
One example of parsing and splitting a parameter here ;
https://www.ibm.com/developerworks/community/forums/html/topic?id=e05068cc-997a-4204-8349-6f2eaddea76e&ps=25
=VALID(JEXIT("EJ.TestCases.CalculateTimeZone","getTimeZone",DATETOTEXT(CURRENTDATETIME("CCYYMMDDHH24MMSS+/-ZZ:ZZ")),"yyyyMMddHHmmssXXX!yyyy-MM-dd'T'HH:mm:ss.SSSXXX"),
FAIL(LASTERRORMSG()+LASTERRORCODE())))
The second argument is delimited by a ! that we parse and split in the javacode .
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.TimeZone;
public class CalculateTimeZone {
public static String getTimeZone(String zone,String zone2) {
//reset date
Date date = null;
String dateout =null;
String part1 = null;
String part2 = null;
try {
String[] parts = zone2.split("!");
part1 = parts[0];
part2 = parts[1];
DateFormat df = new SimpleDateFormat(part1);
DateFormat dfout = new SimpleDateFormat(part2);
date = df.parse(zone);
dateout = dfout.format(date);
return dateout;
}
catch (ParseException pe) {
pe.printStackTrace();
}
return "Error parsing or formatting date.\r\nInput date given "+zone+"\r\nInput and output Format given : "+zone2+"\r\nParsed input format ="+part1+"\r\nParsed output format="+part2;
}
}
Hope this Help .
Ej
#IBMSterlingTransformationExtender#DataExchange#IBM-Websphere-Transformation-Extender