field?

[#1]

i have field like

sales contains data

sales:

100

200

300

here i want add before the data _  means like

sales:

_100

_200

_300

  how?

[#2]

You want to concat a '_' in front of every sales value?

[fkeuroglian · Accepted solution]

Hi in the script , create a new field

load *,

'_'&sales as SalesNew

from....

good luck

Fernando

[#4]

Load *

'_' & sales as FinalResult

From table

[gartigas]

If i understand rightly... in script you can write:

.....................

'_' & 'sales' als newSalesField,,,,,

........................................

regards

Gustavo

[Anonymous]

Hi Manoj,

Yes try:

In Script:

Load

' - '& sales as sales1

From TableName

Regards

Neetha