1 Reply Latest reply on Jun 8, 2012 8:12 AM by philmodjunk

    Unifying Columns for Tab-Separated Text

    MaryStanley

      Title

      Unifying Columns for Tab-Separated Text

      Post

      Hi, so I've been making a database for medical records and I'm trying to format the tab-separated text export so that at the start of each column for each record, there's a consistent number for each record. Essentially so that it would look somewhat like this:

      001 patient_lastname   patient_firstname    patient_info
      001 patient_info      patient_info
      001 

      002 patient_lastname  patient_firstname    etc..
      002 

       

      Is this possible? Thank you!

        • 1. Re: Unifying Columns for Tab-Separated Text
          philmodjunk

          The format you have here is unusual. Are you sure that you don't want a single row for each patient instead of multiple rows--each with different data?

          That said, you can construct a calculation field that combines returns and tab characters to produce the format you have here.

          Let ( [ Pid = Right ( "00" & PatientID ; 3 );
                    Tab = Char ( 9 ) ] ;
                  Pid & Tab & Partient_lastname & Tab & Patient_firstname & Tab & Patient_info1 & ¶ &
                  Pid & Tab & Patient_info2 & Tab & Patient_info3 & ¶ &
                  Pid & ¶
                 )

          You can then use export records to export this field to produce the format shown.