Clean-up a global field.

[Casper]

I have a global field that is being populated with some information from an html file and I need to clean that field data to create a value list.

Global field data looks like this:

<option selected="selected" value="<ALL>">&lt;ALL&gt;</option>

<option value="Domain\aaRequestor">Requestor, </option>

<option value="Domain\UserID1">lname1, fname1</option>

<option value="Domain\UserID2">lname2, fname2</option>

<option value="Domain\UserID3">lname3, fname3</option>

<option value="Domain\UserID4">lname4, fname4</option>

<option value="Domain\UserID5">lname5, fname5</option>

What I need is to extract only the lname, fname and create a value list to populate a dropdown list.

I am trying to get a value list that will looks as follow:

ALL

Requestor

lname1, fname1

lname2, fname2

lname3, fname3

lname4, fname4

lname5, fname5

I appreciate any help that I can get.

Thank you.

[imoree]

sounds like export xml and import xml CF's

If not, then you will need to master substitute function

-i

[Lee Smith]

Hi Casper, welcome to the forum,

I moved this topic from "FileMaker Product Family → FileMaker Pro 11" to "Database Schema & Business Logic → Calculation Engine (Define Fields)" because, the General topic areas are intended for the discussion of the functions, features and tools that were new with the particular version you posted it in.

All how-to question should be posted to a topic area that best matches the sprit of the problem. Many questions can fit into more then one area, but you only need to pick one, and go with it.

If you have any questions about this action, please contact me through a private message.

Lee

[Lee Smith]

Here is an example of what the substitution calculation would look like

Trim4 (

Substitute (

  Raw data ; [ "=" ; "" ] ; [ ">" ; "" ] ; [ "<" ; "" ] ; [ "/" ; "" ] ; [ "" ; "" ] ; [ """ ; "" ] ; [ "option" ; "" ] ;

[ "value" ; "" ] ; [ " domain" ; "" ] ; [ "DomainaaRequestor" ; "" ] ; [ "," ; "" ] ; [ "DomainUserID1" ; "" ] ;

[ "DomainUserID2" ; "" ] ; [ "DomainUserID2" ; "" ] ; [ "DomainUserID3" ; "" ] ; [ "DomainUserID3" ; "" ] ;

[ "DomainUserID4" ; "" ] ; [ "DomainUserID5" ; "" ] ; [ "selectedselected ALL&lt;ALL&gt;" ; "" ]

)

)



//Raw data = your global field

// Trim4 Is a custom function found here

http://www.briandunning.com/cf/166

So you have to have access to FileMaker Pro Advance as the function is recursive

HTH

Lee

[bcooney]

I wouldn't do this in a global field. I'd import into a table and create my value list from the table (parsing out the values into fields). Also, I don't understand the selection choices that you want. What is Requestor and how is that different from the names? Do these names correspond to any records in your system? What IDs are you storing?