Dear All,
I try to change the content of the text field in the macros.
Background: the content of the field is correct per se and should not be changed in the load script etc. The task is to save the states of a certain table in the different files after choosing the values in the field in a loop. The name of each file should be close to the corresponding value in the field. The values in the field however contain chars such as slash, asterisk, colon etc. which are not allowed in a file name.
I can achieve what I want with a list of consecutive replace commands. I thought of separating this list of commands in an extra function (I named it “brush”). However I cannot succeed to get a return value from this second function. The script is below. The message box in the brush function does show the string. However the string is not returned from “brush” into “checkout”. The call to brush function from the checkout function is now commented out.
Thank you very much in advance!
Here the minimal working example.
QlikView Load Skript:
Tab1:
LOAD * INLINE [
Nr, Name, Txt
1, name with /, a
2, another : one \, b
3, this * one too, c
4, or / as * mix, d
5, this : way / or * that, e
];
Macro Editor:
sub useit
call checkout(ActiveDocument, "Name")
end sub
function checkout(qvDoc, Testfield)
set nName = qvDoc.Fields(Testfield).GetPossibleValues
for i = 0 to nName.Count - 1
problem = nName.Item(i).Text
' problem = brush(problem)
problem = replace(problem, "/", "_")
problem = replace(problem, "\", "_")
problem = replace(problem, ":", " ")
problem = replace(problem, "*", " ")
msgbox problem
next
end function
function brush(str)
msgbox "In brush " & str
str = replace(str, "/", "_")
str = replace(str, "\", "_")
str = replace(str, ":", " ")
str = replace(str, "*", " ")
end function
