Search Results

hello

i tried this

ldescamp@D06613 /cygdrive/y/20090130/test
$ echo "Filename,IP address,PC name,destination,UTC begin,UTC end,destination IP address,duration (ms),local begin,local end,source...

i tried like this

find * -type f -name "*.ipfx_audio" -exec awk -F= -vOFS="," '
NR == 1 {HD = "Filename=IP address=PC name=destination=UTC begin=UTC end=destination IP address=duration...

nearly there. now i m doing this

find * -type f -name "*.ipfx_audio" -exec awk -F= -vOFS="," '
NR == 1 {HD = "Filename=IP address=PC name=destination=UTC begin=UTC end=destination IP...

hi,

i still need -vOFS="," as i want some comma :-)

but tidy up like this

awk -F= -vOFS="," '
NR == 1 {HD = "Filename=IP address=PC name=destination=UTC begin=UTC end=destination...

i ran this
awk -F= -vOFS="," '
NR == 1 {HD = "Filename=IP address=PC name=destination=UTC begin=UTC end=destination IP address=duration (ms)=local begin=local end=" \
...

i tried to a filename header like this

awk -F= -vOFS="," '
> NR == 1 {HD = "FILENAME=IP address=PC name=destination=UTC begin=UTC end=destination IP address=duration (ms)=local...

ok i did this

awk "-F=", -v HD="IP address,PC name,destination,UTC begin,UTC end,destination IP address,duration (ms),local begin,local end,source IP address,actual extension,original called...

@ RudiC: sorry for the code tag. will pay more attention in the future
@Scrutinizer: you didnt waste your time. I ve learnt a lot from the thread. i wanted to start simple and built around it. Sorry...

Hi,

i had a look on the actual server and found some issues

the files dont always contain the same info.

for example, these 2 files.
one got destination but doesnt have pc name

Filename1...

Hi
awk '{print FILENAME,$2,$4,$6}' FS=':|\n' OFS=, RS= file*.txt
would only search files in the root directory. is there a way to search subfolders?
many thanks

Hi Don,

below my answers

How are we supposed to determine the department from the data you have shown us?
Yes, the ""called" data will tells me what department

Will there be any files in...

the final idea is
i have 12 millions call recorded files. each file got a header with details of the call. files are in folders. for example, a file created at 20hr25min36sec on the 2nd of march...

thanks Scrutinizer

is there a way to use awk recursively ?

hi

i need to extract lines from multiple files to a csv file.
for example, i have these 3 files

file1.txt
date:29dec1980
caller:91245824255
called:8127766

file2.txt
date:11apr2014...