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"<ggal...@wyanokegroup.com> 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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] 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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users