Removing Special Characters from CSV file and write data back to CSV file

[veerishu (Veeresh Uppin)]

Hi i am trying to remove all possible special characters from CSV file (Description and Amount column) and retain the other data back to the new file or same file. Kindly help.

[Palaniyappan (Forum Leader)]

Hi
welcome to uipath community
–use READ CSV FILE activity and pass the file path of csv file as input and get the output with a variable of type datatable named dt
–now use a OUTPUT DATATABLE activity and mention the input as dt and get the output with variable of type string named str_dt
–then use a assign activity like this
str_dt = System.Text.RegularExpressions.Regex.Match(str_dt.ToString,“[^$–*]+”).ToString

–then use a GENERATE DATATABLE activty and pass the string variable as inptu and get the outptu with a variable of type datatable named finaldt
–now use WRITE CSV FILE activity and pass finaldt as input and form a csv

Cheers @veerishu

[Yoichi]

Hi,

Hope the following helps you.

Value property of each Assign activity are the following.
System.Text.RegularExpressions.Regex.Replace(row("Description").ToString,"[^.\w ]","")

System.Text.RegularExpressions.Regex.Replace(row("Amount").ToString,"[^.\w ]","")

Regards,

[veerishu (Veeresh Uppin)]

@Palaniyappan: Appreciate quick response. Thanks a lot.

The Solution is generating in one single column (As shown in the screenshot). I need the data
written in different columns like shown in my very fist post and for all the data. May be need to use for each row activity. Kindly help

[Palaniyappan (Forum Leader)]

Is comma mentioned as delimiter in generate datatable activity
Kindly check that once pls
@veerishu

[veerishu (Veeresh Uppin)]

@Yoichi Thanks a lot for the reply.

This helps me. However, Could you kindly help me alter the below expression to remove even the unwanted spaces in between

System.Text.RegularExpressions.Regex.Replace(row(“Description”).ToString,“[^.\w ]”,“”)

[balupad14 (Balamurugan)]

Hi,
It is a late reply. But it will be useful to some one.

Here is a package called BalaReva.EasyText . It has an activity called “Find & Replace All”. Using this , you can remove all special charactors.

UiPath Go ! BalaReva.EasyText (Text Format File Utilities Package)

Hi, I have developed a package to make easy the text file format utilities. It is a package to handle the automation for Txt,Csv,Xml ,Json and TextFormat File This package has many activities to handle the text format files like Txt,Csv,Xml ,Json and TextFormat File. The activities are to handle insert,update,delete and other operation. TextScope - It is a scope activity.It keeps only the file path. It doesn’t keep the text file resource. DeleteAt - Delete the line at specific line Find &…

Regards
Balamurugan.S

[Yoichi]

Hi,

If you want to remove all spaces, the following will work.

System.Text.RegularExpressions.Regex.Replace(row("Description").ToString,"[^.\w]","")

IF you want to remove space at the beginning / end of the sentence and replace 2 or more spaces to a space, the following steps will work.

strData = System.Text.RegularExpressions.Regex.Replace(row("Description").ToString,"[^.\w ]","").Trim
row("Description") = System.Text.RegularExpressions.Regex.Replace(strData," {2,}"," ")

Regards,