How to easily create HTML table from Excel by using Sublime Text Editor

There is no question, that Sublime Text editor is the best editor I have ever had a privilege to work with. And on top, it’s been proving this fact day by day.

Recently I had to create an HTML Table from Excel file, so I tried to do it with Sublime Text Editor and I found it really easy.

1. Open Excel file

When I opened excel file, I saw something like this

excel_view

2. Select all and copy to the Sublime Text Editor

I selected all data and copied it to sublime text editor. I got this view

view_sublime

3. Let’s use Find + Replace tool to build a table body

I always use hotkey Ctrl + H, but you can use link from top menu – hotkey is always must more faster – so I’d recommend to remember this.

3a. Start <td>

Press Ctrl + H and fill following

sublime_start

  • Find what: ^
  • Replace with: <td>
  • Press Replace All or Ctrl + Alt + Enter

When you do this, you will get this image

sublime_start_finished

 3b. Let’s create last </td>

Press Ctrl + H and fill following

sublime_end

  • Find what: \n
  • Replace with: </td>\n
  • Press Replace All or Ctrl + Alt + Enter

When you do the 3 steps above, you will get this image

sublime_end_finished

3c. Complete </td><td> in between lines

This is quite tricky part, but we can do it again very easily. Press Ctrl + H and fill following

sublime_between

  • Find what:  + (there’s a space in front of + sign)
  • Replace with: </td><td>
  • Press Replace All or Ctrl + Alt + Enter

sublime_between_finished

4. Let’s use Ermet to complete table

Select all the text and press Ctrl + Alt + Enter

sublime_table

And finally press Enter and we are done.

sublime_table_finished

 

So as you can see, Sublime Text Editor is very easy to be used but it can do extra ordinary things as well. I’d recommend it to everyone and as I said before, Sublime Text Editor is the best editor I have ever worked with.

Great job guys.

Trust in Jesus always

10670244_986671924691743_9102366448750991862_n

Is Jesus really who he was claiming he is?

Is Jesus really who he was claiming he is? He said in John 14:6 – I am the way, the truth and the life. No one can come to the Father except through me. I was going through the study and they were saying – that this statement can be equal to someone saying – I am a fried egg or I am a Christopher Columbus.   So why people would believe him?

In order to be believable, you must “back up” your words with your action. You cannot just say it and hope they are going to believe me. But you have to support your statement with actions. Even Jesus himself was saying – Do not believe to me because what I say, but believe to me because what I do in my Father’s Name.

As you have a closer look on Jesus life, you can clearly see, that he fulfilled this part.His life was foretold many years before He was born and the way how he lived gave him an authority to declare this statement. The way how he took care about outcast and people separated from the society, how he never doubt his purpose on the earth, how you endure all beating and bad behavior and on top, we accepted a painful death on the cross for our sins – He really had an authority to declare that He is the way, the truth and the life.

Many people do not want to accept that there is only One way. Even some religion struggle with this idea and trying to change the fact. But I pray that the eyes of the people will be opened and they will clearly see, that Jesus Christ is the Lord, He is the only One way and we have to accept it as the fact.

1 Timothy 2:5 tells us: For there is one God and one mediator between God and mankind, the man Christ Jesus.  There is no-one else through whom we can go to heaven, only by Jesus – No one can come to the Father except through me (John 14:6). 

I believe that if people understood that Jesus was not a liar or lunatic, but he really is the only One way, there wouldn’t be so many conflicts nowadays.

I pray that the Lord will open your eyes and you will clearly see who Jesus is. He is the Lord and the Savior of the world. He is our great advocate, the High Priest, the very best friend. Father have a mercy upon your children and give them understanding hearts and eyes so they can come closer to you – into your very presence. Bring light upon their lives and let them clearly see. I break any chain of darkness from their eyes and I open them in Jesus Mighty Name. Thank you for listening to my prayer. You are Great and Mighty King. In Jesus’ Mighty Name I prayed.

God did not promise ….

God didn’t promise
days without pain
laughter without sorrow
sun without rain,
but He did promise
strength for the day
comfort for the pain
and Light for the way.

Fix your bash because of Shellshock

My dear friend Olek sent me this code to fix a bash on my VPS. It’s because of a mistake called ShellShock. It might be useful for someone else as well. I hope I do not need to remind you that you must be logged as root in order to run this script.

mkdir src
cd src
wget http://ftp.gnu.org/gnu/bash/bash-4.3.tar.gz
for i in $(seq -f "%03g" 0 25); do wget http://ftp.gnu.org/gnu/bash/bash-4.3-patches/bash43-$i; done
tar zxvf bash-4.3.tar.gz 
cd bash-4.3
for i in $(seq -f "%03g" 0 25);do patch -p0 < ../bash43-$i; done
./configure --prefix=/ && make && make install
cd .. 
cd ..
rm -r src

I have travelled with Ryanair

Yesterday I had a chance to travel with Ryanair for the first time in my life. I do not fly often, but for this time, I decided to give him a chance – simply because of the price (let’s call the thing with its own name :)).

When I was talking with my friends, they told me that I have to pay extra for priority boarding and also I should allocate the seat for me. But I decided to do not do this and see how it goes without this extra charges – and I can say that I was amazed.

Priority boarding – from what I have understand is only for families or for lazy people. Even though I didn’t have a priority boarding, I was maybe the 10th person who passed a boarding gate – and the flight was quite busy (the plane was almost full). Another thing what people with priority boarding had and me not was a place to sit while waiting for the plane to get ready for us to go in. But because I am still a young man, I can manage to stay for 10 minutes.

Allocate your seat – again, I didn’t see the point of paying another 5 euro for this or even 10 euro if I want a seat in better area of a plane. I left Ryanair to give me a place – and I believe I’ve got better place than I would have chosen by myself ;).

The overall feeling with Ryanair was good – crew were o.k., smilling all the time, making jokes and helpful. The pilots were also great and we arrived to our final destination without any problem – with little bit delay, but safely.

Only what I would suggest to everyone who is travelling with them is to buy a bottle of water and something to eat before they go to the plane – it would be cheaper for you than to buy a meal in the plane.

And one thing that always amazing me is that even though we were 11 000 km above the earth, we were still able to pay with credit card. Even though I am a developer / programmer – this things always amazing me.

Let see how it will be on my way back on Monday.

My short visit of the Czech republic

Tomorrow, Friday 19th September 2014, I am flying to the Czech republic. My mom is getting married on Saturday – yes, you read correctly – she’s getting married – may God bless her marriage and I have to participate / as a good son.

I had a quick look on weather there and there’s a big change that I will experience a rain again. I do not even remember when was the last time we have had a rain in Limassol, so I am looking forward to enjoy it in the Czech republic. But the truth is that I have been 2 times in Czech republic since I came to Cyprus and every time I’ve visited them, it was always the hottest week in that year.

So we will see how it will be this time.

Why it is so important to pray?

The prayer should be a normal part of every Christian life. But why so many Christians neglect it?

  • Is it really so important to pray?
  • Is God really listening to our prayers and will He ever answer them?
  • How often a day should we pray?
  • How should we pray?
  • Where should we pray?
  • What the Bible says about prayers

These are some of the question which we have been asking. But the God has always an answer to all of our questions.

Is God really listening to our prayers and will He ever answer them?

First of all it’s good to clear out one thing. God can hear and God can talk. If you cannot believe to this, the way is to have a look into Bible and find out what is written there about this matter.

Bible is saying that God can hear because in 2 Corinthians 7:14 (KJV) is written …. I will hear them from Heaven. God can also speak because in Genesis, when God was creating the earth the word SAID is mentioned so many times, that it makes it extremely easy for us to believe that God can speak.

Is it really so important to pray?

But why the question – is it really important to pray? came to my mind? One day during my prayer, I was quoting John 14:12-13 (NKJV)

Most assuredly, I say to you, he who believes in Me, the works that I do he will do also; and greater works than these he will do, because I go to My Father. And whatever you ask in My name, that I will do, that the Father may be glorified in the Son

and what stuck to my mind was the part – whatsoever ye shall ask and it brought the revelation to me that the prayer is really very important in our lives.

Bible is telling us in many places, that we can ask and our requests / question will be answers. But how can I ask and keep my mouth closed. It is simply impossible. Every time I want to ask for something I have to open my mouth and start talking. And when I talk, I talk to God and I am praying.

What is the prayer?

Prayer is simply a communication with God. You can call God your very best friend and never talk to him. Prayer is not a magic, you do not need to say any secret word to start praying, you can just close your eyes and start talking to God and tell him what bothers you, what you want from Him and thank Him for the things He has done for you. Even if you do not know how to pray, pray with from your heart and Holy Spirit with guide your words.

Recently I have read a book Understanding the purpose and power or Prayer – Earthly license for heavenly interference written by Dr. Myles Munroe. It is a great book explaining the principles how to pray, why some of your prayers might not be answers and what are the hinders for unanswered prayers. If you want to know more about prayer, please have a look to this book and I pray that you will get more understanding about prayers in Jesus Name.

My prayer for you: Heavenly Father, I pray for your people, that they will understand the importance of prayer and they will spend more time in communication with You. I pray that when they humble themselves, they seek your face and they pray to you, You will hear them from heaven and answer their prayers. I thank You that your ears are always there for us and that none of our prayers will come back void to us. In the name of your Son Jesus Christ I prayed. Amen.

Codeigniter – Another PHP framework to learn

I have worked with many frameworks in my career as PHP Developer. I’ve built projects in Zend Framework, CakePHP, in pure PHP, by using WordPress or Joomla, but one of my client bought a script, which is written in Codeigniter so it’s time to learn it and add it to the group of PHP frameworks which I am familiar with.

Let’s see how it will go and I hope it won’t be so far away from CakePHP or Zend Framework, so the study will be easier.

Why did I switch to WordPress

Many times in the past years, I put myself before question – should I continue with development of my own CMS built on CakePHP or should I start using WordPress and start developing on it? I was telling myself – is it good to use WordPress when I claim to be a CakePHP developer? Or if I start using WordPress, will they still believe me that I can develop in CakePHP? Etc etc. Most of the time, the CakePHP has won and I put WordPress aside.

But couple of days ago, I tried to do something for our company’s client whose website in on WordPress and I was amazed with what WordPress guys have done so far. So for the first time in my life, I decided to put CakePHP aside and install WordPress.

I found a template which is not the best, but it looks good and let see, how it will go. I will use WordPress for a while and I will see after one two months whether I like it or not. There’s always a way back to CakePHP, but I believe only for very custom projects.

© 2014 Tomas Pavlatka

Theme by Anders NorenUp ↑