https://community.qlik.com/t5/App-Development/Unable-to-split-a-field-in-Data-Manager/m-p/1639208#M47653 <P>I am working with table definitions in the Data Manager, for data imported from a comma-delimited text file.</P><P>Some fields contain 0-n URLs (separated by semi-colon), and I would like to have at most one URL per field.</P><P>The Split function is ideal for this, of course.&nbsp; However, the problem is that the rows that actually have a second semi-colon are so far down, that Qlik Sense does not find them to include them in the sample rows that I am permitted to use to define splitting.</P><P>There needs to be a search function to be able to find such rows, as well as the ability to specify the delimiter without reference to a sample row.</P><P>René Valencourt</P> Sat, 16 Nov 2024 19:49:34 GMT plexpro52 2024-11-16T19:49:34Z https://community.qlik.com/t5/App-Development/Unable-to-split-a-field-in-Data-Manager/m-p/1639208#M47653 <P>I am working with table definitions in the Data Manager, for data imported from a comma-delimited text file.</P><P>Some fields contain 0-n URLs (separated by semi-colon), and I would like to have at most one URL per field.</P><P>The Split function is ideal for this, of course.&nbsp; However, the problem is that the rows that actually have a second semi-colon are so far down, that Qlik Sense does not find them to include them in the sample rows that I am permitted to use to define splitting.</P><P>There needs to be a search function to be able to find such rows, as well as the ability to specify the delimiter without reference to a sample row.</P><P>René Valencourt</P> Sat, 16 Nov 2024 19:49:34 GMT https://community.qlik.com/t5/App-Development/Unable-to-split-a-field-in-Data-Manager/m-p/1639208#M47653 plexpro52 2024-11-16T19:49:34Z