creating text strings and exporting

joftech

Hi Support,

The problem I have is I need to create a long string of date and export the string to a text file. The string cannot have a any tabs or return characters.

each record would look like this

*I12533140806000622.5000 *VM01100806 0348259A3221820249SAVVAS *I12533140806000622.5000 *VM01260206 2277251K6164058992MIRIAM *I12533040806000622.5000 *VM01100306 2430613L2203650794DEREK *I12533130306000622.5000 *VM01180806 046273CY2418369164MEGAN *I12533210806000622.5000 *VM01260706 0232153X2024541978THOMAS *I12533030806000622.5000 *VM01050806 2009643A2414596834ASHLEY

I thought i could populate a non persistant object and then export the contents of that object. My problem is I cannot see how to populate the object from hundreds of records then export the content of the non persistant object without any return charactors or tabs

Best Regards
Alan

joftech

Futher to the above question I have had a look at LIST_LINE.

I can see how this can be used my problem is can it produce joined records with out line breaks.

Thanks

Alan

aware_support

My problem is I cannot see how to populate the object from hundreds of records

What do you mean? Which records is it populated from? Are these records in a file or in other objects?

joftech

What do you mean? Which records is it populated from? Are these records in a file or in other objects?

The data would come from an object called patientbilling. The user picks records from patientbilling to process. The process then create's teh string.

Alan

aware_support2

Unlike function LIST, function LIST_LINE does NOT insert line breaks. Please read the User Guide carefully, it is clearly described there.

If you want to let the user pick instances to appear in the text file, you can do it with a process like this:

PICK ONE OR MORE FROM PatientBilling WHERE ...
CREATE BillingBatch
INSERT PatientBilling IN BillingBatch.Items
EXPORT DOCUMENT BillingFile TO FILE 'C:/billing_file.txt'

BillingFile here is a document template of type Text that has a single tag in it like this one:

<<LIST_LINE(BillingBatch.Items, ...)>>

This is standard Aware IM functionality described in the User Guide.