Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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);
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);
That worked, thank you!!