I can convert a excel file to another format , for example text type ( TXT) whit anoter caracter from delimiter a rows ???
I can change the default delimiter " | " ( or space ) of cell to another caracter ( for example @@ or ## ) without change the other space ???
I am trying to understand what you are asking.
1) How to change row delimeters, or record delimiters?
2) How to change field delimiters or separators?
Can you please clarify, and perhaps include an example of input and output(desired)?
sorry , i change the colums (fields ) delimiter (default <space > in txt export )
i want another delimiter ( another caracter ) in output files export .
Are you trying to do this within Excel, or in unix script commands?
I guessing but I think they are wanting to Convert an Excel file to a text/csv type file in a shell script and be able to control the record and row delimiters.
i can use the shell script command ( ksh )
input :file excel
output : file csv ( or text file ) with , or another char with delimiter
i process the output file with awk ( no problem .... )
but with another tabulator ( not space )
can help me ???
Can you use tr or sed to pre-convert the data before your awk?
I just tried creating a quick excel file and then looking at the .xls file on unix; but was not very clear. Do you save the excel file normal format, or to csv or other?