<< Click to Display Table of Contents >> Navigation:  3. Script Language > TXT. Text-File Engine > CSV-Related Commands > Repair_CSV

---

MiniRobotLanguage (MRL)

 

TXT.Rer

TXT.Repair_CSV
Repair loaded CSV-File, especially fixe opened " " that have not been closed.

 

 

 

Intention

 

This command is used repair CSV-Files.Sometime you may see that parts of a CSV-File are not displayed when loaded into Excel etc.

This can happen, if there are opened, and not closed "" inside the file.

This command will either close the "" or remove them if they are open.

If P2 i snot "0" then it will also correct the number of used delimiters per Line to this specified number.

 

' Repair_csv

$$DEL=;

$$ANZ=7

TXT.Rer|$$DEL|$$ANZ

 

 

 

Syntax

 

 

TXT.Rer|P1[|P2]

TXT.Repair_CSV|P1[|P2]

 

 

Parameter Explanation

 

P1 - (Input,numeric) Variable with Delimiter-Character.

P2 - (Output) Variable will contain the number of delimiters per Line, or "0". If given lines with too less delimiters will be completed by adding delimiter characters.

 

 

Example

 

'*****************************************************

'

'*****************************************************

 

 

 

Remarks

 

-

 

Limitations:

 

-

 

 

See also:

 

•   TXT.Load Textfile

•   TXT.Clear

•   TXT.From_Var

•   TXT.Load_pure_Text

•   TXT.Get_pure_Text

•   FIL.Generate numbered Name

•   FIL.Move numbered File

•   ATF - Append-to-File

•   CFF. - Copy-From-File

•   CTF - Copy-To-File

•   COP. - Copy File

•   TXT.Get_Filename

•   TXT.Get_Lenght

•   TXT.To_Var_and_Clear

•     GLC. - Get-Line-Count

•     TXT.Get_Line

•     IEF. / NEF. - If - exist - File

•     LFF - Line-From-File

•     WFF. - Wait-For-File

•     REN. - Rename File/Dir