When using a csv file extracted from iAuditor I get to many characters as input in my field
Field name Action_Priority gives an output ""Medium"" where I want to remove the "" on both sides. Basically this counts for all Fields.
I have tried:
Left(Action_Priority, Len(Action_Priority)-2) as Action_Priority2,
This works for one side (characters "" on the right are removed but I don't manage it to get it also working on the left.
On the other hand it would be great if there is also a single line scripting removing the characters "" text "" for all fields.
I am not a Qlik sense Goeroe so please be patience
Thanks in advance !!
If you don't have or expect any "" inside the string but always just in the beginning and the end you could do this:
Replace(Action_Priority,'""','') AS Action_Priortiy2
Or if you want to be sure to only remove them from the beginning and the end:
If( Left(Action_Priority,2)='""' AND Right(Action_Priority,2)='""' , Mid(Action_Priority,3,Len(Action_Priority)-4), Action_Priority) AS Action_Priority2
Sorry for my late reply, I managed to get the thing solved with
Replace(Action_Status, Chr(34), '') as Action_Status2
Thank you for your support in this!
Thank you for your answer and reply. I used
Replace(Action_Status, Chr(34), '') as Action_Status2,
In the end I did not have to use the script anymore as i found a better way to get my data without ' " ' .
But anyway it is helpful!