Concatenating fields on import

[Charlie Kilo]

Hey guys. So I have some data in an Excel spreadsheet I plan to import into my Filemaker file.

The challenge is that the spreadsheet has the fields ADDRESS1 and ADDRESS2, which I'd like to concatenate into my Filemaker field ADDRESS.

I can't see a way to do this. Can anyone help me out?

[Keith LaMarre]

one way would be to import them into 2 fields - then

replace:Address 1 with

Address_1 & "¶" & Address_2

Once this has been done, address 2 can be deleted -

You might want to find only the records that have an address 2 first.

[aldipalo]

I believe you would need to import the 2 fields and set up the address field as a calc.

I have a program that grabs address info from web pages and documents and I need to Concatenate the company name + the zip code to create a unique comapnyid filed. I found it easier to do it on the excel side.

=CONCATENATE(LEFT(A2,5),LEFT(L2,5))

Of course you would have to play with that calc to allow for a "," and spaces.

So, you could set up a column in excel named address and concatenate the fields. They will copy over into FM with no problems.

However, I must say that if you are looking to format the address onto 2 lines Keith's' way is probably better.

HTH

Al

[Charlie Kilo]

Great! Thanks, guys.