Changing Month from English to French

TalendBasketball65 — Thu, 03 Sep 2020 22:23:30 GMT

Hi All,

This is probably a simple quick fix. I have a tfileinputdelimited(.csv file) that contains dates that are English (September 03, 2020). I need to convert it to French example(septembre 3 2020) format. What's the easiest way to approach this? I also forgot to include that I have code that indicate French or English so that would be taken into account.

Thanks,

Re: Changing Month from English to French

cadap — Thu, 01 Oct 2020 13:30:13 GMT

You could create a user-routine, which converts English to French Dates in your above format like this:

public static String English2French(String dateString){

DateTimeFormatter formatterEnglish = DateTimeFormatter.ofPattern("MMMM dd, yyyy", Locale.ENGLISH);

DateTimeFormatter formatterFrench = DateTimeFormatter.ofPattern("MMMM dd, yyyy", Locale.FRENCH);

LocalDate localDate = LocalDate.parse(dateString, formatterEnglish);

return localDate.format(formatterFrench);

}

Call:

System.out.println(English2French("September 03, 2020"));

topic Re: Changing Month from English to French in Talend Studio

Changing Month from English to French

Re: Changing Month from English to French