Trim a string.

[rayscott]

I have a string that is a follows. "short01*002"
how would i go about writing a formula to trim the string to only give me everything to the left of the "*". The string has no set size. It can be 5 characters long or 20 characters.

 

[GJParker]

if Your string always contains a * then you can use a simple formula like this.

Left({MyField},Instr({MyField},'*')-1)

if a * is not present in the string then this will fail so you would need to use

NumberVar Position := Instr({MyField},'*')-1;

if position < 0 then
//do something here
else
Left({MyField},Position)

Hope this helps Gary Parker
Systems Support Analyst

 

[WBH1138]

Hi,

this line in your formula should do it...

Mid(YourString,1,InStr (YourString ,&quot;*&quot; ) - 1);

where YourString is the string containing &quot;short01*002&quot; or whatever.

Regards
Wayne

 

[synapsevampire]

Try:

if Instr({MyField},'*') > 0 then
Left({MyField},Instr({MyField},'*')-1)
else
&quot;N/A&quot;

-k