I have the attached file that I need to post-process with the following steps:
1. Take Subset of file
The post processed file should start with the section that has the header
"name number symbol initial wgt optimized wgt target wgt min wgt max wgt volatility partial 1 (and 2) partial 3 partial 4 partial 5 r-squared tilt value stock alerts"
2. Remove Column
Then the column "Stock Alerts" needs to be removed
The columns after removing the first section are tab delimited. I need to then BCP them into SQL Server. Can someone write either a python or a perl script to do this for me?
Strings in Python are the set of characters that, once defined, cannot be changed by any other method like replace. Even if we use the replace method it still does not modify the original string that we use, but just copies the string and then modif…
Flask is a microframework for Python based on Werkzeug and Jinja 2. This requires you to have a good understanding of Python 2.7.
Lets install Flask!
To install Flask you can use a python repository for libraries tool called pip. Download this f…
Learn the basics of if, else, and elif statements in Python 2.7.
Use "if" statements to test a specified condition.:
The structure of an if statement is as follows:
Use "else" statements to allow the execution of an alternative, if the …
Learn the basics of while and for loops in Python.
while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows: while <condition>: do something repeate: The break statement m…