datalink Posted January 27, 2009 Share Posted January 27, 2009 In a multi-key field which is delimited with hard returns we have a number of lines with only the hard return because of an import process. I want to run a calculated fill down to strip out the lines that have only the delimiter and no actual data. I was thinking I'd use the substitute function to substitute the hard return with "", but I'm not sure how to get just the empty lines. Link to comment Share on other sites More sharing options...
comment Posted January 27, 2009 Share Posted January 27, 2009 See if this helps: http://fmforums.com/forum/showtopic.php?tid/199290/ Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5565 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