Hi, I was wondering if there was any way to get text from a field that appears before a line break?

When trying to export text with line breaks within the field, I am getting errors. I either need to remove the errors, or grab the text before the line break.

Can anyone help?

Thanks

By line breaks do you mean carriage returns? In which case, how about Substitute (TextField; :paragraph:; " ") ?

HTH

Edited November 6, 200718 yr by Guest

If you are saying you need to break up that field into two fields, then you can:

1) Leave the existing field alone.

2) Back up first.

3) Create 1 new field called part1. The second half of the field will later be called part2 and will be left in the original field.

4) Show all records

5) Place cursor in the [color:green]part1 field

6) Run Replace Field Contents ( Replace by calculated result) and type the following in the calc box:

[color:blue]GetValue ( yourOriginalField ; 1 )

7) Click OK and then REPLACE

... if you are sure this is correct then you can remove that portion from your existig field and rename the field (if you wish). So now:

8) Place your cursor in the [color:green]ORIGINAL FIELD

9) Run Replace Field Contents ( Replace by calculated result) and type the following in the calc box:

[color:blue]Substitute ( yourOriginalField ; GetValue ( yourOriginalField ; 1 ) & ¶ ; "" )

10) Click OK and then REPLACE

If neither of our posts help you, then we need more information. The reason you've had 37 people read it but only Matt and I respond is because your request is unclear.

We have no idea how you are exporting because normal carriage returns within FM export fine. I'm giving you a wing and a prayer because I'm blind on what you really want. What program won't accept standard paragraph text and how are you exporting?

LaRetta :wink2:

Edited November 6, 200718 yr by Guest
Added afterthought which should have been forethought