Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Product&'_' as Product
This is my QV doc.
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
Try
Product&'-' as Part_No
Product&'_' as Product
Hi All
Yes it work , thank.
Paul