October 1, 201015 yr I have the following search string: Paragraph-Tab-Tab-Space-Paragraph-Paragraph. I've tried using the "¶" and Option-Tab and then a standard space, as well as Option-Space, in different combinations, but they all fail. Can someone direct me as to how to do this?
October 1, 201015 yr The tab character can be expressed as char(9). Position( searchString; char(9); 1;1)
October 1, 201015 yr Author Well, I'm stumped. I put in your suggestion of char(9), but it's still failing. Here's a screenshot from word of what the string looks like. Looks like it's the space character, which is right before the second paragraph mark, that's screwing this up.
October 1, 201015 yr Are you trying to do this in find mode? Try using the menu Find/Replace under Edit. IIRC, you can past in a pattern from a document and find it in a field. HTH Lee
October 1, 201015 yr Author No, this is for a calc field. Unfortunately, for what I'm doing, find wont help me.
October 1, 201015 yr Ok, then have you looked at the text in BBEdit or TextWrangler? There can be some incidental spaces, etc. that will not show in word, but will show in a text editor such as I mentioned. Just be sure when the document is open, you select the show invisibles, and spaces. HTH Lee
October 1, 201015 yr Looks like it's the space character, which is right before the second paragraph mark, that's screwing this up. You can use the Code() function to determine the exact character/s in the field. If you still can't make it work, post a file.
October 2, 201015 yr Author Both suggestions sound great. But I haven't used the Code() function before. Can you tell me how to use it?
Create an account or sign in to comment