The advanced field option to get all the data into one field, followed by a series of calculated fields should do this.
1. Trap using Numeric on the first column of the first line (assuming this is constant and OK for the rest of the report)
2. Highlight the entire width of the line, then use the blank field options in the advance tab of the field properties to extract all the data into one field.
Maybe that’s it?? If you don’t want it separated out, you will have all the data on one line. Call the field all
3. To separate it, create 8 (or more) calculated field using the lsplit function. The formula will be LSplit(all,8,”-“,1) for the first part, then just change the last parameter for the other 7 parts. Call the fields part1, part2 etc.
4. If you need to split it further into description and the two times, you could split further using the RSplit(part1,3,” “,1) etc.
Hope that makes sense?
Sorry I don't
It seems to only put the ID First PRC and Start Stop in the row, not all PRC and Start Stop Data.
I'm probably misunderstanding.
Fred /b[/quote]Steve said
"2. Highlight the entire width of the line, then use the blank field options in the advance tab of the field properties to extract all the data into one field."
This relates to the 'End Field on' properties which will allow you to create a multi-row block as a single text field. There are several options that can be chosen to identify the end of the 'block'. Steve's suggestion is to use the blank line between records. Seems good to me but you might find it worth trying some of the other options to see what happens - a great way to familiarise with the funstionality.
Hope this helps.
I'm clicking on Blank Field values 1 and the row of data in table is still only showing first row of data?
I've tried for the last hour and am having no luck.
Fred /b[/quote]When you look at the definition in the REPORT screen what do you see? Does it appear that all rows will be selected?
How wide is the field DISPLAY in your table?
Have you looked at the contents using the "Show Field Contents" option (very useful for large text fields). The help section is entitled "Viewing memo and long character fields"
Bear in mind I am trying to cover all the quick to assess angles here to save time and some of these suggestions may be irrelevant!