Search Results

this seems to be pretty straight forward to me

transfer the file in bin mode from unix/linux system to windows

and open the file, specify the delimiter

and your file should be ready in...

you need to give us more information about the file.

What is the type of file ?

Is that a delimited file.
If so, what is the delimiter.

If thats some other file which needs to be processed...

Please refrain from posting email Ids.

Please read the rules of the forum.

Mod / Admin please remove the id.

Correct me if am wrong somewhere ! :)

I think basically you are looking for defined length values

check this out

var=first-second
var=`echo $var | awk '{ print substr($0, 1, 5) }'`
echo...

It would be better if you could provide sample input and sample output.

Your requirement is more like a one-liner which I find it difficult to guess what needs to be done.

awk -F"|" '/Real value/ { print $1, $4, $5 }' sourcefile > destfile

will transform to ( by adding the BEGIN block )

awk -F"|" 'BEGIN{printf "%s %s %s\n", "last_person_view", "last_person_edit",...

This was answered already in the previous replies.

Did you get a chance to look at those ?

awk <command> sourcefile > destfile

open destfile from excel with " | " as delimiter
you would...

I don't understand this properly though,

what do you mean by directly exporting this ?

extract the required fields from the log file and directly export into excel without a intermediate file,...

Cool,

requirement is getting precised now :p

If you are interested in fields 1 , 4, 5

awk -F"|" '/Real value/ { print $1, $4, $5 }' sourcefile > destfile

and the rest - exporting and...

So lines that have the string "Real Value" should be extracted from the log file

awk '/Real Value/ { print }' logfile > to_be_exported_file

Now this file should be opened in excel application...