Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

How to calculate position of Tab Character

Featured Replies

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?

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

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

  • 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. paragraph_string.png

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

  • Author

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

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

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.

  • 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

Important Information

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

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.