TrimLeft function trims off one extra character

Hi there,

I am using Trimleft function to trim a string. However, it trims off one extra character.

To be specific, I have a field with value "BBC Kmlfsgees - LI6 - KE GAIN/LOSS", and I want to trim off "BBC Kmlfsgees - LI6 - " and keep "KE GAIN/LOSS". So I use

TrimLeft([Field1], "BBC Kmlfsgees - LI6 - ")

But the result turns to be "E GAIN/LOSS".

Does anybody know why? In addition, how to fix it? I know that Regex_Replace can do the job. However, can we fix the issue with TrimLeft?

Thank you so much!

New Workflow3.yxmd

New Microsoft Excel Worksheet.xlsx

Common Use Cases

Accepted answers

jrgo

@wenjuanchen

The trim functions will trim off any set of characters that you’ve specified in the second parameter, not a specific string. It’ll continue trimming until it hits a character that wasn’t specified, which in this case the “E”.

try to use the ReplaceString() function instead.

jdunkerley79

I would consider the substring function as well

Substring([Field1], 21)

(I think 21 is the character length of you string to remove)

All comments

jrgo

@wenjuanchen

try to use the ReplaceString() function instead.

jdunkerley79

I would consider the substring function as well

Substring([Field1], 21)

(I think 21 is the character length of you string to remove)

wenjuanchen

Oops! I thought I could accept two solutions! I accepted yours first then the post after yours. But then yours is not accepted as solution anymore. Sorry! I tried Replace and it works well. Thank you so much!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703