Liveware Publishing Support Forum

I am using R&R Version 6.5.08 in a Windows 3.1 environment.__The data I am working with is Btrieve (files in Btrieve version 6 format).__I am attempting to use R&R to export the data from this system to text files to be imported into a new Win NT/SQL based system.__My problem is: The data in the Btrieve files has fields that contain CR/LF characters embedded in them. R&R does not seem recognize them.__I have created a calculated field using STRSEARCH to look for CHR(13) in the field, but I always get a ^0^. (I know the STRSEARCH calculation is correct, because it detects CHR(32)-space)____How do I get R&R to recognize the CR/LR? Can I replace it with something else? Is there a setting that tells R&R to ignore these types of characters?____Any help would be appreciated.____DuWayne Engman__Rex Healthcare

Cr/LF are reserved characters that you cannot test for via chr() calcs.____What you can try is copying the file RSW.SRT from R&R disk 1 to your RSW.EXE directory. Edit the file to uncomment the line:__; DBCHARS=ANSI__so it becomes__DBCHARS=ANSI____Save the change, re-start R&R and see if it helps.____Kathleen__R&R Support

I cannot find that file. The original disks appear to be lost somewhere in our cavernous IT department (we may never see them again!)__Can you email me a copy of the RSW.SRT file for version 6.5.08__I^d really appreciate it!____duwayne.engman@rexhealth.com

Just sent it. I hope that it fixes things.____Kathleen__R&R Support

There was no line in the RSW.SRT referring to DBCHARS=ANSI__Could it be some other file (a INI fle maybe)?

Not sure if this will help as we are reporting against an access/sqlserver database but we use strrep to replace characters we dont like.____Perhaps you could use it to put in a marker ?____i.e STRREP(Address,chr(13),"")__seem to work fine.____YOu can use variuos cobos of this to pick up Cr Line feeds etc.