Apolline Descy 

I spent some time on this and I think the filetype may have a bug.  At least only I think this... I need to validate it through support as it won't be the first time they explain to me how to make it work.

But in the meantime, if it helps, I found a workaround via Excel.

First of all I convert the RenPy file to Excel with a powershell script like this (or copy paste into Excel... script may be useful if you have multiple files):

# Import the required module
# Install it first if not already installed: Install-Module -Name ImportExcel
Import-Module ImportExcel

# Initialize an empty array to store the lines
$lines = @()

# Read the content of the text file line by line
Get-Content -Path 'c:\Users\pfilkin\Documents\SDL\TESTING\Apolline Descy\RenPy.rpy' | ForEach-Object {
    # Add each line to the array
    $lines += $_
}

# Create an Excel worksheet with the lines
$lines | Export-Excel -Path 'c:\Users\pfilkin\Documents\SDL\TESTING\Apolline Descy\RenPy.rpy.xlsx' -WorksheetName 'Sheet1' -AutoSize

Write-Host "Excel file has been created."

Then I can easily do this:

Placeholder Rules are:

^#.+?$

^([^"]*)"

"[^"]*$

^[^"]*$

Tag Pair is:

\\" and \\"

So I can translate the file:

Save the target:

Then either copy this into a text file and rename as an *.rpy file.. or use an Excel macro to do this for me:

Sub ExportToRenPy()
    Dim ws As Worksheet
    Dim LastRow As Long
    Dim i As Long
    Dim RenPyContent As String
    Dim FilePath As String
    
    ' Set the worksheet and find the last row with content in column A
    Set ws = ThisWorkbook.Sheets(1)
    LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
    
    ' Loop through each cell in column A to concatenate into a single string
    For i = 1 To LastRow
        RenPyContent = RenPyContent & ws.Cells(i, 1).Value & vbCrLf
    Next i
    
    ' Set the file path for saving
    FilePath = "c:\Users\pfilkin\Documents\SDL\TESTING\Apolline Descy\t_RenPy.rpy"
    
    ' Create a text file and write the content
    Open FilePath For Output As #1
    Print #1, RenPyContent
    Close #1
    
    MsgBox "RenPy file has been created."
End Sub

Final file looking like this:

# game/script/ch1.rpy:34
translate french ch1_308a744b:

# "This is example sentence 1."
"Questa è la frase di esempio 1."

# game/script/ch1.rpy:38
translate french ch1_baea3297:

# "This is example sentence 2."
"Questa è la frase di esempio 2."

# game/script/ch1.rpy:160
translate french ch1_7835ba72:

# sato vill cldo opes norm "Alcune frasi \"lo\" fanno quando l'autore vuole usare le virgolette visualizzate in gioco."
sato vill cldo opes norm "Alcune frasi \"lo\" fanno quando l'autore vuole usare le virgolette visualizzate in gioco."

# game/script/ch1.rpy:161
translate french ch1_fcb8c042:

# taku clot surp weeh "And a last example." with vpunch
taku clot surp weeh "E un ultimo esempio." with vpunch

Seems like a long workaround, but it's actually pretty quick and I put the code here so you could adapt if you have multiple files to deal with.

In the meantime I will log the problem with the regex delimited filetype so the support team can take a look and let you now if it was a bug, or if I also need a lesson in how to make it work properly!

 Apolline Descy 

I spent some time on this and I think the filetype may have a bug.  At least only I think this... I need to validate it through support as it won't be the first time they explain to me how to make it work.

But in the meantime, if it helps, I found a workaround via Excel.

First of all I convert the RenPy file to Excel with a powershell script like this (or copy paste into Excel... script may be useful if you have multiple files):

# Import the required module
# Install it first if not already installed: Install-Module -Name ImportExcel
Import-Module ImportExcel

# Initialize an empty array to store the lines
$lines = @()

# Read the content of the text file line by line
Get-Content -Path 'c:\Users\pfilkin\Documents\SDL\TESTING\Apolline Descy\RenPy.rpy' | ForEach-Object {
    # Add each line to the array
    $lines += $_
}

# Create an Excel worksheet with the lines
$lines | Export-Excel -Path 'c:\Users\pfilkin\Documents\SDL\TESTING\Apolline Descy\RenPy.rpy.xlsx' -WorksheetName 'Sheet1' -AutoSize

Write-Host "Excel file has been created."

Then I can easily do this:

Placeholder Rules are:

^#.+?$

^([^"]*)"

"[^"]*$

^[^"]*$

Tag Pair is:

\\" and \\"

So I can translate the file:

Save the target:

Then either copy this into a text file and rename as an *.rpy file.. or use an Excel macro to do this for me:

Sub ExportToRenPy()
    Dim ws As Worksheet
    Dim LastRow As Long
    Dim i As Long
    Dim RenPyContent As String
    Dim FilePath As String
    
    ' Set the worksheet and find the last row with content in column A
    Set ws = ThisWorkbook.Sheets(1)
    LastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
    
    ' Loop through each cell in column A to concatenate into a single string
    For i = 1 To LastRow
        RenPyContent = RenPyContent & ws.Cells(i, 1).Value & vbCrLf
    Next i
    
    ' Set the file path for saving
    FilePath = "c:\Users\pfilkin\Documents\SDL\TESTING\Apolline Descy\t_RenPy.rpy"
    
    ' Create a text file and write the content
    Open FilePath For Output As #1
    Print #1, RenPyContent
    Close #1
    
    MsgBox "RenPy file has been created."
End Sub

Final file looking like this:

# game/script/ch1.rpy:34
translate french ch1_308a744b:

# "This is example sentence 1."
"Questa è la frase di esempio 1."

# game/script/ch1.rpy:38
translate french ch1_baea3297:

# "This is example sentence 2."
"Questa è la frase di esempio 2."

# game/script/ch1.rpy:160
translate french ch1_7835ba72:

# sato vill cldo opes norm "Alcune frasi \"lo\" fanno quando l'autore vuole usare le virgolette visualizzate in gioco."
sato vill cldo opes norm "Alcune frasi \"lo\" fanno quando l'autore vuole usare le virgolette visualizzate in gioco."

# game/script/ch1.rpy:161
translate french ch1_fcb8c042:

# taku clot surp weeh "And a last example." with vpunch
taku clot surp weeh "E un ultimo esempio." with vpunch

Seems like a long workaround, but it's actually pretty quick and I put the code here so you could adapt if you have multiple files to deal with.

In the meantime I will log the problem with the regex delimited filetype so the support team can take a look and let you now if it was a bug, or if I also need a lesson in how to make it work properly!