Jump to content

Playing Wack-a-nul


This topic is 3005 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

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

This topic is 3005 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.