How to convert 1.475

Help Activities
,
1

How to convert value of a row

If a column has multiple rows

Column
0.05
0.23
1.475
1.433

Then the output should be
Column
0.05
0.23
1.48
1.43

This need to be handled in a notepad and not Excel

2

Have a look here:
grafik

1 Like
3

@dipon1112000

String.Join(Environment.NewLine, File.ReadLines("C:\Users\rlgandu\Downloads\N1.txt").Select(Function(line, index) If(index = 0, line, Double.Parse(line).ToString("F2"))))

image
image953Ă—535 16.6 KB

Output:
image

1 Like
4

Hi @dipon1112000

modifiedContent=String.Join(Environment.NewLine, str1.Split(Environment.NewLine.ToCharArray()).Select(Function(line) If(Double.TryParse(line, Nothing), Math.Round(Convert.ToDouble(line), 2).ToString(), line)))

image
image1366Ă—694 39 KB

Hope it helps!!

1 Like
5

Hi thanks a lot but can I use the below format

String.Join(Environment.NewLine,column(“Percent”).Select(Function(line, index) If(index = 0, line, Double.Parse(line).ToString(“F2”))))

As the fraction is present in column (Percent)

6

@dipon1112000
we would recommend the following

  • Read CSV Activity (first line is header)
  • Convert within a for each row in DataTable
    • CDbl…toSring(“F2”) as shown above
  • Write CSV Activity

just ensure that the delimiter char is correctly defined

1 Like
7

@dipon1112000

Sequence:
Read Text File activity (output variable: notepadContent)
Assign activity:
transformedContent = String.Join(Environment.NewLine, notepadContent.Split(Environment.NewLine.ToCharArray, StringSplitOptions.RemoveEmptyEntries).Select(Function(value) If(String.IsNullOrWhiteSpace(value), value, Double.Parse(value).ToString(“F2”))))
Write Text File activity (input: transformedContent)

8

@dipon1112000

Find the zip file

Forum.zip (470.5 KB)

Hope it helps!!

9

hi I have input as text1 but I have called it under read CSV with dt1 as datatable. So what should I write before Split (as the requirement is to convert the value of “Percent” (name of the Column) which is getting added to dt1 based on division method

17059301495867507246663455257720
170593014958675072466634552577201920Ă—1440 239 KB

10

A flow like:

grafik
grafik477Ă—751 42.8 KB

will convert input:
grafik
to output:
grafik

11

Thank you very much, can you share the xaml

12

as it is just about 3 Activities, start to modell it by your own.
The XAML has a too high risk to be incompatible with your UiPath Studio Project.

we used
row("Column") = CDbl(row("Column").toString.Trim).ToString("F2")

13

Thank you :pray: very much :pray:

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.