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" <[email protected]> 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 < > [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? >>>>>> >>>>>> >>>>>> >>>> >>> >> >
