Friday, August 30, 2013

Macros in Text Pad - Automate repetitive work for bulk data

Posted by Sharath Chandra
Hi Friends, 

Text Pad Trick on Macros / Auto Mated Script to do repetitive tasks for Bulk Data.
For example for the below fifty US states - if we want to add single quote and comma 

AL AK AZ AR CA CO CT DE FL GA HI ID IL IN IA KS KY LA ME MD MA MI MN MS MO MT NE NV NH NJ NM NY NC ND OH OK OR PA RI SC SD TN TX UT VT VA WA WV WI WY

This we can do with Macros. 

  •  Open Text Pad [Obviously :P]
  •  Paste the raw data and place the cursor in the beginning.
  •  Go to Menu Bar – Macros -> Click on ‘Record’.
  •  Now it will record your actions which you are planning to do on all the  remaining data – So according to our requirement we need “‘” quote on  AL so place that and click “control+ -> (arrow towards right)” it will  reach the end of AL so now again we need to place “’” and click  “Control+->”
  •  Stop the Macro from Menu Bar –Macros -> Click on “Stop the Macro” - It  will prompt you to save. Give req fields data and save.
  •  Now Click on Menu Bar – Macros -> Click on Multi-Play or Just Ctrl+F7.  Prompt you to ask – Check for the End of the file option.
  •  You are done! Out put will be like  'AL', .... 'CA',  'DC',  'DE',  'GA',  --- 'WV',  'WY'


Keep Sharing -  Because in
 Knowledge Sharing is Gaining.