Help

Re: Empty Space in search formula

Solved
Jump to Solution
1027 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jaxtraw
4 - Data Explorer
4 - Data Explorer

I am using a mid formula to extract a string of text. The string appears as expected in the cell, but when Make (Integromat) runs the search it is adding an extra space before the string. " <string>" If the empty space is present, wouldn't I see it in the cell?

I have checked over an over again to verify there is no extra space in the formula in Make. I have also changed my formula to +2, +2.

Variations of this MID formula works with other use cases, this is the only one inserting an extra space. Is there a better way to do this?

 

MID(
    {Summary},
    FIND(
        ':',
        {Summary}
        )+1,
    FIND(
        ',',
        {Summary},
        FIND(
            ':',
            {Summary}
            )
        )-(FIND(
            ':',
            {Summary}
            )+1)
    )

 

 

Screen Shot 2023-09-13 at 11.25.55 AM.pngScreen Shot 2023-09-13 at 11.26.45 AM.pngScreen Shot 2023-09-13 at 11.27.24 AM.pngScreen Shot 2023-09-13 at 11.28.14 AM.pngScreen Shot 2023-09-13 at 11.29.04 AM.png

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

There is a TRIM function. It removes the extra spaces before and after.

TRIM(string)

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

There is a TRIM function. It removes the extra spaces before and after.

TRIM(string)

Thank you! That worked! I just wrapped the whole formula in TRIM ( )