Hi,
You can use TextBetween function
Data:
LOAD
Text,
TextBetween(Text,'Enjeu total: ', '€') AS [Enjeu total];
LOAD * Inline[
Text
AAA BBBB enregistré, ref: 0571468160857ZDUzzz 01/01/20000 X1Y4 Type Detail 3 Enjeu total: 212€ Nouveau Solde: xxx,yy€
];
Regards,
Vitalii
Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").
