Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm pulling in data that looks like this:
briggs_stration_8kw_
I want to remove the underscores and just have spaces along with Putting everything caps. How can I go about doing this in the backend?
Thank you!!
In addition to ogster1974's response, you may want to use Capitalize() instead of Upper() if you only want the first letter of each word capitalized. You may also want to use Trim() to get rid of any leading or trailing spaces:
Trim(Capitalize(Replace(YourField, '_', ' ')))
Upper(Replace('fieldname','_',' '))
In addition to ogster1974's response, you may want to use Capitalize() instead of Upper() if you only want the first letter of each word capitalized. You may also want to use Trim() to get rid of any leading or trailing spaces:
Trim(Capitalize(Replace(YourField, '_', ' ')))
What if I want to do if for multiple ones?
Upper() will force all letters to be capitals.
Syn:-PurgeChar(<feildname>, '[chars to remove]')
Upper(purgechar(FieldName,'_')) as Fieldname1
else
=upper(PurgeChar ('briggs_stration_8kw_','_'))
Hi Nicole,
Thank you!
What if I want to do this change to multiple items like,
spectrum__1250ds4 |
caterpillar__300 |
onan__dfej5745347_ |
ford_15kw |
So it's not just for one item I need to do this for a few different ones.
Thank you!
all the above methods, will change every value of ur field..
one advice though: please try the proposed solutions before wondering if they would work
Thanks Omar, I did but when trying to do it for more than one I was getting errors... But thanks....