Convert CSV File To Excel File "Delimiter problem"

[Teaf]

I have CSV file " Below Snapshot" I need to convert it to excel . I tried Csv To Excel activity but based on Delimiter which is “,” also spilt some value in credit and Balance because value contain " , " .

I tried to reach Debit and Balance data to change format before convert it to excel but unfortunately i can’t.

Could anyone help me please? Thanks

[Yoichi]

Hi,

Which activity do you use? Is “Csv To Excel activity” custom activity?

Did you already try ReadCSV activity and WriteRange activity?

Regards,

[Teaf]

Yes I tried Csv To Excel activity, ReadCSV activity and WriteRange activity.

[Yoichi]

Hi,

Can you share your csv data as file? it’s no problem if dummy data.

Regards,

[Teaf]

File.zip (340 Bytes)

[Yoichi]

Hi,

Thank you for sharing.
The following sample is parse csv then write it to excel. it seems to work correctly. Isn’t it what you expect? If not, can you share your expected output?

Sample20220112-3.zip (2.5 KB)

Regards,

[Teaf]

Thanks!

But You write all data in " A1 " I need to be like a table to reach specific column.

Such as :
In the below pic first I skip the first 6 Rows then Use for each activity to print Debit data.

[Yoichi]

Hi,

Can you try to re-read from “A7” as the following?

Regards,

[Teaf]

Hi

Also not read Credit Colum

[Yoichi]

Hi,

It’s because your column name in original data has extra space as the following.

So you need to access the column like "Debit " or "Credit ".

Regards,

[Teaf]

Thanks !!