Issue with substring function

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

av686165
Posts: 9
Joined: Fri Feb 14, 2020 5:53 am

Issue with substring function

Postby av686165 » Fri Apr 03, 2020 6:52 pm

I have a column named as DEAL_NUMBER which consists below four values,
2442660018000120000000
0000002442660018000124733590XAUUSDM
0000002442660018000124733590XAUUSD
0000002442660018000124733590AUDUSDM
0000002442660018000124733590AUDUSD

After using the substring($in.0.DEAL_NUMBER,12,16) function, the values has been transformed as below,
18000110798858
18000110798858
18000110798858
18000110798858
18000110798858

not sure, why the first record has been replaced by the below deal numbers. Pls help.

vitd
Posts: 4
Joined: Wed Apr 08, 2020 9:26 am

Re: Issue with substring function

Postby vitd » Wed Apr 08, 2020 10:23 am

Hello,

I do not understand what happens in your graph. Would you be so kind and place your sample graph as the attachment, please? The substring function should return:

Code: Select all

0120000000
0018000124733590
0018000124733590
0018000124733590
0018000124733590


Please check the attached graph
DealNumber.grf
(2.35 KiB) Downloaded 104 times
.


cron