topic Re: How to split entire file on two delimiters? in QlikView https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354721#M833917 <HTML><HEAD></HEAD><BODY><P>Hi Aaron,</P><P></P><P>Have a look at the attached file. I've used SubField and preceding load.</P><P>I'm not sure if this is the best solution for your data set, but I hope it will give you at least an idea of how this can be tackled.</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Mon, 12 Jun 2017 15:28:21 GMT daveamz 2017-06-12T15:28:21Z How to split entire file on two delimiters? https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354718#M833914 <HTML><HEAD></HEAD><BODY><P>Any help is appreciated. </P><P></P><P>I have a .dat file, with sections separated by ETX and SOH Ascii characters. I can split it by one or the other in Qlikview, but I need it by both. Is there a way to do this, or a way to replace all ETX with SOH in the entire file, and then I can delimit on just SOH?</P><P></P><P>The data in the document looks like this, and extends down for several rows.</P><P></P><P>orig_source[ETX]SO[SOH]header_created_by[ETX]Joe[SOH]header_created_date[ETX]06/02/17[SOH]</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354718#M833914 2020-11-25T16:16:04Z Re: How to split entire file on two delimiters? https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354719#M833915 <HTML><HEAD></HEAD><BODY><P>Are you loading this from a text file?</P></BODY></HTML> Mon, 12 Jun 2017 14:51:17 GMT https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354719#M833915 sunny_talwar 2017-06-12T14:51:17Z Re: How to split entire file on two delimiters? https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354720#M833916 <HTML><HEAD></HEAD><BODY><P>A .dat file</P><P>In my example code, the [ETX] is where an actual ETX character is</P></BODY></HTML> Mon, 12 Jun 2017 15:11:25 GMT https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354720#M833916 2017-06-12T15:11:25Z Re: How to split entire file on two delimiters? https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354721#M833917 <HTML><HEAD></HEAD><BODY><P>Hi Aaron,</P><P></P><P>Have a look at the attached file. I've used SubField and preceding load.</P><P>I'm not sure if this is the best solution for your data set, but I hope it will give you at least an idea of how this can be tackled.</P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Mon, 12 Jun 2017 15:28:21 GMT https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354721#M833917 daveamz 2017-06-12T15:28:21Z Re: How to split entire file on two delimiters? https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354722#M833918 <HTML><HEAD></HEAD><BODY><P>With this solution, would I have to do this for each row or column?</P><P>The actual data I'm working with extends on for much longer and deeper. </P></BODY></HTML> Mon, 12 Jun 2017 15:45:42 GMT https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354722#M833918 2017-06-12T15:45:42Z Re: How to split entire file on two delimiters? https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354723#M833919 <HTML><HEAD></HEAD><BODY><P>I'm sure that the real data set is much more complex and requires more tweaks.</P><P>In the attach there is an example of how the previous solution can be further extended. I've duplicate the rows, but I suppose in your .dat file, the rows are not separated by [CR][LF] special chars.</P><P></P><P>If the .dat structure is too complex I suggest you to look for an external tool (like a power shell script, python script etc.) to convert it to csv or some other readable format for qlik.</P><P></P><P>DAT files are pretty generic and there is no out of the box tool to suit every .dat file. You can read more here: <A href="https://www.lifewire.com/what-is-a-dat-file-2620550">https://www.lifewire.com/what-is-a-dat-file-2620550</A></P><P></P><P>Regards,</P><P>David</P></BODY></HTML> Tue, 13 Jun 2017 07:30:28 GMT https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354723#M833919 daveamz 2017-06-13T07:30:28Z Re: How to split entire file on two delimiters? https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354724#M833920 <HTML><HEAD></HEAD><BODY><P>Thank you for the extensive response. I got it figured it out now, thanks.</P></BODY></HTML> Tue, 13 Jun 2017 13:41:09 GMT https://community.qlik.com/t5/QlikView/How-to-split-entire-file-on-two-delimiters/m-p/1354724#M833920 2017-06-13T13:41:09Z