Remove Last 3 characters in load script

[davekski]

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);

[sunny_talwar · Accepted solution]

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);

[davekski]

That worked, thank you!!