Hijack Posted December 9, 2015 Share Posted December 9, 2015 I have a solution that has some records that have somehow (via imports of the years, bad data entry by users, hanging a horseshoe the wrong way, etc) gotten NUL characters in some text fields. This is playing havoc on some scripted processes I use to concatenate data across multiple fields into the clipboard for quick transfer to other apps. The NUL is stopping the process somehow. So, I'd like to clean this character from the fields when it's found. But a general Substitute ( text ; searchString ; replaceString ) doesn't work since I can't specify the nul. "Char (0)" returns an "empty string" instead of the character according to FM Help and in application, this seems to be true since the substitution is not catching the character. Any ideas on how to filter out this character en mass? Thanks Link to comment Share on other sites More sharing options...
comment Posted December 9, 2015 Share Posted December 9, 2015 Try pasting a NULL character into a global field, then do Substitute ( text ; gField ; "" ). 1 Link to comment Share on other sites More sharing options...
Hijack Posted December 9, 2015 Author Share Posted December 9, 2015 comment for the win! That did the trick. Sometimes a fresh perspective on a simple task is all that's needed. Thanks for the help. David in Fishers Link to comment Share on other sites More sharing options...
Hijack Posted December 9, 2015 Author Share Posted December 9, 2015 Need to clarify for future finders of this post... I was unable to paste the nul into a global since it seems that the FM interface filters this from pasting. I had to import a text file holding the nul into a global and then referencing the global in the substitute function. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3188 days old. Please don't post here. Open a new topic instead.
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