Issue Regarding Violated Column in Excel

[Anonymous]

I have a CSV File in which last Row is violated, ScreenShot is being Attached Below. 

How can i remove 3 semicolons using StringHandling.ERREPLACE() i.e.

which syntax will be use to remove 3 semicolons ";;;" using StringHandling.ERREPLACE().

Total_Calls row is Violated by three semicolons

[manodwhb · Accepted solution]

@meetmahajan,can you use below funtion in tMap.

row1.total.replace(";","")

row1.total.replaceAll(";","")

[TRF]

Try StringHandling.ERREPLACE(yourString, ";;;$", "") or StringHandling.ERREPLACE(yourString, "\;\;\;$", "")

[Anonymous]

@manodwhb @TRF

Thank you so much 

Both Method Works very Well 🙂