I wrote this in Defining Fields - but I think it should be here

I have some fields (used as a relation) which are in the format of:

1).

1234| <cursor here

and some in the format

2).

1234

| <cursor here

The problem is that If I use the fuction:

SetField (InputField"; InputField & "5678" & "

Uou need to clean up your data. You can do this with the Replace by calculation. Use substitute to change "

IS there a way of telling simply which type the field is (i.e whether it contains "

Pattern count would tell if an

How could I substitute [inputfield & "

IF [Patterncount(ID, "

Use the Substitute Function

Substitute(Inputfield, "

Again that doesn't work for multi line like

1

2

|

As it takes out all the "

I'm using this to get rid of a line.

Set field ["ID", "Substitute("

You didn't say anything about mutliline. If you just want to reopmve the last

Sorry & thanks!