https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-Delimited-Column/m-p/11527#M2707 All,<BR /> <BR /> I have 10 columns in an audit table and one of this files has 3 pieces of description data that is seperated by semicolons. I need to break out the entire table into 12 columns. Being a very novice SAS EG User I am stuck. <BR /> <BR /> Any help, ideas would be appreciated. <BR /> <BR /> Many thanks<BR /> <BR /> Matt C. Wed, 04 Nov 2009 02:14:22 GMT deleted_user 2009-11-04T02:14:22Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-Delimited-Column/m-p/11527#M2707 All,<BR /> <BR /> I have 10 columns in an audit table and one of this files has 3 pieces of description data that is seperated by semicolons. I need to break out the entire table into 12 columns. Being a very novice SAS EG User I am stuck. <BR /> <BR /> Any help, ideas would be appreciated. <BR /> <BR /> Many thanks<BR /> <BR /> Matt C. Wed, 04 Nov 2009 02:14:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-Delimited-Column/m-p/11527#M2707 deleted_user 2009-11-04T02:14:22Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-Delimited-Column/m-p/11528#M2708 You could use the filter and query task, and there define three new calculated columns, using the scan function (documentation for syntax).<BR /> <BR /> /Linus Wed, 04 Nov 2009 11:03:01 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-Delimited-Column/m-p/11528#M2708 LinusH 2009-11-04T11:03:01Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-Delimited-Column/m-p/11529#M2709 That did the trick. Many thanks. Wed, 04 Nov 2009 17:06:08 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Convert-Delimited-Column/m-p/11529#M2709 deleted_user 2009-11-04T17:06:08Z