Hello,
i have requirement where i need to open csv as notepad and save that file with notepad with encoding utf with bom. utf -8 with bom option is not there in my notepad.
can you help me with same , how can i achieve this.
Activities:
Start Process:
- FileName: “C:\path\to\your\file.csv”
- UseShellExecute: True
- CreateNoWindow: False
Delay (Optional)
Type Into:
- Text: “^(+{F10})E”
Delay (Optional)
Type Into:
- Text: “{DOWN 3}{ENTER}”
Delay (Optional)
Type Into:
- Text: “{BOM}”
Type Into:
- Text: “~”
i cannot see below options in start process activity
- UseShellExecute: True
- CreateNoWindow: False
Any specific reasons to do the character encoding change via Notepad and not by:
- File.ReadAllText
- File.WriteAllText along with configured encoding
OR
Text Read/ Write Activities
This will work for you try this
Assign csvWithBOM = ChrW(&HEF) + ChrW(&HBB) + ChrW(&HBF) + YourReadTextString
if utf-8 with bom iis not there in notepad option , still it will save ?
u have mentioned “assign csvWithBOM = ChrW(&HEF) + ChrW(&HBB) + ChrW(&HBF) + YourReadTextString” csvwithBOM varaible and mentioned Res_String in workflow.
what is there in read file -csv file?
Yes,
Res_String= ChrW(&HEF) + ChrW(&HBB) + ChrW(&HBF) + YourReadTextString”
If you got the result please mark it as “Solution”
file generated but with no extension
how to know file is with utf 8 bom or not
Open your generated output file
Notepad files are store in .txt extension
Open the output file in click on “File” and then “save as” in that you able to see
Follow this procedure you are able to know the “extension” and encoding type
But my encoding type is “UTF-8 with bom” why it differs you
If you find solution for this Query please mark it as solution to close the loop.
Happy Automation
Regards,
ashokkarale
Yoichi
lrtetala
naveen.s
Anil_G
PeCour
Ahmad_Rais
AJ_Ask
Soudios
chunkin.zhang