topic Re: Formatting Issue in removing decimal points in Data Quality

Formatting Issue in removing decimal points

Anonymous — Sat, 16 Nov 2024 08:50:05 GMT

Hi Folks,

I have an input file in that the variable data is like below,

3038604370221.23

In tMap, the mapping is like below, and for the variable ACCT_LEVEL_1 I want to transform to remove the decimal point. And keep the number as 3038604370221. But when I run the expression like below I am receiving the error as

'java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(Unknown Source)
at routines.StringHandling.LEFT(StringHandling.java:229)'

Expression:

StringHandling.LEFT(row1.ACCT_LEVEL_1,StringHandling.INDEX(row1.ACCT_LEVEL_1,"."))

Re: Formatting Issue in removing decimal points

Anonymous — Fri, 19 Jan 2018 15:45:27 GMT

Do all values of ACCT_LEVEL_1 contain a decimal point? If not you will receive this error as StringHandling.INDEX will return -1 if the value is not found.

Re: Formatting Issue in removing decimal points

lojdr — Fri, 19 Jan 2018 16:27:35 GMT

Hello,

What about something like this?

Regards

lojdr