String functions

[#1]

Hello,

I try to map the QVW files which I use on the server.

I read the log files and try to extract data from it.

For example, I have the following lines:

0022 FROM ..\..\QVD\R3_TABLE\MARA.QVD (qvd)

0032 FROM ..\..\QVD\R3_TABLE\MAKT.QVD (qvd)

0040 FROM ..\..\QVD\R3_TABLE\T023T.QVD (qvd)

0046 FROM \\aaa.com\fs3\SAP\QV\QlikView\Apps\LoadTables\QVD\Planet\Open_Period.qvd (qvd)

0049 FROM ..\..\QVD\R3_TABLE\ZMM_PRDGRPT.QVD (qvd)

0055 FROM \\aaa.com\fs3\SAP\QV\QlikView\Apps\LoadTables\QVD\Planet\Planet.qvd (qvd)

0073 FROM \\aaa.com\fs3\SAP\QV\QlikView\Apps\QVD\QVD_Text_table\TCOMPANY.QVD (qvd)

0124 FROM ..\Collection\Update_Details.QVD (qvd)

0130 FROM ..\Capacity\Update_Details.QVD (qvd)

0142 load * from QVD\KPI_aF.qvd (qvd)

0144 FROM ..\OTDProductiontoSC\QVD\Update.qvd (qvd)

0151 FROM ..\ProductionKPI\QVD\Update.qvd (qvd)

0156 FROM ..\..\QVD\R3_TABLE\NAST.QVD (qvd) where VSTAT=1

0156 FROM ..\Collection\Update_Details.QVD (qvd)

0166 FROM ..\Finance\QVD\Update.qvd (qvd)

I'm trying to get all information between the last "" and ".QVD" or "qvd"

I tried the following script:

Purgechar(TextBetween(@4, '', 'qvd',(substringcount (@4, '' ))),'. QVD (') & '. qvd' as Table,

But the result is that the files arrive without the letters Q, V and D.

Thanks in advance for your help

Elad

[sparur · Accepted solution]

Hello, Elad.

see in my example...

[#3]

Hello,

Thank you for your answer

Now I try to enter all this parts to one script.

This is my script:

TextBetween('@4',(text( index('@4', '\', substringcount('@4', '\')) + 1)),(text(index(upper('@4'), '.QVD')-1))) as Table,

Without any result

Do you know what is the problem?

Thank you again

Elad

[sparur]

use Mid() function instead of TextBetween(). see in my example...

[#5]

Many thanks

Its look graet now.

Elad