AnsweredAssumed Answered

Delete text substring from longer text

Question asked by DanBear on Apr 2, 2019
Latest reply on Apr 8, 2019 by DanBear

I have a field in a .dbf file with a long text string.   I need to delete x amount of characters WITHIN the text string.    I am also not very good with programming so I haven't looked into creating a script.  


Essentially I have this:


aaa bbb ccc ddd eee fff ggg


What I need is this:


aaa bbb ccc fff ggg



I'm attaching the .dbf in MS Excel format (.xls).   I have had some luck with functions in MS Excel but I can't get the consistency I need.