# Suffix with comma between last name and suffix causing rows to shift

**URL:** <https://community.easymorph.com/t/suffix-with-comma-between-last-name-and-suffix-causing-rows-to-shift/1538>\
**Category:** General Q&A\
**Created:** [January 6, 2020, 10:01pm UTC](https://community.easymorph.com/t/suffix-with-comma-between-last-name-and-suffix-causing-rows-to-shift/1538 "2020-01-06T22:01:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bill\_Walker](https://community.easymorph.com/user_avatar/community.easymorph.com/bill_walker/32/1428_2.png) [@Bill\_Walker](https://community.easymorph.com/u/Bill_Walker)\
**Post date:** [January 6, 2020, 10:01pm UTC](https://community.easymorph.com/t/suffix-with-comma-between-last-name-and-suffix-causing-rows-to-shift/1538/1 "2020-01-06T22:01:45Z")

</div>

I'm have a commas separated file where column 5 contains a name (first name middle name last name and suffix) and in some instances there is a comma after the last name and before the suffix which is causing the data to shift to the right.

Is there a way to filter on that column for a "comma" and then remove the comma and anything after that - see example below

Column 1, Column 2, Column 3, Column 4, Column 5 (issue column with , Sr), Column 6, Column 7, Column 8  
220592,3422,22,Healthcare Center Franklin,William E Walker,Sr.,8730,1017.0,false

---

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [January 6, 2020, 11:22pm UTC](https://community.easymorph.com/t/suffix-with-comma-between-last-name-and-suffix-causing-rows-to-shift/1538/2 "2020-01-06T23:22:05Z")

</div>

Hi Bill and welcome to the Community!

See below a sample project that removes extra comma from Column 5. Actions have annotations so you should be able to follow the calculation logic. Let me know if anything is not clear.

[remove-extra-separator.morph](https://community.easymorph.com/uploads/short-url/5wpGSARRp4GlknxWvCz6DpmyBNV.morph) (4.6 KB)  
[data.csv](https://community.easymorph.com/uploads/short-url/dtyjoNNGhyJcwoeoDE1xlmB3Kto.csv) (238 Bytes)

 ![image](https://community.easymorph.com/uploads/default/original/2X/7/71f4bc43d883728b5585698aac2d524d6a5f8fbe.png)