Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 4051 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted
I have a textbook composed of chapters. The book was simply entered as separate sentences in text field, and chapter titles in another text field.
 
Chapter Title                  Sentence
ABC                                     aaba
ABC                                     abac
ABC                                     efgdf
ABB                                     bdc
ABB                                     cdfegdf
.
.
.
 
What I would like is that when I search for a chapter title, to have the result of sentences summed up in a field and separated by serial numbers starting from 1
 
For example: Searching the above data for the title:
 
ABC should show the output in a field as:    aaba (1) abac (2) efgdf (3)
 
Of course chapters have variable numbers of sentences, so the count has to stop with the last sentence.

 

I really appreciate your help.

Posted

If you sort your records by chapter, you can use a summary field to number the sentences in each chapter like this:

 

ABC
1    aaba
2    abac
3    efgdf
ABB
1    bdc
2    cdfegdf

 

 

Getting the result into a single field like in your example would be more difficult - and I am not sure what purpose it would serve.

Posted

The textbook is the bible, and the sentences are the verses. I have the verses in separate records for searching exact location..

 

The purpose of the output as such is to read the chapter in a formal way, with numbered verses.

Posted

Dear Comment,

 

As it used to be, you always have a solution; and to be more precise, the best solution

 

THANKS

This topic is 4051 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.