Discussion board where members can get started with Qlik Sense.
for my data load i need script commands that loads a field in a certain format.
E.g.: Field A has strings in the format shown below (A). I'd like to get rid of the strings like "-" & "/" and cut the data on 9 numeric digits (New A).
Thanks in advance.
Go to Solution.
May be Like this:
Left(KeepChar(A, '0123456789'), 9) as [New A]
That's it. Thanks again!