Data clean td HTML, REPLACECHAR

[LindaD]

Can anyone help on how to get rid of these <td>. I am not familiar with Regex how would I use that. But will take anything that will help. I AM NEW to all of this..UPDATE I added the workflow

[echuong1]

The easiest way to remove this is with a Formula tool. Your expression would look like this:

replace([field], '<tr>','')

[LindaD]

Thanks I tried that earlier and it left this and I am still having problems trying to remove the all of the stuff inside of the punctuation 

[echuong1]

What are you trying to parse specifically?

Can you upload a "before" and "after" of the dataset?

[LindaD]

Sorry new to all this, I am just trying to get the numbers in the middle and all of the html stuff (letters, punctuations)out not sure..Does this help?

[echuong1]

Try using RegEx. The following should work: <td>(\d.*)<

You can then use the data cleansing to remove the commas.

[LindaD]

Sorry I don't know Regex and I tried that way and it did't work for me haha..so I downloaded the workflow maybe this can help? Thanks for your patience I am a begin in all of this IT world

[echuong1]

Are you able to upload the file? The regex I provided should work based on the screenshot.

Otherwise, I unfortunately can't really help provided the limited context.

[LindaD]

Yes I did post in back in the original question, no worries here it is

[echuong1]

You posted the .yxmd, this is just the workflow (settings). It does not contain any data. Can you upload the actual .csv?