Re: CSV help

[ Follow Ups ] [ Post Followup ] [ Forum ]

Posted by Grant E Foraker on January 28, 2020 at 13:06:14:

In Reply to: Re: CSV help posted by Barbara Brazil on January 28, 2020 at 11:33:44:

Found that if I stay in standard mode, I can use "^p^p" for CRLFCRLF. Now I have just the CRLFs in the comments.

I don't want to go thru 28k records one at a time. So, how about this ...

1) replace ",^p" with ",~~~~". The comma is always just before the end of record CRLF.

2) replace "^p" with " ". That should fix the CRLF's in the comments.

3) replace ",~~~~" with ",^p".

Should now have just records. Or maybe a few to fix manually.

Follow Ups:

Post a Followup



What is the name of the main Signature System's Product?  


Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):

Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.

[ Follow Ups ] [ Post Followup ] [ Forum ]