Databases
StackOverflow2013
Postsdbo
POSanitizing a Piece of Text in Python
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSanitizing a Piece of Text in Python
    primarykey
    data
    text
    <p>I am fairly new to Python, but I would like to get started and learn a bit by doing some scripting for features I will use. I have some text that is retrieved from typing in "status" in Team Fortress 2's console. What I would like to achieve is, I want to convert this text below into text where there is only the <code>STEAM_X:X:XXXXXXXX</code> which is the Steam64 ID.</p> <pre><code># userid name uniqueid connected ping loss state # 31 "Atonement -Ai-" STEAM_0:1:27464943 00:48 103 0 active # 10 "?loop?" STEAM_0:0:31072991 40:48 62 0 active # 11 "爱 -Ai-" STEAM_0:0:41992530 40:46 68 0 active # 12 "MrKateUpton -Ai-" STEAM_0:1:10894538 40:25 81 0 active # 13 "Tacet -Ai-" STEAM_0:1:52131782 39:59 83 0 active # 14 "CottonBonbon-Ai-" STEAM_0:1:47812003 39:39 51 0 active # 15 "belt -Ai-" STEAM_0:1:4941202 38:43 123 0 active # 16 "boutros :3" STEAM_0:0:32271324 38:21 65 0 active # 17 "[tilt] Xikkari" STEAM_0:1:41148798 38:14 92 0 active # 24 "ElenaWitch" STEAM_0:0:17495028 31:30 73 0 active # 19 "[tilt] Batcan #boutros" STEAM_0:1:41205650 38:10 63 0 active # 20 "[?l??]whatupmydiggas" STEAM_0:1:50559125 37:58 112 0 active # 21 "[tilt] musicman" STEAM_0:1:37758467 37:31 89 0 active # 22 "Jack Frost" STEAM_0:0:24206189 37:28 90 0 active # 28 "[tilt-sub]deaf ears #best safet" STEAM_0:1:29612138 19:05 94 0 active # 25 "? notez ?ai" STEAM_0:1:29663879 31:23 113 0 active # 27 "-Ai- Lord English" STEAM_0:1:44114633 24:08 116 0 active # 29 "1.prototypes" STEAM_0:0:42256202 17:41 83 0 active # 30 "SourceTV // name for SourceTV" BOT active # 32 "PUT ME IN COACH" STEAM_0:1:48004781 00:36 173 0 spawning </code></pre> <p>Is there any built-in functions in Python that does the following algorithm?</p> <pre><code>For all that is not (!) Steam_X:X:XXXXXXXX, delete/remove. </code></pre> <p>I have done a fair amount of Googling, but nothing really gets specific. If someone could get me started with a built-in Python function, I would be so grateful to start coding. </p> <p>P.S. The output would be like this </p> <pre><code>STEAM_0:1:27464943 STEAM_0:0:31072991 STEAM_0:1:10894538 etc etc </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. UStheGreenCabbage
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSanitizing a Piece of Text in Python
      1. UStheGreenCabbage
      1. VTFavorite
    2. VO
      singulars
      1. POSanitizing a Piece of Text in Python
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POSanitizing a Piece of Text in Python
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload