How to Trim Values??

[taimysho0]

Hello I have a phone column with values such as 9, 1234567890

How do I format the column to only show 1234567890 for example?? Thanks!

[jzwp11]

You could use the mid() function if your data is such that you will always want to view the string starting with the fourth character

mid(phone,4)

[taimysho0]

i see! thanks. also, what if i want to trim off the last 4 digits?

[jzwp11]

You can do this several different ways but it depends on the your data. If the data is of a consistent length and format, it would be pretty easy. For example, if you data is always like this: 9, 1234567890 and you want to always just show 12345, you can use the optional length parameter of the mid() function.

mid(phone,4,5)

The 4 defines the starting character whereas the 5 defines the length or # of characters to return. 12345 would be a 5 character long string.

You also could nest the various functions. The ones I use the most are the mid(), instr(), left(), right(). You can find more about each of these text manipulation functions in the Help section of Access.