text function question

[skearton]

I have a field that has a size and typically looks like this:

6 in H x 6 in W

 

How do I take the value of that field and insert a paragraph return after the "x" and removes the blank space before the next character so that it looks like this:

6 in H x

6 in W

 

Thank you for your help.

[databaser]

I don't have a carriage return symbol handy, but it's that thing you click that looks like a P.

 

This should do it:

substitute (field ; "x " ; "x[carriage return symbol]")

[bruceR]

The pilcrow (¶) is option-7 on the Mac.

 

Why do you need to do this?

 

If you had a separate height and width field, your calc would be less complicated and more error-resistant.