https://community.qlik.com/t5/QlikView/Subdivide-String/m-p/2092118#M1224177 <P>Hello,</P> <P>I have an ID e.g. CG45984G1156GD42R46Z135466<BR />and now I want to subdivide it as follows:<BR />CG45984G-1156-GD42-R46Z135466<BR />So first after 8 characters should be a '-', then after 4 characters a '-' and then again after 4 characters a '-' and then the rest.</P> <P>Can anyone help me? Thank you</P> Mon, 10 Jul 2023 13:48:51 GMT Mahran 2023-07-10T13:48:51Z https://community.qlik.com/t5/QlikView/Subdivide-String/m-p/2092118#M1224177 <P>Hello,</P> <P>I have an ID e.g. CG45984G1156GD42R46Z135466<BR />and now I want to subdivide it as follows:<BR />CG45984G-1156-GD42-R46Z135466<BR />So first after 8 characters should be a '-', then after 4 characters a '-' and then again after 4 characters a '-' and then the rest.</P> <P>Can anyone help me? Thank you</P> Mon, 10 Jul 2023 13:48:51 GMT https://community.qlik.com/t5/QlikView/Subdivide-String/m-p/2092118#M1224177 Mahran 2023-07-10T13:48:51Z https://community.qlik.com/t5/QlikView/Subdivide-String/m-p/2092120#M1224178 <P>Left(String,8) &amp; '-' &amp; Mid(String,9,4) &amp; '-' etc.</P> <P>&nbsp;</P> Mon, 10 Jul 2023 13:51:02 GMT https://community.qlik.com/t5/QlikView/Subdivide-String/m-p/2092120#M1224178 Or 2023-07-10T13:51:02Z https://community.qlik.com/t5/QlikView/Subdivide-String/m-p/2092353#M1224182 <P>Thank you!</P> Tue, 11 Jul 2023 06:00:05 GMT https://community.qlik.com/t5/QlikView/Subdivide-String/m-p/2092353#M1224182 Mahran 2023-07-11T06:00:05Z