Delete identical text in one column for 1000's of entries


#1

I’m a new Panorama user.
I have’t found if there is a method to delete (lets say) the last 4 characters of an entry shared by thousands of entries in the same column.


#2

For identical text stings: Make sure you are in that field (column). Then use the menu Search > Find & Replace …

If you would want to cut away the last 4 letters of different text strings, you could use the menu Fields > More > Morph Field … with a formula that makes use of text funnels (see Panorama X Help), e.g.

NameOfMyTextField[1,-5]

#3

I would begin by selecting the records that end with those 4 characters, using the Find/Select… dialog.
01%20PM

Then I would use Fill with Formula… with a text funnel in the formula to remove those characters.

06%20PM

The «» in the formula stands for the current field. You type it with option-\ and option-shift-\ .


#4

Thank you sir.
Your second approach worked.
Best