Joining fields based on text case

[markf]

If field one begins with a capital letter and field

two begins with a lowercase letter, (the sentence was split into two) how do I search to find all field two's that begin with lowercase and join them back up with field one and leave all field two's that begin in uppercase alone?.

[Raybaudi]

This is the calc that you have to apply to a [color:red]copy of your DB.

1)Insert the cursor into the field1

2)Records --> Replace Field Contents... --> Replace with calculated result: --> Specify

Case (

Length ( Filter ( Left ( field2 ; 1 ) ; "ABCDEFGHJKILMNOPQRSTUVWXYZ" ) ) ; field2 ;

field1 & " " & field2

)

Remember to do this to a [color:red]COPY of your DB

[markf]

Thanks for the speedy reply.

I'll let you know how I get on.

Cheers

Mark

[Raybaudi]

A little typo:

Case (

Length ( Filter ( Left ( field2 ; 1 ) ; "ABCDEFGHJKILMNOPQRSTUVWXYZ" ) ) ; [color:red]field1 ;

field1 & " " & field2

)