mIRC Home    About    Download    Register    News    Help

Print Thread
#5924 10/01/03 02:23 PM
Joined: Jan 2003
Posts: 9
C
crashy Offline OP
Nutrimatic drinks dispenser
OP Offline
Nutrimatic drinks dispenser
C
Joined: Jan 2003
Posts: 9
when pasting from excel to mirc i get control codes in the text. what are these excel control codes and how do i get rid of them? ive tried $strip(text,burcmo)

ps they suck

#5925 10/01/03 03:11 PM
Joined: Dec 2002
Posts: 395
M
Fjord artisan
Offline
Fjord artisan
M
Joined: Dec 2002
Posts: 395
$remove(text,<thosecontrolcodes>)? wink

#5926 11/01/03 09:20 PM
Joined: Dec 2002
Posts: 1,922
O
Hoopy frood
Offline
Hoopy frood
O
Joined: Dec 2002
Posts: 1,922
it's the carriage return and line terminator codes. they appear at the end of each line, telling you that there's an actual 'enter' there. use $remove(text,$crlf)

#5927 12/01/03 06:59 AM
Joined: Jan 2003
Posts: 9
C
crashy Offline OP
Nutrimatic drinks dispenser
OP Offline
Nutrimatic drinks dispenser
C
Joined: Jan 2003
Posts: 9
works, thanks a heap smirk


Link Copied to Clipboard