Click here to Skip to main content
15,886,110 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: The Power of No Pin
Gerry Schmitz5-Aug-20 6:50
mveGerry Schmitz5-Aug-20 6:50 
GeneralRe: The Power of No Pin
Sander Rossel5-Aug-20 21:51
professionalSander Rossel5-Aug-20 21:51 
GeneralRe: The Power of No Pin
obermd6-Aug-20 3:37
obermd6-Aug-20 3:37 
GeneralRe: The Power of No Pin
PIEBALDconsult5-Aug-20 3:55
mvePIEBALDconsult5-Aug-20 3:55 
GeneralRe: The Power of No Pin
Gerry Schmitz5-Aug-20 6:54
mveGerry Schmitz5-Aug-20 6:54 
GeneralRe: The Power of No Pin
PIEBALDconsult5-Aug-20 11:44
mvePIEBALDconsult5-Aug-20 11:44 
GeneralRe: The Power of No Pin
Nelek5-Aug-20 7:07
protectorNelek5-Aug-20 7:07 
GeneralRe: The Power of No Pin
kmoorevs5-Aug-20 12:37
kmoorevs5-Aug-20 12:37 
Nelek wrote:
but that's the csv I get from customers

Laugh | :laugh: Glad I'm not the only one! I have one customer's csv import that looks like this:

"1201,05-41-2100-AP,12033.32,07-01-2020,07-31-2020"


Yes, each line is encapsulated in double quotes not to mention the blank lines and subotals/totals spread throughout. This is what they give me, and if I can possibly make things work, I handle it...in this case checking each line for a 34 at the beginning and ending, except where matching pairs occur without a comma, etc. D'Oh! | :doh:

After 20 years of dealing with imports, nothing surprises me anymore! It has resulted in some highly customizable options bloat.

One gripe I have about working with .csv files is the fact that Excel will automatically strip leading 0s simply by opening the file, even without saving. Confused | :confused:
"Go forth into the source" - Neal Morse

GeneralRe: The Power of No Pin
PIEBALDconsult6-Aug-20 4:18
mvePIEBALDconsult6-Aug-20 4:18 
GeneralRe: The Power of No Pin
obermd6-Aug-20 3:39
obermd6-Aug-20 3:39 
GeneralRe: The Power of No Pin
PIEBALDconsult6-Aug-20 4:03
mvePIEBALDconsult6-Aug-20 4:03 
GeneralRe: The Power of No Pin
Sandeep Mewara5-Aug-20 4:10
mveSandeep Mewara5-Aug-20 4:10 
GeneralRe: The Power of No Pin
SteakhouseLuke5-Aug-20 4:54
SteakhouseLuke5-Aug-20 4:54 
GeneralRe: The Power of No Pin
raddevus5-Aug-20 5:08
mvaraddevus5-Aug-20 5:08 
GeneralRe: The Power of No Pin
Marc Clifton5-Aug-20 5:47
mvaMarc Clifton5-Aug-20 5:47 
GeneralRe: The Power of No Pin
Mycroft Holmes5-Aug-20 13:06
professionalMycroft Holmes5-Aug-20 13:06 
GeneralRe: The Power of No Pin
SteakhouseLuke6-Aug-20 1:52
SteakhouseLuke6-Aug-20 1:52 
GeneralRe: The Power of No Pin
dandy725-Aug-20 5:24
dandy725-Aug-20 5:24 
GeneralRe: The Power of No Pin
honey the codewitch5-Aug-20 5:37
mvahoney the codewitch5-Aug-20 5:37 
GeneralRe: The Power of No Pin
Marc Clifton5-Aug-20 5:49
mvaMarc Clifton5-Aug-20 5:49 
GeneralRe: The Power of No Pin
honey the codewitch5-Aug-20 6:48
mvahoney the codewitch5-Aug-20 6:48 
GeneralRe: The Power of No Pin
CHill605-Aug-20 6:13
mveCHill605-Aug-20 6:13 
GeneralRe: The Power of No Pin
honey the codewitch5-Aug-20 6:47
mvahoney the codewitch5-Aug-20 6:47 
GeneralRe: The Power of No Pin
Rick York5-Aug-20 9:54
mveRick York5-Aug-20 9:54 
GeneralRe: The Power of No Pin
Gerry Schmitz5-Aug-20 6:13
mveGerry Schmitz5-Aug-20 6:13 

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.