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 <[email protected]>
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 <[email protected]> wrote:
>
>> Prabhu,
>>
>> What is the output of *${input.4:substringBefore('-'):toDate('MMM')} *?
>>
>> Cheers
>>
>> On Mon, Apr 10, 2017 at 3:15 PM, prabhu Mahendran <
>> [email protected]> 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 <[email protected]> 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 <
>>>> [email protected]> 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 <[email protected]> wrote:
>>>>>
>>>>> What is the expression language statement that you're attempting to
>>>>> use?
>>>>>
>>>>> On Thu, Apr 6, 2017 at 3:12 AM prabhu Mahendran <
>>>>> [email protected]> 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?
>>>>>
>>>>>
>>>>>
>>>
>>
>
