I have a csv file with lines like this example: 14," APPLES, GRANNY SMITH 72 CT usa, Case",101-016,40.00,7/16/2013,7/22/2013 14," APPLES, GRANNY SMITH 72 CT, Each",010-017,0.60,7/16/2013,7/22/2013 I need to do a few things here - I need to remove any surrounding quotes from around fields; I also need to split the third field into two separate fields; lastly I need to change the field separator from comma to tab. For example the two example lines above should end up looking like this: 14\tAPPLES, GRANNY SMITH 72 CT usa\tCase\t101-016\t40.00\t7/16/2013\t7/22/2013 14\tAPPLES, GRANNY SMITH 72 CT\tEach\t010-017\t0.60\t7/16/2013\t7/22/2013 I am new to Python and am having …

Member Avatar
Member Avatar
+0 forum 1

Hi, I have following code and I want to remove first seperator using css here's the code <div id="sub_nav"> | <a href="#">Fashion Insider</a> | <a href="#">Leasing</a> </div>

Member Avatar
Member Avatar
+0 forum 2

Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks

Member Avatar
Member Avatar
+0 forum 4

Hello everybody! I have encountered a problem and I didn't manage to find any soultions yet. Let me simplify things a bit. I have 2 forms, the first contains an ASP ListBox with multi select mode enabled. I submit the form and in the other form I use just for testing purposes this snippet of code: [CODE] protected void Page_Load(object sender, EventArgs e) { foreach (string formKey in Request.Form.AllKeys) { if (formKey != null) { if (formKey.Equals("ctl00$MainContent$ListBox1")) Label1.Text = Request.Form[formKey]; } } } [/CODE] The problems is that the values that come from the listbox (the values that i selected …

Member Avatar
Member Avatar
+0 forum 2

I used this pattern few times to answer a thread and thought to post it as snippet.

Member Avatar
Member Avatar
+1 forum 1

hi! I have a table which contain files paths. my problem is, that when I insert a path, MySQL omit the separator char. for example: INSERT INTO A VALUES ('C:\qqq\www\eee.ttt'); will be saved in A as: C:qqqwwweee.ttt what can I do for saving the path as it is? (ofcourse, I mean solution withou duplicating the '',) I have to say, that there is another problem, for example c:[B]\n[/B]ate. mysql turn the \n to new line... Thanks, Nate

Member Avatar
Member Avatar
+0 forum 3

Here tool functions, which came up during discussions earlier. Expanded slightly, added elimination of traceback prints by try..except. Added dd.mm.yy routine as that is format in my home country Finland. Optimized docstring beginnings to be informative in editor tooltip (at least IDLE shows, but code must be run or imported first). If you like to use put your library path and add mention of origin in your comments/documentation. (Looking for job, you know)

Member Avatar
Member Avatar
+1 forum 4

The End.