substring, concat, replace function are not support in IDM word plug-in

Hi All,

I have requirement to retrieve minimum expiry date from configurable XML. below is sample XML.

I wrote below Xpath statements to retrieve minimum LMEXPI value.

1. --> min(//Subdocument/Lines/Line/Custom/LMEXPI[.!='']/number(concat(substring(.,0,5),substring(.,6,2),substring(.,9,2))))

when I apply above xpath, word plug-in gives below error message

Thank you

Priyantha

Find more posts tagged with

Infor Document Management (IDM)

Accepted answers

All comments

Thomas Kneidl

Hi Priyantha,

I think your substring-indices are wrong, shouldn't it be substring(.,0,4), substring(., 5,2), substring(8,2)?

Best regards

Thomas

Legacy Contributor

Hi Thomas,

Thank you for quick reply.

I have applied it in external editor, it gives error NAN.

But my xpath expression gives output

This is structure

<?xml version="1.0" encoding="UTF-8"?>
<M3OutDocument>
<DataArea>
<Document>
<Subdocument Label="Subdocument">
<Lines Label="Lines">
<Line>
<Custom>
<LMEXPI/>
</Custom>
</Line>
<Line>
<Custom>
<LMEXPI>2021-12-31</LMEXPI>
</Custom>
</Line>
<Line>
<Custom>
<LMEXPI>2021-12-21</LMEXPI>
</Custom>
</Line>
</Lines>
</Subdocument>
</Document>
</DataArea>
</M3OutDocument>

Copyright © 2025 Infor. All rights reserved.