.ExtractText not parsing sheet macro codes

[rreminy]

For example:

• Excel table Fate row Id 1873 in JP contains this: 不条理魚人「<sheet(BNpcName,13542,0)>」, however when extracting text with ReadOnlySeString.ExtractText() it results in 不条理魚人「」. In other words, the macro expands to an empty string.

[Haselnussbomber]

ExtractText only extracts payloads of type Text.
If you want to process macro payloads you have to write your own evaluation function for that.
It’s complex and depends on the context of the client (language, time, global parameters).

In case you're using Dalamud, I've added an extensive ISeStringEvaluator service (implementation), which resolves these kind of payloads.