Wrapping the field values at script level

[sudeepkm]

Hi,

I've a table with fields like below

id     address

1      abcdefr

2      abcdreftt

3      abdcsdfgtr

4      abbqweds

5      abbcddfgf

6      acvbjhgfdd

I would like to wrap this dynamically for each 3 chars of the field address.

I can have a solution like below but need to do it dynamic.

if(len(address)>3,left(address,3)&chr(10)&right(address,len(address)-3)) as newaddress

the newaddress will have values like below

id    newaddress

1     abc

       defr

2    abc

      dreftt

3    abd

      csdfgtr

but what I'm trying to achieve is like below

id    newaddress

1    abc

      def

      r

2    abc

      dre

      ftt

3    abd

      csd

      fgt

      r

I'm creating alerts in QlikView. Since the alerts Subject panel does not have format options or options for embedding charts/tables so I'm trying to create a table like format for the data to be put in the Alert Subject section. Some lengthy field values are creating trouble so I'm trying to wrap them.

Any suggestions please. Thanks in advance.

[evan_kurowski]

Sudeep Mahapatra wrote:

Just one thing which I found is that when I use spaces in the values of the Field address the newaddress field is changing.

I'm not sure if I see the values of newaddress changing, but they don't enforce sort according to the input sequence.  If you want to enforce FIFO, I added that.

(i.e.  address = 1AU2BE3CO4HE

newaddress =      1AU

                             2BE

                             3CO

                             4HE)