How do I shorten a string 2

[scottpdann]

I have a field with values like

B7527*2*2004
B7527A*2*2004

Is there a formula to convert it so that every character from the first * and right disappear. Looking like this

B7527
B7527A

Thank you.

 

[kchaudhry]

If you know the exact length you can use a formula like this

{Table.field} [1 to 3]

This will only return the first three characters from the field.


Kchaudhry

 

[scottpdann]

That will solve part of the problem.

I will still get records like

B7527A Which is fine

and

B7527* Which is not.

If I take those results and, can i then write a formula dropping the asterik from the ones that are left?

 

[vidru]

Try this:

left({table.field}, instr({table.field}, "*&quot - 1);

-dave

 

[bdreed35]

Try this:

Left({table.field},Instr({table.field},"*")-1)

~Brian

 

[kchaudhry]

I guess I was a couple of minutes late to post my suggestion

Kchaudhry

 

[scottpdann]

Thank you vidru and bbreed35. That worked.