JSON output oddity

[GMScott]

I created 6 characters and output them to JSON. I'm trying to use those JSON files, but I notice a strange discrepency.

All of the objects in actors.actor.1.items have a suffix number on them, and that number does not match from one JSON to the next. For example, Armor Class is stored in the "acArmorClass.69" object for some characters and in the "acArmorClass.70" object for others. This makes it difficult for me to parse the files.

Is there some way to nail these suffix numbers down so I can get consistent output?

 

[GMScott]

Bump.

 

[Farling]

Does your parser have the ability to match up to the last "." in the name?

 

[Mathias]

The purpose of the suffix numbers is in case there's more than one of the same thing, like two daggers, on the character - they'll have the same Id, but different suffixes. The numbers are just generated based on an internal Id, which is somewhat based on the order things are added to the character (with a lot of exceptions, which is why I say "somewhat").

 

[GMScott]

Does your parser have the ability to match up to the last "." in the name?

That's a great question... to which I do not know the answer. I'm using Excel's Power Query. More like learning it. I can't seem to figure out how to get it to ignore everything past the period.

Does anyone have any suggestions?

 

[GMScott]

That makes sense, Mathias. Thanks.

 

[Roadie]

That's a great question... to which I do not know the answer. I'm using Excel's Power Query. More like learning it. I can't seem to figure out how to get it to ignore everything past the period.

Does anyone have any suggestions?

I'm not familiar with it, but there's probably something somewhere to split on a delimiter, in which case you could split on the period and just discard the number value.