# Substrings / Trim Beginning Characters

**URL:** <https://community.easymorph.com/t/substrings-trim-beginning-characters/2983>\
**Category:** General Q&A\
**Created:** [August 24, 2021, 12:01am UTC](https://community.easymorph.com/t/substrings-trim-beginning-characters/2983 "2021-08-24T00:01:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![PD-Data](https://community.easymorph.com/letter_avatar_proxy/v4/letter/p/91b2a8/32.png) [@PD-Data](https://community.easymorph.com/u/PD-Data)\
**Post date:** [August 24, 2021, 12:01am UTC](https://community.easymorph.com/t/substrings-trim-beginning-characters/2983/1 "2021-08-24T00:01:58Z")

</div>

This should be basic, but I haven't found a way to trim off the first few characters of every record in a column. I'm not trying to trim leading spaces, I just need to remove the first 7 characters. Thanks.

---

<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:** [August 24, 2021, 12:31am UTC](https://community.easymorph.com/t/substrings-trim-beginning-characters/2983/2 "2021-08-24T00:31:27Z")

</div>

Try the [removestart()](https://help.easymorph.com/doku.php?id=syntax:functions:removestart) function.

---

<div class="post-metadata">

**Author:** ![PD-Data](https://community.easymorph.com/letter_avatar_proxy/v4/letter/p/91b2a8/32.png) [@PD-Data](https://community.easymorph.com/u/PD-Data)\
**Post date:** [August 24, 2021, 1:47am UTC](https://community.easymorph.com/t/substrings-trim-beginning-characters/2983/3 "2021-08-24T01:47:59Z")

</div>

Thanks, but that won't work. I have a long text string that begins with '75000US' followed by other text, which varies. I want to remove the '75000US', but from what I see, all I could remove would be everything but the 'S'. Every programming language that I've used has a SUBSTRING command where you can select any portion of a text string that you want.

---

<div class="post-metadata">

**Author:** ![roberto](https://community.easymorph.com/user_avatar/community.easymorph.com/roberto/32/8595_2.png) [@roberto](https://community.easymorph.com/u/roberto)\
**Post date:** [August 24, 2021, 7:20am UTC](https://community.easymorph.com/t/substrings-trim-beginning-characters/2983/4 "2021-08-24T07:20:19Z")

</div>

Hello @PD-Data,

I've tried it with Dmitry's formula and it works:

1. Sample data created:

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

1. Removestart() expression applied:

 ![image](https://community.easymorph.com/uploads/default/original/2X/d/d9b04b912749d4a7a56ca56b896afeb9cc5d2101.png)

"75000US" has been removed, including the "S". Are you doing something differently in your project?

Regards,

Roberto

---

<div class="post-metadata">

**Author:** ![Florent](https://community.easymorph.com/letter_avatar_proxy/v4/letter/f/e19b73/32.png) [@Florent](https://community.easymorph.com/u/Florent)\
**Post date:** [August 24, 2021, 8:39am UTC](https://community.easymorph.com/t/substrings-trim-beginning-characters/2983/5 "2021-08-24T08:39:06Z")

</div>

Hello,

There may be an invisible character such as a thousands separator.

---

<div class="post-metadata">

**Author:** ![PD-Data](https://community.easymorph.com/letter_avatar_proxy/v4/letter/p/91b2a8/32.png) [@PD-Data](https://community.easymorph.com/u/PD-Data)\
**Post date:** [August 24, 2021, 3:46pm UTC](https://community.easymorph.com/t/substrings-trim-beginning-characters/2983/6 "2021-08-24T15:46:42Z")

</div>

Thanks Roberto. That worked! Every example that I saw had matching text that needed to be included in the function. I wasn't aware that you could refer to the column itself.
