6 Replies Latest reply: Nov 25, 2010 8:10 AM by umangu2000 RSS

    Changing the way data is displayed within a field

    Chris Hopkins

      Hi,

      I have a field called 'Narrative', Within this field are loads of descriptions (See attached spreadsheet)

      What i want to do is group them together and rename them.

      e.g.

      All descriptions starting with 'Goods ' to be renamed 'Goods Received'

      All descriptions starting with Stock' to be renamed 'Stock Check'

      I know how to do this within the application :

      =IF(UPPER(Narrative) like 'Stock*','Stock Checking' ,Narrative)

      but i want to do it in the load script. Can anyone tell me if it can be done please?