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.

Attachments

Outcomes