Replacing Characters In a String

[Former Member]

I have a string field that I need to shorten - typical data looks like '123456-789 XYZ' I can get rid of the XYZ as it is always in the 18,19,20th positions in the string. I need to shorten the field to '123456' but the dash isn't always in the same spot. Can I use the REPLACE function to get rid of everything after the "-"?

[abhilash_kumar · Accepted solution]

Hi Layne,

Use this formula:

left({string_field},instr(string_field,"-")-1)

//This will get rid of the 'XYZ' as well

Hope this helps!

-Abhilash

[Former Member · Accepted solution]

That did the trick!

Thanks