Finding the first 5 characters

[jcc31]

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

[Gar]

Try this Script:

Show all records

Go to Record/Request/Page(first)

Loop

If("Length (YOURFILEFIELD)<5")

Omit Record

Else

Go to Record/Request/Page [Exit after last, Next]

End If

End Loop

[Raybaudi]

Hi

the Gar script can't do what you asked for, because it finds all the records with more than 4 chars in the name, even if they don't match.

So give a try to the attached file :P

First5.zip

[jcc31]

Yeahhhhh!

That's what I'm looking for. Thanks a million.

[Raybaudi]

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]

[Raybaudi]

Check this file too !

I think that it's better because the script mustn't change layout

5chars.zip

[Gar]

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.