Method:Classic General Q&A

Re: Is there a way to trim spaces from a field?

Method_Justin — Thu, 15 Jan 2015 23:02:22 GMT

Hi 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.

- Justin

Re: Is there a way to trim spaces from a field?

DavidGlantz — Thu, 15 Jan 2015 22:54:15 GMT

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

Re: Is there a way to trim spaces from a field?

Method_Justin — Thu, 15 Jan 2015 19:17:49 GMT

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. :)

- Justin

Re: Is there a way to trim spaces from a field?

DavidGlantz — Thu, 15 Jan 2015 01:57:58 GMT

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.

Thanks.

--David

Re: Is there a way to trim spaces from a field?

Method_Justin — Wed, 14 Jan 2015 17:05:58 GMT

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

Is there a way to trim spaces from a field?

DavidGlantz — Wed, 14 Jan 2015 15:04:42 GMT

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.