Jump to content

Finding the first 5 characters


 Share

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

Recommended Posts

Hi, is there way that I can find the first five characters in a field that matches WITHOUT putting in any words or letters. I was think something like wildcards. So in the example below, I would get all Disable and all Molly records because they match.

Example:

Name

Disable smiles

Disable me

Jack Daniels

Joe Moe

Molly Brown

Molly Black

Link to comment
Share on other sites

Hi

as you had tried, my example file works...

but I noticed that it finds empty name field too.

This can be of some utility, but if you don't want them, go to change the sixth row of the script "Find" to this:

If[status(CurrentPortalRow )[color:red]<= 1]

Link to comment
Share on other sites

Raybaudi

You are absolutely right, I stand corrected.

I concentrated on the "more than 5" part and missed the matching completely.

I looked at your example. Cool! I rarely do any portal work and now I see some of what I have been missing.

Link to comment
Share on other sites

This topic is 5765 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
 Share

×
×
  • Create New...

Important Information

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