Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pbsibex

    Parse a memo field into multiple detail row fields

    I didn't mention that this is a patient's diagnostic report and the new system it's being migrated to has line breaks at 80 characters. When a new report is created in that system it can automatically wrap the words perfectly, but since we're migrating outside data to it, it really needs to...
  2. pbsibex

    Parse a memo field into multiple detail row fields

    Just realized that the text will really need to break on a word break. Any ideas on that?
  3. pbsibex

    Parse a memo field into multiple detail row fields

    Great stuff. The text is in HTML format on the server so I now need to work some formulas to pull the HTML coding out and only use the text in Crystal as the HTML characters throws off the count. I have some previous formulas I used to do that and will try to convert them into an SQL Command...
  4. pbsibex

    Parse a memo field into multiple detail row fields

    I'd like to try and experiment with what the different export formats will end up with. How would a loop be structured? Great advice .. Thanks a bunch
  5. pbsibex

    Parse a memo field into multiple detail row fields

    I didn't think there was going to be a way to make an variable number of Detail rows. OH well ... Pulling in separate 80 character fields will work becuase it needs to then be exported and then imported into another system. Exporting it into a text or .csv file should work fine. I'm new...
  6. pbsibex

    Parse a memo field into multiple detail row fields

    I only want to create one Detail section and have it loop through and create the new Detail rows at they are needed. There could literaly be 100's of rows needed and so creating another Detail row for each different value wouldn't work to well. Any ideas on how to create a Group that is based...
  7. pbsibex

    Parse a memo field into multiple detail row fields

    I have a memo field of indeterminate length (paragraph to pages of text) that I need to break out into 80 characters/ field in each Detail row until the whole field has been parsed out. I'm using Crystal 2008 on an SQL database. Thanks in advance for any ideas.

Part and Inventory Search

Back
Top