How to write formula with Field name has line breaks ?

flying008

Dear all , hello !

1- I want to get a result with [Field] * 10 .

2- But the filed name has line breaks between '123' and 'ABC', in formula , normal syntax can't get right result.

3- I don't want rename it and then restore name.

4- Anyone know how to get output only use formula ?

录制_2023_09_11_10_09_22_400.gif

Developer

Tips and Tricks

Bug

Expression

Accepted answers

caltang

I think it has to do with how Formula tool reads the field name:

Because it needs to read one line in order to work, otherwise it will not read it at all. It will treat it as an incorrect field name, eventhough we know it to be correct - this is one limitation of field names. The other is that it cannot be a duplicate name of an existing field.

Hope that helps! If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

All comments

caltang

You can use the Multi-Field Formula and tick your field of interest, and use the formula accordingly.

caltang

Like this:

flying008

Hi, @caltang

Thank you ! this is a bypass solution. What's wrong in the formula parse itself ?

caltang

I think it has to do with how Formula tool reads the field name:

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703