Re: Change export delimitor?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Did you hit and hold the control key when you hit the j key?

Or did you type the characters "ctrl-j"?

It's never failed for me.

PhillyRon wrote:

Small correction to my note, posted below. Of course, I meant ALT-ENTER,
NOT CONTROL-ENTER.

PhillyRon

"PhillyRon" wrote:

Dave,

I'm getting back to the delimitor problem this morning. That Excel macro
was great: it found that it was not, in fact CONTROL-ENTER that was the
invisible characters but dec 013 and dec 010. Now how can I remove these
special characters and replace them with (for example) spaces?

BTW, I put in a few test CONTROL-ENTERs in a spreadsheet, and I tried FIND
CONTROL-J and it still couldn't find them. Could you be a bit more explicit
about what you want entered into the FIND/REPLACE box? (I know this is a bit
thick-headed, but the devil is in the details.)

PhillyRon

"Dave Peterson" wrote:

Yes it will. It just looks like it doesn't.

If you do Edit|Find
then type:
asdf(ctrl-j)qwer
you'll see that it looks weird.

If it doesn't replace those funny characters, then the users aren't using
alt-enter.

But if the edit|Find doesn't find anything, you may want to use Chip Pearson's
CellView utility to see what that character is.
http://www.cpearson.com/excel/CellView.htm

PhillyRon wrote:

Dave,

The FIND window in FIND/REPLACE won't accept CONTROL-J (the courser doesn't
move and it doesn't find anything). Is that what you wanted to search for?

PhillyRon

"Dave Peterson" wrote:

Select your range to change
Edit|replace
what: ctrl-j (same as alt-0010 on the number keypad = alt-enter)
with: whateveryouwant (or leave blank or a space character)
replace all



PhillyRon wrote:

Earl,

I tried the Text Write Program (nice macro) but apparently trying to protect
the cells with a "~" delimitor doesn't solve the problem as I thought it
would. Here's the real problem: some clients made lists within the cells,
using ALT-ENTER to change lines. This is where the parsing screws up. Is
there a way to perform a SEARCH/REPLACE to get rid of the ALT-ENTER invisible
characters?

"Earl Kiosterud" wrote:

Ron,

Try the Text Write Program at http://www.smokeylake.com/excel/text_write_program.htm
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"PhillyRon" <PhillyRon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8C127DD9-201E-4655-939A-6AE8EE7A8344@xxxxxxxxxxxxxxxx
My Excel data contains both commas and tabs so I need to change the export
file.csv delimator to "~". How can I do this? (I tried Excel's suggestion
to go into the PC's control panel and change the txt list separator to ~ but
that didn't work.)

RonLev
Philly




--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
.

Relevant Pages

  • Re: how to display character from 128-159 range
    ... coded graphic characters identified as Latin ... which defined the control characters as well. ... ISO-8859-1 being the Internet standard, ...
    (comp.unix.programmer)
  • Re: Reading in file containing Low Values doesnt work correctly
    ... line sequential record it will be processed and all control characters ... control character that needs to be preserved. ... printable, nor is it a normal control character like TAB or Linefeed. ... another then the low-values prefix acts as an escape character. ...
    (comp.lang.cobol)
  • Re: how to display character from 128-159 range
    ... which defined the control characters as well. ... ISO-8859-1 being the Internet standard, ...
    (comp.unix.programmer)
  • Re: Strange PreTranslateMessage Behavior (2)
    ... get rid of all instances of GetDlgItem in your code. ... The correct solution is to create a control member variable; ... Since the keyboard is now trying to send characters ... >keyboard characters no longer show up in PreTranslateMessage and are ...
    (microsoft.public.vc.mfc)