Answered

I want to add double quotation to each item when writing CSV.

(0) Share

Report

Posted on by NAGARJ

Hi Community,

I want to add double quotation to each item when writing CSV.
I'm going to export the Query Result to CSV.
Is it possible with the Power Automate desktop?

ex)
aaa,bbb,ccc --> "aaa","bbb","ccc"

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Henrik_M 2,021 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Paste this into your workflow and have a look:

SET Text TO $'''aaa,bbb,ccc''' Text.SplitText.SplitWithDelimiter Text: Text CustomDelimiter: $''',''' IsRegEx: False Result=> TextList LOOP i FROM 0 TO TextList.Count - 1 STEP 1 SET TextList[i] TO $'''\"%TextList[i]%\"''' END

Was this reply helpful? Yes No
NAGARJ 12 on at

Like (0)

Report
Copy link

Link copied!
Thank you for your answer.

My csv data has 4500 rows and 6 columns.
The loop method is time consuming.

I thought about using regular expressions as another method.
SET Path TO $'''D:\\DataFolder\\DataFile_20220214.csv'''
File.ReadTextFromFile.ReadText File: Path Encoding: File.TextFileEncoding.ANSI Content=> FileContents
Text.Replace Text: FileContents TextToFind: $'''(.*?)(,|\\r?\\n|\\r)''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''\"$1\"$2''' ActivateEscapeSequences: False Result=> Replaced
File.WriteText File: $'''D:\\DataFolder\\DataFile_20220214.csv''' TextToWrite: FileContents AppendNewLine: True IfFileExists: File.IfFileExists.Overwrite Encoding: File.FileEncoding.ANSI

The variable "Replaced" had double quotes.
However, the actual csv file did not have double quotation.

please help me.

(I'm using the Japanese version.)

Was this reply helpful? Yes No
Verified answer

NAGARJ 12 on at

Like (0)

Report
Copy link

Link copied!
This issue has been resolved in the following ways!
SET Path TO $'''D:\\DataFolder\\DataFile_20220214.csv'''
File.ReadTextFromFile.ReadText File: Path Encoding: File.TextFileEncoding.ANSI Content=> FileContents
Text.AppendLine Text: FileContents LineToAppend: $'''''' Result=> Result
Text.Replace Text: Result TextToFind: $'''(.*?)(,|\\r?\\n|\\r)''' IsRegEx: True IgnoreCase: False ReplaceWith: $'''\"$1\"$2''' ActivateEscapeSequences: False Result=> Replaced
File.WriteText File: $'''D:\\DataFolder\\DataFile_20220214.csv''' TextToWrite: Replaced AppendNewLine: False IfFileExists: File.IfFileExists.Overwrite Encoding: File.FileEncoding.ANSI

Was this reply helpful? Yes No