Basic Calc Needed

[maui]

I have a text field that looks kinda like this:

112

144

233

235

344

355

433

419

I need a calc which will insert titles above each subset grouped by hundreds...not sure if i described it properly but here's what it would end up looking like using the above text field:

Parts

112

144

Surplus

233

235

Inventory

344

355

Assets

433

419

Calc must locate the first occurrence of the 'hundred' digit change and insert title above it.

Thanks folks! What a great group you are for beginners like me.

Maui

[LaRetta]

Hi Maui, we could come up with a calculation to handle this but I truly suggest instead that you take that data (in one field) and use one field with records instead. This won't be the first time that this need (in various forms) will arise. :wink2:

[Lee Smith]

This appears to be a continuation of this thread Link ?

[maui]

Thank you both. It is sort of a continuation however I am attempting to create one large text field calc that will display all items including their categories...respectively.

So Loretta, you are saying to create a field for each far left starting character...ie...

112

135

these would go in 'field a'

243

288

these would go in field b

333

398

into field c

so on???

thanks!

maui

[bcooney]

You should have one fact per field.

So, you need two fields, Category* (or whatever you call the Title) and Value.

The record's will look like:

Parts 112

Parts 140

Surplus 233

Surplus 235

Inventory 344

Inventory 355

And then, you have the right structure to report however needed.

*You actually should have CategoryID which refers to a table of Categories, each with a Name and unique ID.

[maui]

Thank you. Interestingly, we have a table with Category, Unique ID, product name. The problem is when someone creates an order in our cart and we set the order, it has to create about 150 new records for each order. The PHP triggers the order creation and the lag time is about 8 seconds in response from filemaker back through the api to our cart. we have looked at other means to speed this up but i believe a single text field parsed out is our best option

[bcooney]

"it has to create about 150 new records for each order. "

Why? I don't understand.

Have you looked at using mySQL tables for the web and accessing them using ESS in FM?

[maui]

bcooney:

thanks for the advice. Is this something you could set up for us? I would be happy to pay you.

if this would be a faster method and no chance of connectivity errors, i am very interested!

Thanks!

maui

[bcooney]

Sorry, my plate is quite full, but I'd be happy to answer questions. If you go to FMI's website, there's a link to consultants and I'm certain someone is close by.

Setting up MySQL and ESS is really quite simple. Have you looked at the documents on the FMI site? It's very clearly described.

Before you go there, I'd like to know why each order is 150 records. Perhaps your data model isn't setup correctly.

[Raybaudi]

The correct solution is the one from bcooney, but I still wanted to respond to your first question with a calculation as a personal exercise.

Maui_Basic_Calc.zip

[maui]

Ray: Thank you for the calc. Perfect!

Barbara: Thanks. Here's what happens. Our customers create a menu in ajax and it's stored in session. When they get to checkout, the very last page is where ALL the action occurs. We hit the Authorize.net api, fedex api, create the order, the customer info, order line items, inventory deduction, etc. the order line items creates up to 80 records alone because our customers can choose up to 80 items. So the PHP posts the session data and WHAM all the records are cretaed. It was taking 22 seconds to process the order. With this text field, it only takes 3-4 now. Thank you both for helping. Very very appreciative for your kindness.

Maui

[Ocean West]

I have split this post here, and re-opened it.

Everyone please keep in mind the house rules - and stay on topic.

[Raybaudi]

I apologize to anyone I may have offended, especially with LaRetta that is a pillar of the Forum.