Replacing Characters in a Dataport

I would use a codeunit and do the following, rebuild the file by reading it into a varaible and writing it back to a new file then run the dataport on the clean file.
You will need to use the combination of the 3 chars, then remove the invalid , and " from the selected string (Field)
This only works if the file has comma's and text delimiters ","
This is from memory so not tested and may need adjustment

CLEAR(OldFile);
OldFile.TEXTMODE := TRUE;
OldFile.OPEN(FileName);
WHILE OldFile.POS <> OldFile.LEN DO BEGIN
//Read the line into a variable LineDetail
OldFile.READ(LineDetail);
CLEAR(TempDetail);
//Use STRPOS to find your string ","
WHILE STRPOS(LineDetail,'","') > 0 BEGIN
CLEAR(TempStr);
Position := STRPOS(LineDetail,'","');
//Cut the Field from the LineDetail
TempStr := COPYSTR(LineDetail,1,Position-1);
//Trim the lineDetail
LineDetail := COPYSTR(LineDetail,Position+3);
//Remove Invalid text " and ,
TempStr := DELCHR(TempStr,'=','"');
TempStr := DELCHR(TempStr,'=',',');
//Build the New Line
IF TempDetail <> '' THEN
TempDetail := TempDetail +',' +TempStr
ELSE
TempDetail := TempStr;
END;

//We still may have some text to add and the comma for the last field
//Remove Invalid text " and ,
LineDetail := DELCHR(LineDetail,'=','"');
LineDetail := DELCHR(LineDetail,'=',',');
//Build the New Line
IF TempDetail <> '' THEN
TempDetail := TempDetail +',' LineDetail
ELSE
TempDetail := LineDetail;
NewFile.WRITE(TempDetail);
END;

Close your two Files and run your dataport
So the string "This string is 3" long, I think","Nah it ain,t"
Will become This string is 3 long I think,Nah it aint

Phew think that covers it! 8)

I have not used INSTREAM, but you might be able to open the file then use CONVERTSTR(MyStream,",","~");

This should convert from comma seperated "," to tilde "~". then just change the seperator in the dataport.

Not sure how to code it, without doing it, so its just an Idea!

The is a common problem so a solution would be worth posting to Tips and Tricks

No simple solution if you cannot get the file delimeter changed, and you say that is not an option.

So is the file text and comma delimited?
"Mr","Fred Flintstone","Cave 1,The Mound","Bedrock","$1,200.00"
Use CHANGESTR replace the "," with a Tilde ~ and then remove the " and ,

Or is it only text qualifed when there is a quote or comma in the string?
Mr,Fred Flintstone,"Cave 1,The Mound",Bedrock,"$1,200.00"
Use STRPOS this ," to find the start point and ", the end and then remove the , or the " and rebuild.