How to point to specific column in for each row in data table

[anon40731888]

Hello

I have a data table

Name Surname Birthplace

Mark Jason NY
Emily Wo*od London

Sometimes in my Surname colum there is “*” which I need to delete, the problem is that I need to delete * for every row but only in Surname column.

How do I point that I only want to do this in Surname column?

[Shiva_Nikhil]

@anon40731888

currentrow(“Surname”).tostring

value to find *

replace with “”

cheers

[anon40731888]

I change Item CurrentRow to what you said?

[anon40731888]

@Shiva_Nikhil

currentrow(“Surname”).tostring

oh Ok i do it in find and replace but then how do I make it so that the data table is updated without * ?

[Shiva_Nikhil]

@anon40731888

is this you are expecting or any other

let me know

[anon40731888]

Yes I understand but how do I keep my data table updated now without the *?

[Shiva_Nikhil]

@anon40731888

yes it will get updated

cheers

[anon40731888]

Do you know what I mean? I will change and replace but then will it be automaticaly saved to my data table?

[Shiva_Nikhil]

@anon40731888

yes it will automatically saved to that datatable

i have tried in another way it aslo working

cheers

[anon40731888]

it dont save automaticaly for me,

[Shiva_Nikhil]

@anon40731888

have created output for find and replace activity

if so pass it by using assign activity

as mentioned in the image

cheers

[anon40731888]

Any ideas :(?

[Shiva_Nikhil]

@anon40731888

CurrentRow(“ColumnName”)=star_deleted_column

cheers