Remove comas from data table or txt

Help Activities
, ,
1

I am reading an Excel sheet then feeding the data table output into a write txt - however there are comas included. Is there a way I can remove the comas?

2

@E.T.S

Hi

Use this

Outputtxt.replace(“,”,“”)

Output txt is the output of outputdatatable activity

3

Would I use this in an assign?

4

@E.T.S

Yes

If your datatable output is converted to text format then this will help

5

Show us the data. If you are seeing commas it may be treating it as a CSV. Is the file .xlsx or .csv? Are you using Write Text or Write CSV?

6

Hi @E.T.S

You can use the data manipulation to achieve this.
Use the replace function to replace the comma(,) with a empty value.
Store the text in a String variable, let’s name the variable as InputStr.

InputStr.Replace(",","")

The above expression will replace the comma with Empty value.

If you want to remove the comma in the excel, use the find\replace value activity which is the modern excel activity.

Hope it helps!!

7

Thank you for your reply!

That didn’t work the txt file still had comas

8

Thank you for your reply!

I am using write text from an Excel file

9

Thank you for your reply!

There are no comas in the Excel

1 Like
10

Hi @E.T.S

When you store the output in a variable it will be of type string. Use the below condition in assign activity:

str_Text= str_Text.Replace(",","")

This will replace the the , and store the output to the same variable. You can use that variable in further process.

Regards,

11

@E.T.S

Can you explain your output is in which form like datatable or string format

12

Okay then use the below expression to remove the commas in the text.

InputStr.Replace(",","")

Hope you understand!!

13

image
image563×553 11.9 KB

14

Unfortunately that didn’t work, the txt file still had comas

15

@E.T.S

if possible can you share the output of output datatable

16

Okay @E.T.S

The output datatable activity converts the datatable to String format.
You have used Write Text File activity to write the String data to the notepad file.

By using string data you can remove the comma symbol.

17

The format of the data table is like this:

image
image1601×291 18.4 KB

18

I’ve used this in the assign but the txt file still has comas :
image

19

@E.T.S

image
for me its getting removed

or try this

outputstr=System.Text.RegularExpressions.Regex.Replace(inputstr,“,”,“”)

inputstr is the your input text

can you share the text

20

Hi @E.T.S ,

Could you provide us with the Sample Data and the Expected Output for it ? When replacing the Commas we might also lose some data representations or the actual value the data holds, So we would ask you provide us the Expected Representation and then we can provide more accurate suggestions on the same.