Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
regex url ouput to excel, but has carriage return
#1
This is really puzzling.

I output urls into excel as a new row for each url yet each url has a carriage return at the end?

This breaks the function, web, which doesn't see a single line, but two.

I tried replace and replacerx in quickmacros. I tried to delete the carriage return in excel but that doesn't work..In fact it doesn't even show up in excel. It only shows up in notepad and ms word when I copy the row and paste it there.

I did some more testing, I suspect it's "SetCell" that does this by default. Can you confirm? Is there a way to fix it?
#2
Excel does it. Need to trim spaces when you copy Excel cells using clipboard. Don't need when you use ExcelSheet functions such as Cell.


Forum Jump:


Users browsing this thread: 1 Guest(s)