How to calculate position of Tab Character

[rlinsurf]

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?

[bruceR]

The tab character can be expressed as char(9).

Position( searchString; char(9); 1;1)

[rlinsurf]

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.

[Lee Smith]

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

[rlinsurf]

No, this is for a calc field. Unfortunately, for what I'm doing, find wont help me.

[Lee Smith]

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

[comment]

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.

[rlinsurf]

Both suggestions sound great.

But I haven't used the Code() function before. Can you tell me how to use it?