Re: How can datetime to month conversion failed in french language?

2017-04-12 Thread prabhu Mahendran
Jeff, yes my data contains English names for month. Andre, It would be more interesting for specify locale argument with Expression language. After discussing,Are you will create task for it or not? On Thu, Apr 13, 2017 at 2:33 AM, Andre wrote: > Hi, > > I suspect that at the moment the conv

Re: How can datetime to month conversion failed in french language?

2017-04-12 Thread Andre
Hi, I suspect that at the moment the conversion between locales needs to be done manualy. It may be worth discussing with the community the ability to specify the locale argument when calling the Expression Language functions you referred to. Meanwhile, IF your other flows and processors allow,

Re: How can datetime to month conversion failed in french language?

2017-04-12 Thread Jeff
Prabhu, Are you saying that the data you're working with contains the English names for the months? On Wed, Apr 12, 2017 at 6:03 AM prabhu Mahendran wrote: > output of the breakdown of the functions is 'Mai'.But in my local file > contains 'May'. while processing 'May'(English) could be convert

Re: How can datetime to month conversion failed in french language?

2017-04-12 Thread prabhu Mahendran
output of the breakdown of the functions is 'Mai'.But in my local file contains 'May'. while processing 'May'(English) could be converted as 'Mai'(French). Is there is any expression language to convert French language into English? On Mon, Apr 10, 2017 at 8:02 PM, prabhu Mahendran wrote: > I h

Re: How can datetime to month conversion failed in french language?

2017-04-10 Thread prabhu Mahendran
I have store that result in another attribute using updateAttribute processor. While incoming flowfiles into updateAttribute processor i have faced that error. On 10-Apr-2017 6:52 PM, "Andre" wrote: > Prabhu, > > Thanks for the breakdown of the functions but what does > *${input.4:substringBefor

Re: How can datetime to month conversion failed in french language?

2017-04-10 Thread Andre
Prabhu, Thanks for the breakdown of the functions but what does *${input.4:substringBefore('-'):toDate('MMM')}* output? :-) May? Mai? something else? Cheers On Mon, Apr 10, 2017 at 10:39 PM, prabhu Mahendran wrote: > Andre, > > > > > > > > *1,12990,Mahe,May-17input.1->1input.2->12990input.3->

Re: How can datetime to month conversion failed in french language?

2017-04-10 Thread prabhu Mahendran
Andre, *1,12990,Mahe,May-17input.1->1input.2->12990input.3->Mahe.input.4->May-17* *${input.4:substringBefore('-'):toDate('MMM')}* substringBefore('-')--> get the string portion before(' - ') symbol.It returns result 'May'. toDate('MMM')-->Converts string into Month format. format('MM')-->

Re: How can datetime to month conversion failed in french language?

2017-04-10 Thread Andre
Prabhu, What is the output of *${input.4:substringBefore('-'):toDate('MMM')} *? Cheers On Mon, Apr 10, 2017 at 3:15 PM, prabhu Mahendran wrote: > Jeff, > > My actual data is in English(US). > > consider sample data, > > > *1,12990,Mahe,May-17* > In this line i have get "May-17" and split it as

Re: How can datetime to month conversion failed in french language?

2017-04-09 Thread prabhu Mahendran
Jeff, My actual data is in English(US). consider sample data, *1,12990,Mahe,May-17* In this line i have get "May-17" and split it as 'May' and '17'. Using below expression language.., *${input.4:substringBefore('-'):toDate('MMM'):format('MM')}*In above query it could convert 'May' into '05'

Re: How can datetime to month conversion failed in french language?

2017-04-07 Thread Jeff
Prabhu, I'll have to try this in NiFi myself. I'll let you know what I find. What is the result of the EL you're using when you are trying it with French? On Fri, Apr 7, 2017 at 1:03 AM prabhu Mahendran wrote: > jeff, > > Thanks for your reply. > > Attribute 'ds' having the '07/04/2017'. > >

Re: How can datetime to month conversion failed in french language?

2017-04-06 Thread prabhu Mahendran
jeff, Thanks for your reply. Attribute 'ds' having the '07/04/2017'. And convert that into month using UpdateAttribute. ${ds:toDate('dd/MM/'):format('MMM')}. if i use that code in windows having language English(India) then it worked. If i use that code in windows having language French(

Re: How can datetime to month conversion failed in french language?

2017-04-06 Thread Jeff
What is the expression language statement that you're attempting to use? On Thu, Apr 6, 2017 at 3:12 AM prabhu Mahendran wrote: > In NiFi How JVM Check language of machine? > > is that take any default language like English(US) else System DateTime > Selected language? > > I face issue while con

How can datetime to month conversion failed in french language?

2017-04-06 Thread prabhu Mahendran
In NiFi How JVM Check language of machine? is that take any default language like English(US) else System DateTime Selected language? I face issue while converting datetime format into Month using expression language with NiFi package installed with French OS. But it worked in English(US) Select