replace, substring

[Billy_u]

hello everyone,

I would like to make a substring to get how is the image,

I tried with the replace, but then also deletes me the last lines that are correct, I should set an if, with index, but I always have the same problem that cuts even the right ones

thank you

[tresesco · Accepted solution]

You could replacing ' lorem '  (note spaces at the beginning and at the end) with a single space, i.e. - ' '. So try like:

Replace( [Field input], ' lorem ', ' ') 

[Mauritz_SA · Accepted solution]

Hi there

A quick workaround could be to replace the word and the spaces with a space. In other words, it will look for lorem where there is a space before and after it and replace them with a single space. For example Replace([Field input],' lorem ',' ').

Regards,

Mauritz

[Billy_u]

succeeded, great

thank to Mauritz and Tresesco