Opposite of LEFT function

[soncoku]

Hi all.

I have a column which has data like the row below:

          not in the system - A Random Client Name

What I'm trying to do is to is to use a function that will skip an x number of characters.

Like LEFT function

LEFT ([Field1], 20)  ==> Gets first 20 characters. I need something that skips the first 20 characters.

Any ideas?

[Emil_Kos]

Hi @soncoku,

I think you are looking for substring!

Substring(String,start,length)

Please mark as soled if this was helpful!

[echuong1 · Accepted solution]

You can use a right formula that takes into consideration the 20 characters to the left.

The formula below takes the right characters, with length of the total string minus 20. This skips the first 20 and takes anything after.

right([String],length([String])-20)

[MarqueeCrew]

@soncoku ,

 please try:

substring([field],19)

 cheers,

 mark