topic Re: Remove Last 3 characters in load script in QlikView

Remove Last 3 characters in load script

davekski — Thu, 05 Sep 2019 19:40:14 GMT

I have a field "Related Id" that I need to remove the last 3 characters from all the values. My load script currently looks like this. I have tried several variations of trim but nothing seems to work:

LOAD
"Related Id",
Status,
"Comment",
left("Related Id",len(trim("Related Id"))-3)

FROM [lib://TrackWise Reports/Workflow History Cancelled 9-5-2019.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);

Re: Remove Last 3 characters in load script

sunny_talwar — Thu, 05 Sep 2019 19:51:17 GMT

May be this

LOAD "Related Id", "Status", "Comment", Left(Trim("Related Id"), Len(Trim("Related Id"))-3) as NewField FROM [lib://TrackWise Reports/Workflow History Cancelled 9-5-2019.csv] (txt, codepage is 28591, embedded labels, delimiter is ',', msq);

Re: Remove Last 3 characters in load script

davekski — Thu, 05 Sep 2019 19:57:12 GMT

That worked, thank you!!