On Mon, Apr 17, 2023 at 12:04 PM Joe Yoder wrote:
> I thought I could simply preprocess the file and change each occurrence of
> a single line feed with a comma but when I look at functions available I
> suspect it will be painfully slow.
>
> Any ideas appreciated,
>
You ought to try it before r
You can use notepad ++ find and replace to preprocess the file.
Rick Q
quilh...@gmail.com
On Mon, Apr 17, 2023 at 12:04 PM Joe Yoder wrote:
> Alan and all,
> I have researched the problem records and find that they have line feed
> characters without a leading carriage return. This results f
Alan and all,
I have researched the problem records and find that they have line feed
characters without a leading carriage return. This results from the
operator hitting a return in a notes field of the accounting package I am
using.
Apparently Excel import insists on a combination of carriage
This challenge may arise if the delimiter is also a value in the field
content such as a comma.
Ideally it would be good to use a delimiter which isn't ever used in the
content such as the pipe symbol.
Trust this should solve your challenge.
--
Cheers!!!
*Srikanth Bhandari*
Email: srikanth.bhan
4 matches
Mail list logo