Extract fields form table columns

[devicode]

How do I extract the "Moving From"- city, state, and zip. And the "Moving To" city, state, and zip. With out them getting mixed up?

[devicode]

You will need to create separate fields for each see http://www.devicode.com/forum/about561.html

This is how you would create them

1. Create field FromCity.
   # Start of Data Field'
   For the FROM select 'Specific text'
   For the TEXT enter City(.*?)City
   # 'End of Data Field'
   For the TO select 'Use Match String'
   For the TEXT enter 1
   
   
2. Create field FromState.
   # Start of Data Field'
   For the FROM select 'Specific text'
   For the TEXT enter State(.*?)State
   # 'End of Data Field'
   For the TO select 'Use Match String'
   For the TEXT enter 1
   
   
3. Create field FromZip.
   # Start of Data Field'
   For the FROM select 'Specific text'
   For the TEXT enter Zip(.*?)Zip
   # 'End of Data Field'
   For the TO select 'Use Match String'
   For the TEXT enter 1
   
   
4. Create field ToCity.
   # Start of Data Field'
   For the FROM select 'Specific text'
   For the TEXT enter City(.*?)City
   # 'End of Data Field'
   For the TO select 'End of line'
   Check the 'Above words/phrases are regular expression' box.
   
   
5. Create field ToState.
   # Start of Data Field'
   For the FROM select 'Specific text'
   For the TEXT enter State(.*?)State
   # 'End of Data Field'
   For the TO select 'End of line'
   Check the 'Above words/phrases are regular expression' box.
   
   
6. Create field ToZip.
   # Start of Data Field'
   For the FROM select 'Specific text'
   For the TEXT enter Zip(.*?)Zip
   # 'End of Data Field'
   For the TO select 'End of line'
   Check the 'Above words/phrases are regular expression' box.