Urgent Help needed for list box

[#1]

Hi All,

I have loaded two fields from qvd i.e., Brand and Short_desc. If Brand is null or space then it is renamed as 'Unknown' but for 'Unknown' Brand there is no Short_desc.

IF (len(Brand)<=11,Brand,mid(Brand,11)) as Brand_TXTSH

Here problem is why Brand_TXTSH is not having value 'Unknown'?

In a list box i need to display Brand_TXTSH&'-'&Short_Desc.

Brand	Short description_TXTSH	Brand_TXTSH
CA001MGS060206001	Bystolic	0206001
FI001	Forest Ireland	FI001
FI001MGS10CELEXA	Celexa	CELEXA
FI001MGS99OTHDIREC	Other Direct	OTHDIREC
FI001MGS060206001	Bystolic	0206001
FI001MGS090210001	Teflaro	0210001
FI001MGS131001001	Namenda	1001001
FI001MGS210907003	Savella	0907003
Unknown

Pl help..

[sbaldwin]

Hi without seeing the load script i couldnt say for should but looking at what you have done, the Brand field in the QVD you are renaming while loading but in the if statement above you are evaluating the source Brand field in the qvd (which is blank!), either apply the condition to the source field or do a preceeding load on the "amended" Brand field.

Thanks

Steve

[nagaiank · Accepted solution]

You may try the following:

IF (len(Trim(Brand))<=11,Brand,mid(Brand,11)) as Brand_TXTSH