Define a method in Groovy evaluator

asked 2019-01-09 09:29:06 -0500

srinath_222
116 ●14 ●20 ●25

updated 2019-01-09 10:13:52 -0500

metadaddy

4056 ●26 ●39 ●70 https://about.me/patpa...

Hi ,

I am trying to parse field values using the below code in Groovy evaluator for field field1 :

for (record in records) {
  try {     
    StringBuilder ret = new StringBuilder(record.value['field1'].length());
    for (String word : record.value['field1'].split(" ")) {
            if (!word.isEmpty()) {
                ret.append(word.substring(0, 1).toUpperCase())
                ret.append(word.substring(1).toLowerCase())}
            if (!(ret.length()==record.value['field1'].length()))
                ret.append(" ")
        }

    record.value['field1'] = ret.toString()

    output.write(record)
  } catch (e) {
    log.error(e.toString(), e)
    error.write(record, e.toString())
  }
}

I want to apply the same code to multiple fields from the incoming data.

Can you please suggest on how to define a method in Groovy evaluator so that we can pass the incoming required fields to the method ??

Comments

@metadaddy any suggestions on how to define a method in Groovy evaluator which can be used for required fields

srinath_222 ( 2019-01-09 13:36:34 -0500 )edit

add a comment

answered 2019-01-09 14:15:29 -0500

iamontheinet

1329 ●3 ●9 ●27

Hi!

Replace your code with the following and it should work:

def upperCaseFirstLetter(fieldValue)    {
  StringBuilder ret = new StringBuilder(fieldValue.length());
  for (String word : fieldValue.split(" ")) {
    if (!word.isEmpty()) {
        ret.append(word.substring(0, 1).toUpperCase())
        ret.append(word.substring(1).toLowerCase())}
    if (!(ret.length()==fieldValue.length()))
        ret.append(" ")
  }
  return ret.toString()
}

for (record in records) {
  try {     

    //Uncomment to process ALL fields
    //for ( item in record.value ) {
    //  record.value[item.key] = upperCaseFirstLetter(record.value[item.key])
    //}

    //Process individual fields
    record.value['field1'] = upperCaseFirstLetter(record.value['field1'])
    record.value['field2'] = upperCaseFirstLetter(record.value['field2'])    

    output.write(record)
  } catch (e) {
    log.error(e.toString(), e)
    error.write(record, e.toString())
  }
}

Cheers, Dash

edit flag offensive delete link

Comments

Thanks Dash....It worked

srinath_222 ( 2019-01-09 14:22:05 -0500 )edit

You're welcome!

iamontheinet ( 2019-01-09 14:22:49 -0500 )edit

Hi Dash, I need to apply the function to all fields from source (suppose there are 100 fields from source). Instead of defining this method to each field, how can I define to all the fields ?

srinath_222 ( 2019-03-13 09:15:38 -0500 )edit

Look at the code I've already provided where it says "Uncomment to process ALL fields"

iamontheinet ( 2019-03-13 09:29:43 -0500 )edit

add a comment

Define a method in Groovy evaluator

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

Define a method in Groovy evaluator edit

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

Define a method in Groovy evaluator