We are parsing fixed length data and want to trim the trailing spaces. The character action doesn't appear to have an option to do as such. Maybe there is a tricky way somewhere to do so.
Thanks.
Hi David,
I believe this is possible but it's not particularly straightforward. Where is the value you wish to truncate? I'm assuming it's in a table?
Let me know.
- Justin
Hi
Actually, they are text fields on a screen. They are pasting a large block of data in fixed length format and I am parsing the data but need to trim spaces at the end of the block of text.
Could post to a table if that could help.
--David
David,
This is actually very simple to do. All you have to do is use one Enter Value Into Field On Screen action to take the value from your textbox and place it back in the same textbox. Method will automatically truncate any trailing whitespaces for you. :)
That is relatively easy. I must be doing something wrong because i don't see any change. The after looks exactly the same as the before :-(
-David
Could you try manually typing a string of characters with trailing whitespaces into the Textbox, then running the action I suggested in my previous post? Let me know the result.