topic How to mask? in App Development

topic How to mask? in App Development https://community.qlik.com/t5/App-Development/How-to-mask/m-p/1955640#M78802 <P>I have a field which contain 17 digits i will like to split it.</P> <P>turn this:</P> <P>00120190139007009</P> <P>into this:</P> <P>001201-9-0139-007-00-9</P> <P> </P> Thu, 14 Jul 2022 07:38:57 GMT YanivZi 2022-07-14T07:38:57Z How to mask? https://community.qlik.com/t5/App-Development/How-to-mask/m-p/1955640#M78802 <P>I have a field which contain 17 digits i will like to split it.</P> <P>turn this:</P> <P>00120190139007009</P> <P>into this:</P> <P>001201-9-0139-007-00-9</P> <P> </P> Thu, 14 Jul 2022 07:38:57 GMT https://community.qlik.com/t5/App-Development/How-to-mask/m-p/1955640#M78802 YanivZi 2022-07-14T07:38:57Z Re: How to mask? https://community.qlik.com/t5/App-Development/How-to-mask/m-p/1955667#M78804 <P>as below</P> <P> </P> <P>=left(fieldname,6)&'-'&mid(fieldname,7,1)&'-'&mid(fieldname,8,4)&'-'&mid(fieldname,12,3)&'-'&mid(fieldname,15,2)&'-'&right(fieldname,1)</P> Thu, 14 Jul 2022 08:05:09 GMT https://community.qlik.com/t5/App-Development/How-to-mask/m-p/1955667#M78804 vinieme12 2022-07-14T08:05:09Z