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, you may want to
specify the locale NiFi uses to execute either via environment variables or
using java command line parameters.
Cheers
On 12 Apr 2017 8:03 PM, "prabhu Mahendran" <prabhuu161...@gmail.com> wrote:
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 <prabhuu161...@gmail.com>
wrote:
> 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" <andre-li...@fucs.org> wrote:
>
>> 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 <
>> prabhuu161...@gmail.com> wrote:
>>
>>> 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')-->It converts 'May' into Number like if Jan it should be 01
>>> then 'May it should be 05.
>>>
>>> Here i have convert month into number.
>>>
>>> Cheers
>>>
>>> On Mon, Apr 10, 2017 at 5:58 PM, Andre <andre-li...@fucs.org> wrote:
>>>
>>>> Prabhu,
>>>>
>>>> What is the output of *${input.4:substringBefore('-'):toDate('MMM')} *?
>>>>
>>>> Cheers
>>>>
>>>> On Mon, Apr 10, 2017 at 3:15 PM, prabhu Mahendran <
>>>> prabhuu161...@gmail.com> 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 'May' and '17'.
>>>>>
>>>>> Using below expression language..,
>>>>>
>>>>>
>>>>>
>>>>> *${input.4:substringBefore('-'):toDate('MMM'):format('MM')}*In above
>>>>> query it could convert 'May' into '05' value.
>>>>>
>>>>> That can be work in my windows (English(US)).
>>>>>
>>>>> That Same query not work in French OS windows(French(Swiss)).
>>>>>
>>>>> It shows below error.
>>>>>
>>>>> *org.apache.nifi.expression.language.exception.IllegalAttributeExpression:Cannot
>>>>> parse attribute value as date:dateformat:MMM;attribute value:Mai*
>>>>>
>>>>> In that exception it shows attribute value is 'Mai'.Those value is in
>>>>> 'French' but i had given my data is in 'May' [english only].
>>>>>
>>>>> Can you suggest way to avoid this exception?
>>>>>
>>>>>
>>>>> On Fri, Apr 7, 2017 at 11:40 PM, Jeff <jtsw...@gmail.com> wrote:
>>>>>
>>>>>> 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 <
>>>>>> prabhuu161...@gmail.com> wrote:
>>>>>>
>>>>>>> jeff,
>>>>>>>
>>>>>>> Thanks for your reply.
>>>>>>>
>>>>>>> Attribute 'ds' having the '07/04/2017'.
>>>>>>>
>>>>>>> And convert that into month using UpdateAttribute.
>>>>>>>
>>>>>>> ${ds:toDate('dd/MM/yyyy'):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(OS) it couldn't
>>>>>>> work.
>>>>>>>
>>>>>>> Can you suggest any way to solve that problem?
>>>>>>>
>>>>>>> On Fri, Apr 7, 2017 at 1:28 AM, Jeff <jtsw...@gmail.com> wrote:
>>>>>>>
>>>>>>> What is the expression language statement that you're attempting to
>>>>>>> use?
>>>>>>>
>>>>>>> On Thu, Apr 6, 2017 at 3:12 AM prabhu Mahendran <
>>>>>>> prabhuu161...@gmail.com> 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 converting datetime format into Month using
>>>>>>> expression language with NiFi package installed with French OS.
>>>>>>>
>>>>>>> But it worked in English(US) Selected language.
>>>>>>>
>>>>>>> Can anyone help me to resolve this?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>>
>>>
>>
