I need a new line and a blank line to create new lines for each of the games. I need to be able to have the date, the game and the team, and the score. When I take all the lines into new lines I get "Previous 76ers set franchise record with 15th consecutive win, 'Jonlshaw', 7b17bfd26b, 'alvendi pro full crack', 521" instead of "Previous 76ers set franchise record with 15th consecutive win, Mar 28, 2014, 7:03 PM, Philadelphia 76ers, Niklshaw"
I want it to be "Previous 76ers set franchise record with 15th consecutive win, Mar 28, 2014, 7:03 PM, Philadelphia 76ers, Niklshaw". Also the line after "Previous 76ers set franchise record with 15th consecutive win" should be blank.
A:
After seeing the fixed code, I can see the source of the problem is that you are using rjust to add a space, and it replaces the single space before the timestamp with the two spaces. rjust does what it says - adds a space.
You can solve it using regex and str_replace. Try this:
df Q:
How to determine whether a numeric value will be the min or max of the range of numbers?
As I'm using Excel 2010 I'm restricted to formula only solutions.
I want to determine whether a number will be the minimum (lowest) or maximum (highest) of a range of numbers.
I would prefer a formula solution as I'm dealing with quite a lot of data.
Using the formula MAX([1,2,3,4]) gives the wrong result when evaluating it for 6 but yields the correct result for 8.
Using the formula MIN([1,2,3,4]) gives the correct result of 2 but for 6 the result is 1.
I need a formula that will evaluate 1 or 2 for 6, 2 or 3 for 8 and so on for both the minimum and maximum values.
A:
If you want to get minimum or ac619d1d87
Related links:
Commenti