>>It is good to see that you can think outside of the VFP-box. The messages regarding the use of VBscript were very educating.
>>
>>In order to replace some of my program that do some search and replacing I would like to know how I can do the following:
>>a text file contains a huge number of records. The fields are seperated with a comma but the record is not seperated. The end is allways a date. What I want to do is to add a carriage return after the the date.
>>
>>loreg = CREATEOBJECT('vbscript.regexp')
>>WITH loreg
>> .GLOBAL = .T.
>> .ignorecase = .T.
>> .PATTERN = '..\/..\/..'
>
>Bad pattern to start with; instead, try:
>
>.pattern = '(\d{2}/\d{2}/{d{2})'
Typo; should read:
.pattern = '(\d{2}/\d{2}/\d{2})
>
>>lcoutstring = .REPLACE(onzin, '\1\2\3 ' + chr(13))
>
>Bad replace string; try:
>
>lcoutstring = .Replace(onzin,'$1'+CHR(13)+CHR(10))
>
>You need to learn how regular expressions work; I'd suggest picking up a copy of "VBScript Programmer's Reference" from Wrox Press; it covers the use of the VBScript.RegExp object pretty well in a couple of chapters.
>
>>ENDWITH