IF you look at the Jpeg. I need to be able to create 1 line from all store # 2, and have all the QTY's in one field separated by a CHAR (29), and do the same thing with the UPC's. I don't know if this is duable in filemaker or with a plug in. If so please help me. Or if its something that has to be build let me know i'm willing to pay.

thanks

Nestor,

Create a self-join relationship between the stores.

Create a value list based on the new relationship.

Create an unstored, calculation field:

Substitute( ValueListItems( Get( FileName ) ; valueList ) ; "¶" ; "char29" )

Can I ask why? There may be another way of doing this that is easier.

Nestor,

Create a self-join relationship between the stores.

Create a value list based on the new relationship.

Create an unstored, calculation field:

Substitute( ValueListItems( Get( FileName ) ; valueList ) ; "¶" ; "char29" )

Can I ask why? There may be another way of doing this that is easier.

Mark,

Thanks for the info. but i can't seem to make it work. I did a self-join relationship between the stores, then i was creating a value list, but didn't know what to put in there,and then in the formula i didn't know what i needed to change. Here is my database, maybe you can guide me in the right direction. Thanks.

Im trying to build this because we have companies that send us a spreadsheet with thier order. this spreadsheet can have 1000 rows. we have a system that only allows 1 row for each store with all the qtys and items in that same row of course separated by char (29). so that excel sheet, can have 100 rows with the same store #, just different qty's and upc(ups relates to our item number in house).

Hope this makes sense.

Thanks for all the help.

test.zip

Nestor,

Try this.

You will need to replace the "xxx" and "yyy" with charcter29.

Test.zip

Nestor,

Try this.

You will need to replace the "xxx" and "yyy" with charcter29.

MARK, THANK YOU SO MUCH. This will make my life a lot easier. thanks again.

Sorry to bug you again, but how do i make it so that QTY's and UPC maintain the structure, because it seems that its putting lowest to highest for QTY's and UPC's. I want to have qty's and upc match as far as first, second, third....

Thanks

Yes, the ValueListItems() functions does sort the value.

Can you explain why the data needs to be in this format? It is a very odd setup.

Do you have a copy of Advanced or Developer?

Yes, the ValueListItems() functions does sort the value.

Can you explain why the data needs to be in this format? It is a very odd setup.

Do you have a copy of Advanced or Developer?

Hi Mark,

Sure thing.. it need to be in that format because our system will create a Sales Order based on this info. so for example it will create a sales order for store #2 and in this sales order it will link via a upc to an item number (size). So since each row has specific information such as the upc and the qty we have to ship for that UPC, then it has to reflect the same way in the sales order. So for UPC #1 (first UPC), has to go with QTY 3 (First QTY) becasue that's how the system will generate the order. I hope this made sense.

And im using 8.5 advance.

Thanks Mark.

One of these three custom functions should return the list as you desire with a little tweaking.

Custom Function 1.

Custom Function 3.

Custom Function 3.

And im using 8.5 advance.

I started to reply with an incorrect answer until I spotted this. Please update your Profile to reflect the version you are using.

Lee

One of these three custom functions should return the list as you desire with a little tweaking.

Custom Function 1.

Custom Function 3.

Custom Function 3.

Thanks. I'll give them a try.

Nestor

I started to reply with an incorrect answer until I spotted this. Please update your Profile to reflect the version you are using.

Lee

Done.

Thanks for letting me know.