Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
François
Contributor III
Contributor III

Extract chaine

Bonjour, d'une chaine comme celle-ci je cherche à extraire le montant indiqué en gras

AAA BBBB enregistré, ref: 0571468160857ZDUzzz 01/01/20000 X1Y4 Type Detail 3
Enjeu total: 212
Nouveau Solde: xxx,yy€

 

Quelqu'un aurais une idée ?

Merci 

François

Labels (1)
2 Solutions

Accepted Solutions
vchuprina
Specialist
Specialist

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").

View solution in original post

vchuprina
Specialist
Specialist

link to the article in French🙂

https://help.qlik.com/fr-FR/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

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").

View solution in original post

2 Replies
vchuprina
Specialist
Specialist

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").
vchuprina
Specialist
Specialist

link to the article in French🙂

https://help.qlik.com/fr-FR/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

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").