How to delete comma(,) to the last row in C#

Help StudioX
,
1

Here is my filterdata output
‘41a7637f-bf62-4a82-9299’,
'f00463ea-af88-41b4-9d36,

I need to remove comma(,) of the last line in text box
Used TrimeEnd(“,”) but it remove all comma’s
USed Trim also
used (str).Remove(str.Length-1)

2

hey,
you can use
TEXT.trimEnd(","c)
where TEXT is string Variable
Thanks,
Rounak

3

image
with that expression facing the syntax error and my process is in C#

4

Hey,
In C#
you can write
TEXT.TrimEnd(‘,’)

Thanks

5

Hi,

Can you try the syntax in below,

strinput.Remove(strinput.Length-1,1)

Capture

6

Hey!

Can we try this:

StringVariable.Substring(0,StringVariable.Length-1);

Regards,
NaNi

7

with these expression the bot removes all comma(,) for all rows

8

with these expression the bot removes all comma(,) for all rows

I have rows in the input and i need to remove the comma(,) to last row

9

so the input is in excel and you need to remove for the lastrow in excel file or while writing to excel?

10

My input is in rows and i need to remove Comma for the last row only

11

Could please share the screenshot image of output like, how output looks like

12

These is my input
‘41a7637f-bf62-4a82-9299-be1e392483a2’,
‘f00463ea-af88-41b4-9d36-5ec3dc0b14df’,
‘c511c7a7-f756-44c5-943c-2e8df7355b95’,
‘d8fa4837-098c-4bff-9ba3-d37bfff1d12e’,
‘e3baa1a8-14a2-4b56-9a86-df1fa27832bb’,
So the output sholud be in
‘41a7637f-bf62-4a82-9299-be1e392483a2’,
‘f00463ea-af88-41b4-9d36-5ec3dc0b14df’,
‘c511c7a7-f756-44c5-943c-2e8df7355b95’,
‘d8fa4837-098c-4bff-9ba3-d37bfff1d12e’,
‘e3baa1a8-14a2-4b56-9a86-df1fa27832bb’

13

Hey!

Could you please provide some more details…

What we actually trying to do here?

From where we’re getting this data?

I mean is this a text file or CSV or Excel file?

Regards,
NaNi

14

Try this:

StringVariable.remove(StringVariable.LastIndexOf(","))

Reference:

Remove,
Remove,1424×588 24.2 KB

Regards,
NaNi

15

I am getting the data from FilterDataTable and i am trying to append into text file and then tying to remove the comma for the last row in that text file…

1 Like
16

Try this and let me know…

This will remove the last comma which is present in the text…

Regards,
NaNi

17

thanks for your response bro

1 Like
18

Are you getting this because you’re concatenating multiple values and adding “,” at the end each time? Like…

For Each

  • myVar = myVar + someString + “,”
    End For Each

If so, do it the other way around. Use an If to see if it’s the first value. If it is not the first value, add a comma:

For Each

  • If someString.IsNullOrEmpty
    – Then myVar = someString
    – Else myVar = myVar + “,” + someString
    End For Each

Then when it’s done you won’t have the , at the end.

19

Hey!

Mark the appropriate post as solution and close the thread

Regards,
NaNi

1 Like
20

No, the case is different…

Regards,
NaNi