How to make BC9000 display as BC9000_ ?

[paulyeo11]

Hi All

I like to add the under score on the Product Name., For example

C9000-H119 become C9000-H119_

CX1900-0320 become CX1900-0320_

My existing code now is below :-

     Product as [PART_NO_],

I imagine it should be some thing like this :-

     Product as [PART_NO_],

  Product&'_' as [PART_NO_],

But it does not work.

Paul

[paulyeo11]

This is my QV doc.

[datanibbler]

Hi Paul,

say your fieldname (in the script) is > product_id <

=> Then, in the LOAD (script) you would go

LOAD

  ....

  ....

  product_id & '_' as product_ID

FROM ...

(so you would concatenate the actual contents of the field and an underscore)

HTH

Best regards,

DataNibbler

[Anonymous]

Try

Product&'-' as Part_No

[MK_QSL · Accepted solution]

Product&'_' as Product

[paulyeo11]

Hi All

Yes it work , thank.

Paul