I have a large text file I need to get a number from. I use the ‘Text to Left/Right’ activity then …Regex.Matches… to get the number (see below). When the number does not have commas, it works great. However, when commas are present, it pulls the number(s) to the left of the first comma. For example, if the number is 867,281 it pulls 867. I need it to pull 867281.
WOW! Thank you so much! I spent hours/days on google and YouTube looking for an answer to no avail and this forum provided the solution in minutes. I REALLY appreciate it!