Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 10th 09, 04:35 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 1
Default Can someone help me with this regular expression?

Hello,

I would like to be able to create a regular expression that will only
return the lower ascii characters (ie: 0-127), and replace all other
characters with a carriage return. Can anyone tell me the regex for
this?

Thanks,
James

  #2   Report Post  
Old March 10th 09, 05:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default Can someone help me with this regular expression?

Your going to have to clarify what you mean.

Which lower characters of the ASCII range 0 - 127 ? Are you saying you want
to return and what does return mean? Do you simply mean ASCII 97 - 122?

Give some sample data and the result you expect from that data.

Mike

" wrote:

Hello,

I would like to be able to create a regular expression that will only
return the lower ascii characters (ie: 0-127), and replace all other
characters with a carriage return. Can anyone tell me the regex for
this?

Thanks,
James

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Regular expression search/replace in Excel Paul Excel Discussion (Misc queries) 15 August 6th 08 04:57 PM
Excel formula needed... regular expression? danesh Excel Discussion (Misc queries) 3 August 10th 07 12:31 PM
Regular Expression sl Excel Discussion (Misc queries) 2 January 23rd 07 11:57 PM
need help with expression Peterpunkin Excel Discussion (Misc queries) 5 May 4th 06 05:56 PM
Expression gudway New Users to Excel 3 May 4th 06 01:12 PM


All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017