Six Stars

Issue Regarding Violated Column in Excel

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().

Screenshot (37).pngTotal_Calls row is Violated by three semicolons

2 ACCEPTED SOLUTIONS

Accepted Solutions
Twelve Stars

Re: Issue Regarding Violated Column in Excel

@meetmahajan,can you use below funtion in tMap.

 

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

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

Manohar B
Forteen Stars TRF
Forteen Stars

Re: Issue Regarding Violated Column in Excel

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

TRF
3 REPLIES
Twelve Stars

Re: Issue Regarding Violated Column in Excel

@meetmahajan,can you use below funtion in tMap.

 

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

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

Manohar B
Forteen Stars TRF
Forteen Stars

Re: Issue Regarding Violated Column in Excel

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

TRF
Six Stars

Re: Issue Regarding Violated Column in Excel

@manodwhb @TRF

Thank you so much 

Both Method Works very Well :-)Screenshot (38).png