Script Entry

[#1]

Hey Guys

In my script i need to get rid of a whole bunch of '0's in a specific field namely StockCode. I only need to keep the last 5 characters. In the Script the field is loaded and joined to its description like this:

(%StockCode&'-'&SalesDescr) as ProductMaster.

Has anyone got any ideas on how to Delete the unwanted 0s?

[#2 · Accepted solution]

Hi Blaze,

what about this:

( Right( %StockCode,5) &'-'&SalesDescr) as ProductMaster.

[#3]

Brilliant worked like a charm however now it has created a blank field at the top of the data when put into a list box. Is there a way to get rid of this?

[#4]

Sorry it is not blank it is in fact a '-'

[#5]

Hi Blaze,

this depends on your data. I suppose that there is a nullvalue (or more, test it with "Show frequency") in one of the two input-fields.

RR