User:IPodwithnomusic/Links

https://www.amazon.ca/OtterBox-DEFENDER-Case-iPad-Air/dp/B00PUOK150 https://www.bestbuy.ca/en-ca/product/griffin-survivor-rugged-folio-case-for-ipad-air-1-2-ipad-9-7-2017-2018-ipad-pro-9-7-black/11556343.aspx? https://docs.microsoft.com/en-us/dotnet/framework/winforms/controls/windows-forms-controls-by-function https://stackoverflow.com/questions/18949385/c-sharp-sound-effect-added

My Reviews
Amazing Spider-Man Epic Collection Vol. 15: Ghosts of the Past https://www.amazon.ca/gp/customer-reviews/R3806WU0NHOO9D Amazing Spider-Man Epic Collection Vol. 20: Cosmic Adventures https://www.amazon.ca/gp/customer-reviews/R1LBY6H3PIDNU8 Avengers Epic Collection Vol. 3: Masters of Evil https://www.amazon.ca/gp/customer-reviews/RT0ZX5A9NX9NB Avengers Epic Collection Vol. 16: Under Siege https://www.amazon.ca/gp/customer-reviews/R3I2AVY9TQY7WR Captain America Epic Collection Vol. 12: Society of Serpents https://www.amazon.ca/gp/customer-reviews/R1R90YKRYMTOS7 Captain America Epic Collection Vol. 13: Justice is Served https://www.amazon.ca/gp/customer-reviews/R3591PV2H9OMHP Captain America Epic Collection Vol. 15: The Bloodstone Hunt https://www.amazon.ca/gp/customer-reviews/R9GGIVZTP8I3Y Captain America Epic Collection Vol. 16: Streets of Poison Daredevil Epic Collection Vol. 13: A Touch of Typhoid https://www.amazon.ca/gp/customer-reviews/RD83BTPVSHA5R Daredevil Epic Collection Vol. 14: Heart of Darkness https://www.amazon.ca/gp/customer-reviews/R37HA7S7JTZ33F Daredevil by Ed Brubaker & Michael Lark Omnibus Vol. 1 https://www.amazon.ca/gp/customer-reviews/R3IJ160RR5636N Daredevil by Ed Brubaker & Michael Lark Omnibus Vol. 2 Elektra by Peter Milligan, Larry Hama, and Mike Deodato Jr. https://www.amazon.ca/gp/customer-reviews/RK39JOA2AA0KC Iron Fist Epic Collection: The Fury of Iron Fist https://www.amazon.ca/gp/customer-reviews/R33SD2MGO0LWXQ Star Wars Legends Epic Collection: The Empire Vol. 1 https://www.amazon.ca/gp/customer-reviews/R3Y07GD0M1T52 Star Wars Legends Epic Collection: The Empire Vol. 2 Star Wars Legends Epic Collection: The Empire Vol. 3 https://www.amazon.ca/gp/customer-reviews/RX8AKR1J689O3 Star Wars Legends Epic Collection: The Empire Vol. 4 https://www.amazon.ca/gp/customer-reviews/R1FHU3XWACH578 Star Wars Legends Epic Collection: Menace Revealed Vol. 1 https://www.amazon.ca/gp/customer-reviews/RENKZXIWPVJU0 Star Wars Legends Epic Collection: The Old Republic Vol. 1 https://www.amazon.ca/gp/customer-reviews/R2Y2HUFBOTLZ0F Wolverine Epic Collection Vol. 1: Madripoor Nights https://www.amazon.ca/gp/customer-reviews/R3ORM8ZI02R4A0

Sub Macro1 ' Macro1 Macro ' NOTE: this macro will crash if the source table does not have a filter already ' Set the start date in format M/D/YYYY, enclosed in # and with no leading zeros Dim startDate As Date startDate = #9/1/2018# ' Set the end date in format M/D/YYYY, enclosed in # and with no leading zeros Dim endDate As Date endDate = #9/30/2018# ' the current workbook Dim currentwb As Workbook Set currentwb = ActiveWorkbook ' clear old data currentwb.Sheets("dest").UsedRange.ClearContents ' open the other workbook Dim sourcewb As Workbook Set sourcewb = Workbooks.Open("path") 'Clear previous filters sourcewb.Sheets("src").AutoFilter.ShowAllData 'add date filter sourcewb.Sheets("src").UsedRange.AutoFilter Field:=3, Criteria1:=">=" & startDate, Operator:=xlAnd, Criteria2:="<=" & endDate ' copy new data sourcewb.Sheets("src").Range("A:C,M:M").Copy currentwb.Sheets("dest").Range("A1").PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:=xlNone, SkipBlanks:=False, Transpose:=False currentwb.Save currentwb.Activate End Sub

with open('input.txt', 'r') as input_file: for line in input_file: if ' ' in line: TITLE = line.replace(' ',).replace(' ',).strip if ' ISBN:' in line: ISBN = line.split('<')[-2].split('>')[-1] if 'On Sale:' in line: DATE = line.split('<')[-2].split('>')[-1].replace("Aug.", "August") if 'Pages:' in line: PAGES = line.split('<')[-2].split('>')[-1] if 'COLLECTING' in line: ISSUES = (' '.join(line.replace("","'").replace("","'").replace(" ","").split)).split('')[-1]

print """|-
 * colspan="2"| %s
 * %s
 * %s
 * %s
 * """ % (TITLE, ISSUES, PAGES, DATE, ISBN)

output = "" text=raw_input("please enter the text") fp = text.split("\n") for line in fp: i = 0 stack = 0 stack_index = 0 while i < len(line): # keep track of where brackets start # because no formatting is added between brackets if line[i] in ["{", "[", '"']:           stack += 1            if stack == 1:                output += line[stack_index:((len(line) * -1) + i)].title                stack_index = i        # when the brackets close, add the unformatted text within to the output        elif line[i] in ["}", "]", '"']: stack -= 1 if stack == 0: output += line[stack_index:((len(line) * -1) + i)] stack_index = i       # add the number signs to numbers not inside of brackets elif stack <= 0 and i > 2 and line[i].isdigit and not line[i-1].isdigit and line[i-1] == " " and line[i-2] not in ["|"]: line = "%s#%s" % (line[:i], line[i:]) i = i + 1 i = i + 1 if stack > 0: output += line[stack_index:] else: output += line[stack_index:].title print output