Help in MID function

[theboss-123]

Hello 

i have invoice (FAF-U1200-20163411) and Credit not (AVC-U1200-201600007) is there a way in load statstement to display just invoice which start with "FAF" i hear about Mid function anyone please could give an assist

[BrunPierre]

Provide the whole load script.

[theboss-123]

the informations are availble on FACT_Facture the filter could be apply on "NUM_0" as Dim6

[BrunPierre · Accepted solution]

See attached. The filter is applied at the backend and as a calculated expression. Choose what works best for you.

[theboss-123]

Thanks a lot Pierre for your time and your  help this is what i was looking  for thanks again