Solved! Go to Solution.
Hi @Ghosh
You'll want to use the below function:
Substring([Field1],0,length([Field1])-1)
Which starts at the beginning of the field then goes on for the length of the field minus 1
If it is only one character?
thank you for your reply and it helps.
Although I found out that there was an extra "Space" after the data in the fields. So I used 2 TrimRight functions to get them out.
Will make another copy of the data with your provided solution,
Great stuff, could just leave the trim in as well, in case the data has it again in future.