cyberchief Posted May 25, 2006 Report Share Posted May 25, 2006 how would I replace tabs in a string variable? Copying text from an excel file... and the string is pulling the tabs. I want to replace all tabs with a "Space". Quote Link to comment Share on other sites More sharing options...
cyberchief Posted May 25, 2006 Author Report Share Posted May 25, 2006 I found a work around... copied one of the tab feilds and did a modify string with that. Still, would like to know if there is a direct solution rather than this work around. Quote Link to comment Share on other sites More sharing options...
kevin Posted May 25, 2006 Report Share Posted May 25, 2006 A TAB is ASCII value 08. So you can do this: // Set T8 to ASCII char TAB Variable Set %T8% to ASCII Char of 8 // Replace all TABs with a space Replace "%T8%" with " " in %T90% Quote Link to comment Share on other sites More sharing options...
cyberchief Posted May 25, 2006 Author Report Share Posted May 25, 2006 Great!!! Thanks Kevin! As always, you are very helpful!!! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.