RodM Posted August 17, 2013 Posted August 17, 2013 Hi ya all.. peace to the world! Problem Each line a,b,c,d,e, etc of my text variable is separate by return (13) character. However some lines might come okay as completely blank then end up printing blank lines.. on a large scale input AAAAAAAAAAAAAAAAAA BBBBBBBBBBBBBBBBBB DDDDDDDDDDDDDDDDD EEEEEEEEEEEEEEEEEE output look as: AAAAAAAAAAAAAAAAAA BBBBBBBBBBBBBBBBBB DDDDDDDDDDDDDDDDD EEEEEEEEEEEEEEEEEE TIA rod
Lee Smith Posted August 17, 2013 Posted August 17, 2013 Take look at the Trim4 custom function at Brian Dunning's site.
doughemi Posted August 17, 2013 Posted August 17, 2013 Or an auto-entered calculation Substitute(Self; "¶¶"; "¶")
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now