Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.c > #99626

Re: Program to read csv file, store characters and numbers in separate arrays

From Richard Heathfield <rjh@cpax.org.uk>
Newsgroups comp.lang.c
Subject Re: Program to read csv file, store characters and numbers in separate arrays
Date 2016-12-16 11:03 +0000
Organization Fix this later
Message-ID <o30hjp$3uv$1@dont-email.me> (permalink)
References (4 earlier) <200cb89f-ae11-4328-b9ee-7bc4e4b98866@googlegroups.com> <o2uqvh$cct$1@dont-email.me> <88ab7754-4996-4bc0-a79d-d6605ab2a3db@googlegroups.com> <o30dve$np1$2@dont-email.me> <8ee864db-f4c7-4d04-8c87-2c2a9aa81d8e@googlegroups.com>

Show all headers | View raw


On 16/12/16 10:43, Alla _ wrote:
> On Friday, December 16, 2016 at 1:01:46 PM UTC+3, Richard Heathfield wrote:
>> On 16/12/16 09:19, Alla _ wrote:
<snip>
>>> Great. We are working with exactly the same file,
>>> and you don't get any trailing zeros, while I get one
>>> - see in (3).
>>
>> But I'm using the same code as you, so clearly we are /not/ using
>> exactly the same file.
>>
> Well, I have nothing to add here. One of the files I am using, and the one
> I have been referring in this discussion today, is the one you sent me.
> Are you using a different one?

No. Here's the hex dump, so you can see exactly what I'm using (and it's 
exactly what I sent you):

49 6E 63 6F 6D 65 20 53 74 61 74 65 6D 65 6E 74  |Income Statement|
2C 32 30 31 31 2C 32 30 31 32 2C 32 30 31 33 2C  |,2011,2012,2013,|
32 30 31 34 2C 32 30 31 35 0A 53 61 6C 65 73 2C  |2014,2015.Sales,|
31 30 36 32 2C 31 32 35 32 2C 31 35 38 37 2C 31  |1062,1252,1587,1|
39 33 34 2C 32 35 31 39 0A 43 6F 73 74 20 6F 66  |934,2519.Cost of|
20 47 6F 6F 64 73 20 53 6F 6C 64 2C 36 35 34 2C  | Goods Sold,654,|
38 31 34 2C 31 30 30 39 2C 31 31 39 30 2C 31 34  |814,1009,1190,14|
39 39 0A 20 20 47 72 6F 73 73 20 50 72 6F 66 69  |99.  Gross Profi|
74 2C 34 30 38 2C 34 33 38 2C 35 37 38 2C 37 34  |t,408,438,578,74|
34 2C 31 30 32 30 0A 22 53 65 6C 6C 69 6E 67 2C  |4,1020."Selling,|
20 47 65 6E 65 72 61 6C 2C 20 61 6E 64 20 41 64  | General, and Ad|
6D 69 6E 20 45 78 70 22 2C 32 35 34 2C 32 37 31  |min Exp",254,271|
2C 33 36 34 2C 34 35 34 2C 35 37 36 0A 20 20 4F  |,364,454,576.  O|
70 65 72 61 74 69 6E 67 20 49 6E 63 6F 6D 65 20  |perating Income |
62 65 66 6F 72 65 20 44 65 70 72 2C 31 35 34 2C  |before Depr,154,|
31 36 37 2C 32 31 34 2C 32 39 30 2C 34 34 34 0A  |167,214,290,444.|
44 65 70 72 65 63 69 61 74 69 6F 6E 20 61 6E 64  |Depreciation and|
20 41 6D 6F 72 74 69 7A 61 74 69 6F 6E 2C 32 35  | Amortization,25|
2C 33 31 2C 33 38 2C 35 32 2C 37 30 0A 20 20 4F  |,31,38,52,70.  O|
70 65 72 61 74 69 6E 67 20 50 72 6F 66 69 74 2C  |perating Profit,|
31 32 39 2C 31 33 36 2C 31 37 36 2C 32 33 38 2C  |129,136,176,238,|
33 37 34 0A 49 6E 74 65 72 65 73 74 20 45 78 70  |374.Interest Exp|
65 6E 73 65 2C 34 2C 33 2C 33 2C 31 2C 34 0A 4F  |ense,4,3,3,1,4.O|
74 68 65 72 20 47 61 69 6E 73 20 61 6E 64 20 4C  |ther Gains and L|
6F 73 73 65 73 2C 30 2C 37 2C 31 30 2C 30 2C 2D  |osses,0,7,10,0,-|
31 0A 20 20 50 72 65 74 61 78 20 49 6E 63 6F 6D  |1.  Pretax Incom|
65 2C 31 32 35 2C 31 32 36 2C 31 36 33 2C 32 33  |e,125,126,163,23|
37 2C 33 37 31 0A 49 6E 63 6F 6D 65 20 54 61 78  |7,371.Income Tax|
20 45 78 70 65 6E 73 65 2C 35 35 2C 35 32 2C 36  | Expense,55,52,6|
35 2C 39 32 2C 31 34 31 0A 20 20 4E 65 74 20 49  |5,92,141.  Net I|
6E 63 6F 6D 65 2C 37 30 2C 37 34 2C 39 38 2C 31  |ncome,70,74,98,1|
34 35 2C 32 33 30 0A                             |45,230.|


>
>> Barry Schwarz has suggested that you may have a trailing space in your
>> data, which wouldn't show up on Usenet, and he says (presumably after
>> trying it out) that this will produce the symptom you are describing.
> I thought so too. I have tried manually to delete rows and columns around
> the data I need to preserve. I am out of tools,

No, you are *not* out of tools. What you have is a reluctance to use a 
hex dump. Overcome that reluctance, and paste a hex dump of the file 
that is causing you problems.

-- 
Richard Heathfield
Email: rjh at cpax dot org dot uk
"Usenet is a strange place" - dmr 29 July 1999
Sig line 4 vacant - apply within

Back to comp.lang.c | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-15 05:05 -0800
  Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-15 13:48 +0000
    Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-15 08:22 -0800
      Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-15 16:28 +0000
        Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-15 09:25 -0800
          Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-15 19:31 +0000
            Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 01:19 -0800
              Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 10:01 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 02:43 -0800
                Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 11:03 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 03:08 -0800
                Re: Program to read csv file, store characters and numbers in separate arrays jameskuyper@verizon.net - 2016-12-18 03:32 -0800
                Re: Program to read csv file, store characters and numbers in separate arrays Barry Schwarz <schwarzb@dqel.com> - 2016-12-16 17:09 -0800
            Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 01:25 -0800
              Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 10:11 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 02:45 -0800
                Re: Program to read csv file, store characters and numbers in separate arrays Keith Thompson <kst-u@mib.org> - 2016-12-16 09:54 -0800
                Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 17:56 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays gazelle@shell.xmission.com (Kenny McCormack) - 2016-12-16 18:02 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 03:06 -0800
                Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 11:28 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Ben Bacarisse <ben.usenet@bsb.me.uk> - 2016-12-16 12:02 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 12:41 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays BartC <bc@freeuk.com> - 2016-12-16 13:40 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 14:03 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays BartC <bc@freeuk.com> - 2016-12-16 13:03 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Ben Bacarisse <ben.usenet@bsb.me.uk> - 2016-12-16 15:04 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays BartC <bc@freeuk.com> - 2016-12-16 15:26 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Ben Bacarisse <ben.usenet@bsb.me.uk> - 2016-12-16 17:01 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 04:18 -0800
  Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-15 14:12 +0000
    Re: Program to read csv file, store characters and numbers in separate arrays David Brown <david.brown@hesbynett.no> - 2016-12-15 16:14 +0100
      Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-15 15:37 +0000
        Re: Program to read csv file, store characters and numbers in separate arrays David Brown <david.brown@hesbynett.no> - 2016-12-15 23:20 +0100
          Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-15 23:27 +0000
            Re: Program to read csv file, store characters and numbers in separate arrays David Brown <david.brown@hesbynett.no> - 2016-12-16 12:10 +0100
              Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 11:43 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays David Brown <david.brown@hesbynett.no> - 2016-12-16 14:01 +0100
                Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 13:12 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays David Brown <david.brown@hesbynett.no> - 2016-12-16 14:57 +0100
      Re: Program to read csv file, store characters and numbers in separate arrays BartC <bc@freeuk.com> - 2016-12-15 16:30 +0000
        Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-15 16:36 +0000
          Re: Program to read csv file, store characters and numbers in separate arrays David Brown <david.brown@hesbynett.no> - 2016-12-15 23:29 +0100
    Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-15 08:26 -0800
      Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-15 16:33 +0000
    Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-15 08:32 -0800
      Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-15 16:37 +0000
      Re: Program to read csv file, store characters and numbers in separate arrays Keith Thompson <kst-u@mib.org> - 2016-12-15 12:17 -0800
        Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 01:33 -0800
    Re: Program to read csv file, store characters and numbers in separate arrays Keith Thompson <kst-u@mib.org> - 2016-12-15 12:23 -0800
      Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-15 20:39 +0000
    Re: Program to read csv file, store characters and numbers in separate arrays Ben Bacarisse <ben.usenet@bsb.me.uk> - 2016-12-15 21:13 +0000
    Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 00:39 -0800
      Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 08:54 +0000
        Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 01:09 -0800
          Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 09:32 +0000
            Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 01:51 -0800
              Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 10:08 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Ben Bacarisse <ben.usenet@bsb.me.uk> - 2016-12-16 11:09 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 03:16 -0800
                Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 03:20 -0800
                Re: Program to read csv file, store characters and numbers in separate arrays Keith Thompson <kst-u@mib.org> - 2016-12-16 09:48 -0800
                Re: Program to read csv file, store characters and numbers in separate arrays gazelle@shell.xmission.com (Kenny McCormack) - 2016-12-16 17:55 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays raltbos@xs4all.nl (Richard Bos) - 2016-12-20 11:53 +0000
                Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 11:33 +0000
            Re: Program to read csv file, store characters and numbers in separate arrays Keith Thompson <kst-u@mib.org> - 2016-12-16 09:46 -0800
      Re: Program to read csv file, store characters and numbers in separate arrays "James R. Kuyper" <jameskuyper@verizon.net> - 2017-01-03 15:38 -0500
  Re: Program to read csv file, store characters and numbers in separate arrays Barry Schwarz <schwarzb@dqel.com> - 2016-12-15 12:36 -0800
    Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 01:44 -0800
      Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 10:04 +0000
        Re: Program to read csv file, store characters and numbers in separate arrays Alla _ <modelling.data@gmail.com> - 2016-12-16 03:14 -0800
          Re: Program to read csv file, store characters and numbers in separate arrays Richard Heathfield <rjh@cpax.org.uk> - 2016-12-16 11:46 +0000

csiph-web