Click here to Skip to main content
15,895,799 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionError States Pin
Leslie Sanford5-Aug-07 17:15
Leslie Sanford5-Aug-07 17:15 
AnswerRe: Error States Pin
Luc Pattyn5-Aug-07 22:52
sitebuilderLuc Pattyn5-Aug-07 22:52 
GeneralRe: Error States Pin
Leslie Sanford6-Aug-07 5:55
Leslie Sanford6-Aug-07 5:55 
GeneralRe: Error States Pin
Luc Pattyn6-Aug-07 6:23
sitebuilderLuc Pattyn6-Aug-07 6:23 
Questionencapsulation VS development time Pin
DynV2-Aug-07 14:13
DynV2-Aug-07 14:13 
AnswerRe: encapsulation VS development time Pin
led mike3-Aug-07 5:10
led mike3-Aug-07 5:10 
AnswerRe: encapsulation VS development time Pin
dazfuller6-Aug-07 5:38
dazfuller6-Aug-07 5:38 
QuestionRemove Quote from Writeline output Pin
rfrank535625-Jul-07 8:21
rfrank535625-Jul-07 8:21 
Hi - I have an app that reads a csv file line by line, parses for two fields, sends a query to a web server, receives four data fields back, and then writes an output line with the new fields followed by the contents of the input line.

My problem is that the four fields are bracketed in quotes, and the entire input line is included in a set of quotes, so if I then open the output file with excel, the input line contents are treated as a single cell - not a series of csv fields.

I then changed the code to loop through the fields and put commas in the string - but the output line still has quotes at the start and end of the string - so I I wan to use in Excel - I still need to open as a text file an strip out the pesky quotes.

What to do ??

Here is the code doing the data assembly

ID = ID + 1
WriteOutputLine = ID & "," & response.GeocodedAddresses(i).Alternatives(0).Quality.ToString & "," & HouseNo & "," & Street & "," & City & "," & State & "," & Zip & ","

For DataFieldCount = 0 To lineArray.Length - 1
WriteOutputLine = WriteOutputLine & lineArray(DataFieldCount) & ","
Next

WriteLine(2, WriteOutputLine)

Here is a sample input line . .

37.30840674,-122.0333179,-122.029614,37.30833842,1083.826,179,299,WGS 84,SCMAD20070713,Murky Pool,,7/13/2007 21:43,IMG_6212 copy_tag.jpg,IMG_6212 copy.jpg,,,585992.34,4129519.64,10 N,7/13/2007 14:43,,178.7832,100.2,,,,Canon Canon EOS DIGITAL REBEL XT Adobe Photoshop Elements 4.0 Windows

Here is a sample output line

"1,Exact,7360,Fallenleaf Ln,Cupertino,CA,95014,37.30840674,-122.0333179,-122.029614,37.30833842,1083.826,179,299,WGS 84,SCMAD20070713,Murky Pool,,7/13/2007 21:43,IMG_6212copy_tag.jpg,IMG_6212copy.jpg,,,585992.34,4129519.64,10 N,7/13/2007 14:43,,178.7832,100.2,,,,Canon Canon EOS DIGITAL REBEL XT Adobe Photoshop Elements 4.0 Windows,"




rfrank5356
AnswerRe: Remove Quote from Writeline output Pin
..Hubert..26-Jul-07 3:38
..Hubert..26-Jul-07 3:38 
QuestionApplication framework for small or mid sized apps Pin
..Hubert..24-Jul-07 23:45
..Hubert..24-Jul-07 23:45 
AnswerRe: Application framework for small or mid sized apps Pin
drinkwater25-Jul-07 4:26
drinkwater25-Jul-07 4:26 
GeneralRe: Application framework for small or mid sized apps Pin
Dave Herren25-Jul-07 9:55
Dave Herren25-Jul-07 9:55 
GeneralRe: Application framework for small or mid sized apps Pin
..Hubert..25-Jul-07 22:24
..Hubert..25-Jul-07 22:24 
GeneralRe: Application framework for small or mid sized apps Pin
led mike3-Aug-07 5:03
led mike3-Aug-07 5:03 
GeneralRe: Application framework for small or mid sized apps Pin
..Hubert..3-Aug-07 5:38
..Hubert..3-Aug-07 5:38 
GeneralRe: Application framework for small or mid sized apps Pin
led mike3-Aug-07 7:02
led mike3-Aug-07 7:02 
AnswerRe: Application framework for small or mid sized apps Pin
awesomeo21-Aug-07 20:18
awesomeo21-Aug-07 20:18 
QuestionRecording a wave file Pin
Leslie Sanford21-Jul-07 16:35
Leslie Sanford21-Jul-07 16:35 
AnswerRe: Recording a wave file Pin
Luc Pattyn22-Jul-07 1:14
sitebuilderLuc Pattyn22-Jul-07 1:14 
GeneralRe: Recording a wave file Pin
Leslie Sanford22-Jul-07 3:34
Leslie Sanford22-Jul-07 3:34 
GeneralRe: Recording a wave file Pin
Luc Pattyn22-Jul-07 3:45
sitebuilderLuc Pattyn22-Jul-07 3:45 
GeneralRe: Recording a wave file Pin
Chris-Kaiser24-Jul-07 11:08
Chris-Kaiser24-Jul-07 11:08 
Questionhow to implement undo functionn by using both Command and Memento design pattern Pin
largs20-Jul-07 23:23
largs20-Jul-07 23:23 
AnswerRe: how to implement undo functionn by using both Command and Memento design pattern Pin
Pete O'Hanlon22-Jul-07 8:47
mvePete O'Hanlon22-Jul-07 8:47 
QuestionDesign question for a Plugin Framework Pin
ssack20-Jul-07 3:26
ssack20-Jul-07 3:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.