Hello,

I have a long text fields that's been calculating a lot of things and put them in one large text field to be exported. I want to calculate the lines of the text field with ValueCount function but I want the result to be in the same field as the one it's calculating. I tried to create a different field, which I got the number of lines, but when I try to insert that field in this long field, it shows a "?" and doesn't show up anything else in the field.

Does anyone know how to calculate the number of lines in a long text field and put the resulting number in the same field it's calculating?

Hope this is clear. Thanks anyone for assisting in advance!

You kind of lost me here:

11 hours ago, MA3 said:

I have a long text fields that's been calculating a lot of things

A text field does not calculate anything. If you want a calculation field that combines several text fields AND appends a line count of the result, you could do something like:

Let ( 
text = List ( Field A ; Field B ; Field C )
;
List ( text ; ValueCount ( text ) )
)

 

There is a way to add the line count to an existing text field by auto-entering a calculated value =

List ( Self ; ValueCount ( Self ) )

but this becomes problematic if you edit the field.

 

Well, I am trying to generate EDI files from our database. Now I know that sounds scary and people might say we will need to hire a programmer or something to do that, but I work for a non-profit and we just don't have the budget to do that. I am a little familiar with FileMaker and for past few weeks I have been looking at our payer's requirements and I see that once I am able to set up the system, the changes are minimal and we should be able to create those files.

So that's the reason I created one text field that combines a bunch of fields from everywhere in the database so that I can generate EDI txt files. But in one of the segments inside the EDI's file, it's asking for the number of lines in the document, so that would be the number of lines in the field that it's calculating.

19 minutes ago, MA3 said:

I am trying to generate EDI files from our database.

I am afraid that's a little too generic. Anyway, I think you have the answer: calculate the lines first, then return the lines and the number of lines.

--
P.S. My preference would be the export the raw data as XML and use a custom XSLT stylesheet to transform it into the desired EDI format. That way there is no need to burden the file's schema with elements that serve someone else. But it requires a basic knowledge of XSLT. 

Sorry about that, I could've explained this better but your answer worked for me great. Thank you so much!

I don't know anything about XSLT, but will try to google it and see if I can get anywhere that way.

Thanks again!