I actually worked through it fine. If 10 programmers attempted this the
code would be written 10 different ways but below is what I use. This
works fine if the csv file is a "windows" version where lines end in a
LF:CR. I need to adapt this to work with files generated on other systems.
In my case I'm working with descriptions that end up as HTML so I convert
the embedded characters to a line break "<br>" sequence. I use this to
get a full line and them dump that line through a parser that processes
the line.
- Josh
LINE.NUM = 0
LINE = ''
LAST.VAL = ''
IN.QUOTES = @FALSE
LOOP
WHILE READBLK VAL FROM D.PATH,1 DO
BEGIN CASE
CASE VAL = CHAR(13) AND NOT(IN.QUOTES)
GOSUB PROCESS.LINE
LINE = ''
CASE VAL = '"' AND IN.QUOTES
IN.QUOTES = @FALSE
LINE := VAL
CASE VAL = '"'
IN.QUOTES = @TRUE
LINE := VAL
CASE VAL = CHAR(13) AND IN.QUOTES
LINE := '<br>'
CASE VAL = CHAR(10) AND LAST.VAL = CHAR(13)
CASE VAL = CHAR(10)
LINE := '<br>'
CASE 1
LINE := VAL
END CASE
LAST.VAL = VAL
REPEAT
IF LINE # '' THEN
GOSUB PROCESS.LINE
LINE = ''
END
On 2/9/12 11:55 AM, "Charlie Noah" <[email protected]> wrote:
Hi Josh,
I'd be happy to share my routines with you, if they would be of any use.
I have a program I use to load a csv file, and a subroutine which
converts back and forth between csv, dynamic and fixed width, either a
line at a time or an entire flat file.
Charlie
On 02-09-2012 10:44 AM, Joshua Gallant wrote:
> I was going to ask the same question about embedded line feeds. I've
>been
> dealing with a lot of outside companies the last few months transferring
> data and found a lot have embedded line feeds all over.
>
> - Josh
>
>
>
>
>
> On 2/9/12 11:11 AM, "George Gallen"<[email protected]> wrote:
>
> Is it possible that the URL has an embedded lf at the end from entry on
> the source side?
>
> I've created csv files comma/quoted that contained URLs and were quite
> long and didn't have any issues importing
> Them into excel as a .csv , at least not as breaking into two lines.
>
> George
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Charlie Noah
> Sent: Thursday, February 09, 2012 11:06 AM
> To: U2 Users List
> Subject: Re: [U2] Building an Excel File
>
> Thanks George. I changed the tabs to pipes just to display them here.
> Normally I save as tab delimited with no surrounding character. Since
> the cell contents copies and pastes as 2 lines, I'm not sure whether
> these suggestions would solve my problem.
>
> Thanks again,
> Charlie
>
> On 02-09-2012 8:54 AM, George Gallen wrote:
>> Not sure if this helps...
>>
>> I noticed that you were showing pipe delimited lines...
>> If you rename your file from .csv to .txt
>>
>> Then from excel, you use the "Open" option, and then you can set the
>> delimiter to |
>> And also change the column types before it imports it, or have it
>> skip a column as well.
>>
>> George
>>
>> -----Original Message-----
>> From: [email protected]
>> [mailto:[email protected]] On Behalf Of Charlie Noah
>> Sent: Thursday, February 09, 2012 9:46 AM
>> To: U2 Users List
>> Subject: Re: [U2] Building an Excel File
>>
>> While everyone is thinking about CSV and Excel, maybe I can get a
>> solution to a problem that's been plaguing me for a long time.
>>
>> _______________________________________________
>> U2-Users mailing list
>> [email protected]
>> http://listserver.u2ug.org/mailman/listinfo/u2-users
>>
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
