topic Re: Addinf character to a field in QlikView

Addinf character to a field

roee1983 — Mon, 05 Aug 2013 13:23:05 GMT

Hi all,

i have account field which looks like this:

40001

40002

40003

is there any chance to add "_" between the numbers 1 ,2 and 3.

for example:

4000_1

4000_2

4000_3

thanks

roee

Mon, 05 Aug 2013 13:30:43 GMT

left(account field,4) & '_' & right(account field,1) as newfield

er_mohit — Mon, 05 Aug 2013 13:31:04 GMT

try this

load accountfield,

left(accountfield,4) &'_'&right(accountfield,1) as AccountNEwField

from tablename;

Try this code Two possibility available

Data:

LOAD

Left(AccountField,4)&'_'&Right(AccountField,3) as SDEW,

Left(AccountField,4)&'_'&mid(AccountField,index(AccountField,'0')+3,3)as Show1, * Inline [

AccountField

40001

40002

40003

40004

40005

40006

40007

40008

40009

400010

400011

4000123

];

Mon, 05 Aug 2013 13:34:12 GMT

in text objec try this--

=left('40001',4)&'_'&right('40001',1)