Search Results

Hi Guys,
The code snippet below is working fine with xls 2003 but the same is not working in xlsx 2007. Can someone please help.

#Convert .txt file format to .xls format
awk 'BEGIN{
FS="|"...

Thanks Johnson the double quote substitution worked.

Hi,
dirs.conf fine contains below data

/a/b/c/dir1|50
/a/b/c/dir2|50
/a/b/c/dir3|50


In a shell script I do as below

while read file_rec
do
dir_name=`echo "${file_rec}" | cut...

Hi Srinivas,
Thanks for the response.
One more issue now.
All the leading zeros are truncated when converted to xls.
How do I preserve them?

Thanks

Hi Ygor,
If the number of columns are more than 100, the above convert to html is not working.
Any solution if the columns are more than 100?

Thanks.

Hi,
When we issue a ps command we get some output.
From where does this ps command take the input from?

Thanks in advance.

Actually I tared the file with absolute path like the command below
tar -cvf sam.tar /home/sam

Now I want to extract /home/sam/E1.txt in sam.tar to /home/ram

Please help.

Thanks.

One more question
Where will the singlefile.dat be extracted. I dont want to overwrite any existing file.

Hi,
I want to view/display the contents of one file in tar file.
For example if the tar file is sam.tar.gz and one of the file inside is E1.txt, how do i view the contents of this E1.txt file.
...

Thanks all,
I got it.
Have a nice weekend.

I think I found the error.
Thanks all for the great help and inputs. really appreciate all.

One final question
how to remove all chars except numbers in a variable inside awk?
example
FED_ID =...

#set -x

nawk '{
split($0,arr1,"|")

ENTITY_TYPE = arr1[2]
if (ENTITY_TYPE ~ "O"){
ENTITY_TYPE = "B"
}
...

Can someone please help me on this?
Its kind of urgent..

Thanks a lot in advance.

I have changed the script to use awk only
example

awk -F "|" '{

#ENTITY_TYPE=`print "$line" | cut -d'|' -f2 | awk '{gsub(/^[ \t]+|[ \t]+$/,"");print}'`
...

Sure vgersh99,
I will do that from next time.
Can you please give code for doing that?

Thanks & Regards,

example of line
COL001 | P | 2007-02-01-00.00.00.000000 | | sam | babu | ...

example
how to write below line inside awk
ACCOUNT_DATE_OPEN=`print "$line" | cut -d'|' -f3 |sed 's/[^0-9]//g' | awk '{gsub(/^[ \t]+|[ \t]+$/,"");print}' | cut -c1-8`

vgersh99,
can you please let me know how to use
cut and sed inside awk program?

Thanks & Regards

I need help in awk please help immediatly.

This below function is taking lot of time
Please help me to fine tune it so that it runs faster.
The file count is around 3million records

# Process...