I created the below program that copies Column B to Column C using Excel as a database action.
There is a side effect for the insert/update/delete action at line 5; that does not keep the trailing spaces after "aa " in line 2 after the copy.
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/a14dec76-0e99-4968-b900-0ec7efb59243.png)
So, when I check for equality after the copy only lines 3,4,5,6,7 are considered equal.
Is there a way to keep trailing spaces and prevent this automatic trimming behavior?
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/28519e0c-679a-4b85-8837-7f624370c4eb.png)