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