Forum Discussion

shankar_r's avatar
shankar_r
Community Hero
9 years ago

DDT driver not reading Excel cell values with Carriage Return character?

DDT driver not reading Excel cell values with Carriage Return character.   Or is there any way to get the cell values with the Carriage Return character.   If i get any quick answer that would be...
  • tristaanogre's avatar
    tristaanogre
    9 years ago

    I was right... in the Excel cell, what is separating the lines is not a CR but an LF only... so, in other words, your code should be

     

    aqString.ListSeparator = "\n"
aqString.GetListItem(mycellvalue,0);

    This worked for me... see if it works for you.

tristaanogre's avatar
tristaanogre
Esteemed Contributor

Here's a question:

Everything you've tried to date to parse out those carriage returns SHOULD work... the question, I guess, is... Are they REALLY carriage returns? I mean, the data entry into Excel makes it LOOK that way, but are there other characters going on there that we need to know more about?

Let me poke around a bit and I'll let you know but I suspect that we may be on the right track but looking for the wrong character

tristaanogre's avatar
tristaanogre
Esteemed Contributor
9 years ago

I was right... in the Excel cell, what is separating the lines is not a CR but an LF only... so, in other words, your code should be

 

aqString.ListSeparator = "\n"
aqString.GetListItem(mycellvalue,0);

This worked for me... see if it works for you.

  • Colin_McCrae's avatar
    Colin_McCrae
    Community Hero
    9 years ago

    Makes sense.

     

    Thats why I do the two separately.

     

    Sometimes its one. Sometimes its the other. Sometimes its both. Treat them separately, and they all get removed regardless.

  • shankar_r's avatar
    shankar_r
    Community Hero
    9 years ago

    Same worked me too....Thanks!