Skip to main content

I have a field with a value "feather29sum"cxa. I need to extract the feather29sum only and ignore everything else. Can someone please help with this formula?

This should work:



TRIM(LEFT(SUBSTITUTE({Field Name}, '"', REPT(" ", 25)), 50))


Breakdown, in to out:





  • The SUBSTITUTE() function replaces the quotes with blocks of 25 spaces.


  • We then grab the left-most 50 characters, which picks out the first 25 spaces, all of the text you want, and some portion of the next 25 spaces.


  • We then trim off the spaces.


This should work:



TRIM(LEFT(SUBSTITUTE({Field Name}, '"', REPT(" ", 25)), 50))


Breakdown, in to out:





  • The SUBSTITUTE() function replaces the quotes with blocks of 25 spaces.


  • We then grab the left-most 50 characters, which picks out the first 25 spaces, all of the text you want, and some portion of the next 25 spaces.


  • We then trim off the spaces.



Thanks Justin, this is exactly what I needed.

Reply


Terms & Conditions