Sat Jun 25, 2022 7:48 pm
Login Register Lost Password? Contact Us

Please Note: The HPCC Systems forums are moving to Stack Overflow. We invite you to post your questions on Stack Overflow utilizing the tag hpcc-ecl ( This legacy forum will be active and monitored during our transition to Stack Overflow but will become read only beginning September 1, 2022.

leading zero's being stripped

Comments and questions related to the Enterprise Control Language

Thu Jan 30, 2020 6:44 pm Change Time Zone

My string is being trimmed.

I have tried STRING and STRING7 and in both the leading and end space are being removed. I need to keep them, any suggestions

STRING7 xx:=' '+'2'+' '+'3'+'4'+' ';


Output(' 2 34 ');

2 34
2 34

In another process, I am creating a file and despraying it. Here I tried to add the NOTRIM but it is still trimmed.

OutputJorudanLogical := IF(DoSort,OUTPUT(GSECSorted,,Outpath,CSV(NOTRIM,HEADING(Joru ...
(17.63 KiB) Not downloaded yet
Posts: 8
Joined: Mon Oct 07, 2019 5:57 pm

Thu Jan 30, 2020 7:10 pm Change Time Zone


This appears to be a cosmetic issue only in the ECL Watch results page.

In my testing, the results of these two queries are correctly displayed in the ECL IDE, but leading zeroes are missing in the ECL Watch display. IOW, the actual result value is correct but the display seems to automatically strip the leading spaces. This is probably an artifact of the difference between the way web pages and Windows programs display data.

Please submit a JIRA ticket for this issue.


Community Advisory Board Member
Community Advisory Board Member
Posts: 1619
Joined: Wed Oct 26, 2011 7:40 pm

Thu Jan 30, 2020 8:18 pm Change Time Zone

your are correct sorry. Found a macro some of my lower level code was calling and it did a trim. My BAD.

Posts: 8
Joined: Mon Oct 07, 2019 5:57 pm

Return to ECL

Who is online

Users browsing this forum: No registered users and 1 guest