Differentiate between the # of characters in a field 1

[spiced]

I am using CR 7 and need to be able to be able to pull information on a 6 character entry as opposed to a 4 character entry?

 

[Naith]

Use the Length({field}) function, which I'm pretty sure is in 7.

 

[spiced]

I'm not that familiar with using formulas, please show me an example of how it would look.

 

[Naith]

From the Insert menu, choose Field Object.

Right click on Formula Fields, and select New.

Type a name for your formula.

Then in the formula window, you just type:

Length({ChooseYourFieldNameFromTheTopLeftExplorerWindow})

i.e.

Length({MyTable.MyField})

Naith

 

[Naith]

Stop the press for a sec. I've misread your post. I realise now that you want to only select records with 6 characters.

So, in your Record Selection Criteria (Report menu, Edit Selection Formula, Record), you would type:

Length({MyTable.MyField}) = 6

Naith

 

[spiced]

Naith,
It worked!

Thanks,
SPICE