[jira] [Updated] (NIFI-7810) Improvement for 'Translate Field Names' for PutDatabaseRecord and

["ZhangCheng (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-7810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

ZhangCheng updated NIFI-7810:
-----------------------------
    Summary: Improvement for 'Translate Field Names' for PutDatabaseRecord and   (was: Improvement for 'Translate Field Names')

> Improvement for 'Translate Field Names' for PutDatabaseRecord and 
> ------------------------------------------------------------------
>
>                 Key: NIFI-7810
>                 URL: https://issues.apache.org/jira/browse/NIFI-7810
>             Project: Apache NiFi
>          Issue Type: Improvement
>          Components: Extensions
>            Reporter: ZhangCheng
>            Assignee: ZhangCheng
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> 'Translate Field Names' in PutDatabaseRecord and ConvertJSONToSQL can help us map the field and column by
> {code:java}
> private static String normalizeColumnName(final String colName, final boolean translateColumnNames) {
>         return translateColumnNames ? colName.toUpperCase().replace("_", "") : colName;
>  }
> {code}
> but this rule `colName.toUpperCase().replace("_", "")` is fixed. I think maybe we can define the rule using Expression Language.
> It's vary useful for 'Translate Field Names', but sometimes, there will be column names such as 'AB' and 'A_B' in the table, and `colName.toUpperCase().replace("_", "")` can not help



--
This message was sent by Atlassian Jira
(v8.3.4#803005)