Search Results

Thanks for your help and It worked fine.

I have already tried that option but I need to add "call sp_rebuildindex('<tablename>','column" each line. The table name should be copied from the previous line if the call doesn't exist on that...

Hi Guys,
I have a file which contains multiple lines. I need to split each line 255 characters and then I need to add call statement in the front and semi colon at the end.

I/P:
call...

Thank Don and Ron for your help. Solution you suggested worked fine without any issues.

I used sed 's/ / 0/g' filename
Please use CODE tags (as required by forum rules. Without CODE tags, multiple adjacent spaces and tabs are displayed as a single space.

Never mind and I figure it out easily by using sed replace command.

Thanks Don. I tried to change the OFS value but it didn't work. I am not sure how to fix this one.

Can we replace the empty spaces in the column to zero. If its empty while sending as an excel format the empty column is copied by adjacent column data.

Thanks and It worked fine as long as the rows and columns are same.

if the seventh line contains "2017/02/01 d 70" then it fails.

I am using Linux and I don't know how to accomplish this one.

I/P:
I/P:

2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/02/01 a 10
2017/02/01 b 20
2017/02/01 c 30

O/P:
a b c
2017/01/01 10 20 40
2017/02/01...

I am getting blank line after each line. How to get rid of that one?

---------- Post updated at 05:22 PM ---------- Previous update was at 04:58 PM ----------

It worked fine after removing the...

$ cat test
2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/01/01 a 60
2017/01/01 b 50
2017/01/01 c 40
$echo | mailx -s "Test Email" -a test xyz@xyz.com


SERIOUSLY: Please use CODE...

Thanks Don. It's a typo, I have tried without $4 and it worked as expected.

Hello,
I am trying to send an email with the below attachment in .xls file format by default its opening everything in a single column in the email. How to display the column in a separate column...

It worked for me.

awk '{a[$1" "$2]+=$3+$4}END{for (i in a){print i,a[i]}}' filename

I have a file which need to be summed up using date column.

I/P:

2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/01/01 a 60
2017/01/01 b 50
2017/01/01 c 40
2017/01/01 a 20...