Re: Pre-Linearization or Iterative Profiling (WAS Re: Printer profile mis-shape?)
Re: Pre-Linearization or Iterative Profiling (WAS Re: Printer profile mis-shape?)
- Subject: Re: Pre-Linearization or Iterative Profiling (WAS Re: Printer profile mis-shape?)
- From: Rick Gordon <email@hidden>
- Date: Mon, 28 Aug 2006 21:36:20 -0700
That can be very easy with an editor capable of regular expression search/replace, such as BBEdit. I imagine that the content of each row contains an identical number of fields separated spaces, say 38 numbers separated by spaces which should become tabs, and the next space should be a return, and continuing in that manner, right?
That being the case (assuming it is), something like the following (watching out for email-generated returns):
FIND:
([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])* ([^ ])*
REPLACE:
\1\t\2\t\3\t\4\t\5\t\6\t\7\t\8\t\9\t\10\t\11\t\12\t\13\t\14\t\15\t\16\t\17\t\18\t\19\t\20\t\21\t\22\t\23\t\24\t\25\t\26\t\27\t\28\t\29\t\20\t\21\t\22\t\23\t\24\t\25\t\26\t\27\t\28\r
Rick Gordon
------------------
On 8/28/06 at 8:54 PM -0700, Marco Ugolini wrote in a message entitled
"Re: Pre-Linearization or Iterative Profiling (WAS Re: Print":
>In a message dated 8/28/06 7:25 PM, Graeme Gill wrote:
>
>> Marco Ugolini wrote:
>>> But the bad news is that it has no tabs and no returns. It's just one long
>>> uninterrupted string of text with spaces (ouch!). So it cannot be opened in
>>> Excel as a well-ordered series of data in neat rows and columns, as one can
>>> do with CGATS data. That's a tough one to put in a spreadsheet, needing a
>>> lot of "massaging" with a text editor. Time-consuming, but not impossible.
>>
>> Hmm. Open Office has an option to treat spaces as delimiters. Are you
>> sure that Excel doesn't have a similar option ?
>
>
>It does, but the trick is how to tell Excel which spaces are to be treated
>as tabs and which as paragraph returns, since they are all in one huge
>Hummer-size paragraph. That's why I think the "massaging" with a text editor
>is still needed.
>
>--------------
>Marco Ugolini
>Mill Valley, CA
--
___________________________________________________
RICK GORDON
EMERALD VALLEY GRAPHICS AND CONSULTING
___________________________________________________
WWW: http://www.shelterpub.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Colorsync-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden