Pretty new to Filemaker. Database I inherited has the all the postal information in one field (address, city, state/region, postal code). Would love to parse the whole thing into separate fields, but it's not formatted consistently. But I know I can move the first line into an "address1" field.

Can anyone explain or point me to information on how to copy the first line in a field to another field?

Thanks,

Eric

Try GetValue ( field; 1)

Try researching the "Leftwords" and "MiddleWords" functions. I think these will help you out in this situation.

Hi emsbrooklyn,

Database I inherited has the all the postal information in one field (address, city, state/region, postal code).

You can integrate all the functions that have been mentioned such as "GetValue" to take information per line, then you can do "Left", "Right" or "Middle" functions after you perform "GetValue" script step.

If you need more help or information, you can try to give an example of an address in your field, so we can help you better.

Hope that helps...