MapInfo Pro

Hi all, i have had success in the past deleting all but the last ten characters in a text string using the "Update Column" function and the Value of:

Right$(Field_Name, 10)

However, I can't seem to work out how the "Update Column" function might be used to delete the first ten characters from a text string.

Any suggestions would be greatly appreciated.

Mark,

You need to calculate the number of characters to keep for each record and then extract these using the Right$() function:

Right$(Field_Name, Len(Field_Name) - 10)

Or you can use the Mid$() function to extract from character 11 to 254:

Mid$(Field_Name, 11, 254)

Thank you so much for your reply Peter?.

I had too many records of varying lengths to use your first solution and so I used the second one (Mid$(Field_Name, 11, 254) and it worked perfectly !!!!

Yours Sincerely.

Good to hear the solution worked for you.

The first one would have worked too even with varying length strings. I can see that my explanation could make it look like you have to calculate the length manually but that is build into the expression: Len(Field_Name) will return the actual length of the individual text strings