0 Replies Latest reply on Feb 5, 2012 2:57 PM by philmodjunk

    Converting a custom value list into a table based value list

    philmodjunk

      Title

      Converting a custom value list into a table based value list

      Post

      Sometimes the need arises to change a value list from a list of custom values typed directly into the value list set up into a table based value list.

      Here's a quick and simple way to do that without needing to retype the values nor having to copy and paste them one value at a time into the new table of values:

      Open the value list in Manage | Value list and copy the entire block of custom values to the clipboard.

      Exit Manage | Value list and paste the text from the clipboard into an empty text field.

      Use Export Field Contents to export the values, producing a plain text file.

      Now use Import Records to import the text from the text file. You can use the new table option to import the data and create a new table for it at the same time. Since the values are separated by returns in the text file, each value is imported into a separate record.

      Return to manage | value list , select the value list for editing and use Specify Field to set it up to draw values from your new table of values.

      A similar method is to do the same steps above, but create the text file by pasting the copied values into a word processor and saving the file as plain text.