How to split word and number ( NRS 1200 ) of excel column price in UiPath

[Bammy (GNIEY)]

how to split word and number ( NRS 1200 ) of excel column price in UiPath

[lrtetala (Lakshman Reddy)]

Hi @Bammy

Use this in Invoke Code activity

DT.AsEnumerable.ToList.ForEach(Sub(r)
    r(3)=r(3).ToString.Split(" "c).Last()
End Sub
)

Cheers!!

[ppr (Peter Preuss)]

Have a look here, using Regex

refering to the groups:

[CheatSheet] - System.Text.RegularExpressions | RegEx

This CheatSheet introduces the basic use of regex functions. With further examples also special cases are presented. Introduction From the namespace System.Text.RegularExpressions following methods are offered: Regex.Match Regex.Matches Regex.isMatch Regex.Replace Regex.Split A simple usage for example would look like this: [grafik] Recommendation: add System.Text.RegularExpressions to the imports: [grafik] it allows to use the shortened statement, as the namespace part can be ommited…

[Gayathri_Mk]

You can use SPlit method also Split with space
Then you can assign those and use them as required.

[Parvathy (PS Parvathy)]

Hi @Bammy

=> Build Data Table

Output-> resultTable

=> Read Range Workbook

Output-> dt

=> Use below syntax in Assign:
resultTable = (From row In dt.AsEnumerable() Let parts = row.Field(Of String)("Price").Split(New String() {" "}, StringSplitOptions.RemoveEmptyEntries) Select resultRow = resultTable.Rows.Add(parts.FirstOrDefault(), If(parts.Length > 1, Integer.Parse(parts(1)), Nothing)) ).CopyToDataTable()

=> Write Range Workbook dt

Hope it helps!!

[lrtetala (Lakshman Reddy)]

@Bammy

Please try this

DT.AsEnumerable.ToList.ForEach(Sub(r)
    r(4)=r(3).ToString.Split(" "c).First()
	r(3)=r(3).ToString.Split(" "c).Last()
    End Sub
)

Input:

Output:

Cheers!!

[Jayesh_678 (Jayesh)]

Hi @Bammy

Input:-

Output:-

Xaml File:-
Split datacolumn forum.zip (3.6 KB)

If this works for you, please mark it as a solution. So others can refer the same.

Thanks