Search Results

As I explained previously, CSV files don't preserve the cells formats, and you need them to keep leading zeroes.
So I suggest as a workaround : generate Excel XML files from your application.
The...

This problem is only from the Excel side.
If you simply create a sample excel file, with leading zeroes, they will disappears as useless in type number.
Then try to change the cells format to text...

I'm very puzzled with Don's trick using ...{$1=$1 ; ... .It makes specific expansions on $0 using FS and OFS variables

Of course it works very fine on my PC cygwin version, as I have the most...

You can try to add this filter that converts | to ","
... some code ...|awk -F\| -vOFS='","' '{print "\"" $1,$2,$3,$4 "\""}' > A4.txt Jean-Paul

please give samples files.

you wrote:


so output files can't have comma as separator in such case, unless you surrounds data with double-quote ( " ) for instance .