UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Crystal - Help Formatting A Field, 14.0.4.738    
 
   
Johnny-Don
post May 11 2015, 01:13 PM
Post#1



Posts: 3
Joined: 11-May 15



Hello All! Great info on this site.

I have a very specific request for some help in Crystal. I'm no expert, not even close, I took a 2 day class about a month ago.

What I have is an MS database that has a mutliple line (paragraph) field. It's the description of a part number. Some have several lines, some have 1. What I need, in order to format it correctly to import it our new ERP program is for each line of the paragraph to be numbered, starting with a new sequence for each part number. For instance.

PART1234-A this is the description for
this part number, it could

contain a space in it as above
this is the end of the description


PART546-344 This is a single line description for this part


The Above example would have to look like this:


PART1234-A 000001this is the description for
PART1234-A 000002this part number, it could
PART1234-A 000003
PART1234-A 000004contain a space in it as above
PART1234-A 000005this is the end of the description


PART546-344 000001This is a single line description for this part

Is this possible? Thanks in advance
Go to the top of the page
 

Posts in this topic



Custom Search


RSSSearch   Top   Lo-Fi    16th September 2019 - 05:19 PM