filename() change and make the name shorter

[Der_Unbekante_234]

Hello together,

My problem: I want to take just a part of the filename and want to do a little change on it.

For example:

The filename is: PR_E1440_G_FJH.cs

But I need only the part E1440

The little change should be a (.) point after the E. So what I want is to make is/get  E.1440

I tried this function:

subfield (RIGHT(LEFT(FileName(), 8), 5), 'E ', 1)&'.'& subfield (RIGHT(LEFT(FileName(), 8), 5), 'E', 2)

but the outcome is .1440 --> So the E is missing at the beginning.

Can someone help me? I would be very glad for any help.

BR

[Vegar · Accepted solution]

Try something like this.

mid(Subfield(FileBaseName(),'_',2),1,1) &'.'& mid(Subfield(FileBaseName(),'_',2),2)

[Chanty4u]

try something below

https://community.qlik.com/t5/QlikView-App-Dev/Adding-a-character-inside-field-value-in-load-script/...

https://community.qlik.com/t5/App-Development/Insert-symbol-into-string-every-x-character/m-p/178936...

[Der_Unbekante_234]

Thanks it works.