I am having data in CSV file as follows in single column:Input:Company;C Desc;Region;R Desc;H;Hindustan;13;Maharashtra;I;Unilever;28;Dadra;I would like to change the data Text to Columns with Delimited ';' as follows:Output:Company   C Desc    Region    R DescH         Hindustan 13        MaharashtraI         Unilever  28        DadraKindly let me know the command to write this scenario in shell script.
text to columns in CSV
shell script;awk
If you have the column utility (most free Unices has):$ column -t -s ';' infile.csv >outfile.txt$ cat outfile.txtColumn ACompany code  Company Desc  Region Code  Region DescH             Hindustan     13           MaharashtraI             Unilever      28           DadraThen it's a matter of inserting the Column B, Column C etc., but it was not clear from the question if these were part of the input/output or not.EDIT: After the question was clarified:Replace the ; in the CSV file by commas using tr, then re-import the file into Excel.$ tr ';' ',' <infile.csv >outfile.csvExcel should also be able to import your original data if you specify ; as column delimiters.  I'm no Excel user though so I can't help with that.