Jump to content

Repeating Fields to Standard Field


jtringale
 Share

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

Recommended Posts

Hi All,

I have a file that contains a repeating field with data in 12 repetitions. We now have a need to have this data placed in unique (Standard) fields. Is there any way to move (export - import) this data from the repeating fields to newly defined standard fields?

THanks for your help!

Joe T.

Link to comment
Share on other sites

Hi,

I should add that I tried exporting the data to MS Excel in a DIF file format. I saved it as a text file and then set out to use an " as a delineator. Problem was that some fields had multiple """" in them so that data was not consistent across the spreadsheet. For example one record contained more """ than others so that the data in each column was garbled.

Thank you.

JOe

Link to comment
Share on other sites

The best way that I found to do this was a pain, but you need to setup 12 fields to store the data and then you will do 12 replaces.

Start in the first field and replace via calculation like this: GetRepetition ( RepeatingField )

The others then get replaced as follows:

GetRepetition ( RepeatingField, 2 )

GetRepetition ( RepeatingField, 3 )

GetRepetition ( RepeatingField, 4 )

and so on.

Once finished you will have the data from the repeats in 12 seperate fields and you can then kill the repeating fields.

Link to comment
Share on other sites

This topic is 7389 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
 Share

×
×
  • Create New...

Important Information

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