Paragraphing

[simoncpage]

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" & "

[RalphL]

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

[simoncpage]

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

[RalphL]

Pattern count would tell if an

[simoncpage]

How could I substitute [inputfield & "

[simoncpage]

IF [Patterncount(ID, "

[RalphL]

Use the Substitute Function

Substitute(Inputfield, "

[simoncpage]

Again that doesn't work for multi line like

1

2

|

As it takes out all the "

[simoncpage]

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

Set field ["ID", "Substitute("

[RalphL]

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

[simoncpage]

Sorry & thanks!